Excel Fundamentals

Summary

Cell references, ranges, basic formulas and workbook structure — the baseline fluency almost every analyst job assumes you already have on day one.

• 1Practice absolute vs relative cell references ($A$1 vs A1) until it's automatic.
• 2Learn to structure a workbook with clearly separated raw data, calculations, and outputs.
• 3Build a small budget or tracker spreadsheet from scratch as practice.