Spreadsheets & Excel
4 articles
- Jun 1, 2026
How to Read and Understand Complex Excel Formulas (Step by Step)
Inherited a formula like =IFERROR(INDEX(B:B,MATCH(F2,A:A,0)),"Not found")? Here's a systematic approach to reading it from the inside out.
- Jun 1, 2026
Excel Formula Reference: VLOOKUP, INDEX/MATCH, SUMIF, IF, and 20 More Explained
Plain-English explanations of the 22 Excel functions every analyst and business user should know — with what each one does, when to use it, and a simple example.
- Jun 1, 2026
10 Excel Formulas Every Data Analyst Should Know
Ten formulas that cover 90% of what analysts do in Excel: looking up values, summing and counting with conditions, filtering, and handling errors.
- Jun 1, 2026
VLOOKUP vs. INDEX/MATCH: Which Excel Formula Should You Use?
VLOOKUP is simpler. INDEX/MATCH is more flexible. Here's when each is the right choice — and when XLOOKUP replaces both.