Master Excel Formulas

TechBeginnerHome

90 minutes

5 steps

·Beginner

After 90 min: An automated spreadsheet that calculates and analyzes data without manual work

What you need

LaptopExcel or Google Sheets

The 90-Minute Plan

Learn Formula Syntax0–15 min

Understand that formulas start with =. Practice simple math: =SUM(A1:A5), =AVERAGE(B1:B10).

Create a Budget Sheet15–35 min

Build a spreadsheet with income and expenses. Use SUM to total each category.

Use IF Statements35–55 min

Add a column that flags expenses over $100 using =IF(B2>100,"High","Low").

Apply VLOOKUP55–75 min

Create a lookup table and use VLOOKUP to find values. Practice with product names and prices.

Ship & next steps75–90 min

Format your sheet nicely and share it. Next: explore pivot tables and charts.

Pro Tip

Use named ranges to make formulas easier to read. Test edge cases.

90 min·5 steps

TechIntermediate

After 90 min: Automated data summaries and insights from large datasets without writing formulas

6,789

see the plan

90 min·5 steps

TechAdvanced

After 90 min: Automated data pipelines that extract, transform, and load data from multiple sources

6,543

see the plan

90 min·5 steps

TechBeginner

After 90 min: A working Python program that solves a real problem

8,743

see the plan

90 min·5 steps

TechBeginner

After 90 min: A live webpage about your interests visible in a browser

11,205

see the plan