Level 1 · Entry Foundations¶
Goal: get comfortable navigating Excel, write real formulas, format and visualize data, look values up across sheets, and finish with a working personal budget tracker built from scratch.
Modules¶
- Excel Fundamentals
- Formulas & Functions Basics
- Formatting & Conditional Formatting
- Working with Tables
- Charts & Basic Visualization
- Lookup Functions
- Logical Functions
- PivotTables Basics
- Data Validation & Cleaning
- Project — Personal Budget Tracker
By the end of this level you'll be comfortable navigating the Excel
interface, writing formulas with correct relative/absolute references,
formatting and charting data, looking values up with VLOOKUP/XLOOKUP,
building logic with IF, summarizing data with PivotTables, and cleaning
messy input — and you'll have produced a small real deliverable: a personal
budget tracker with its own formulas, formatting, and a summary chart.