🛠️ 04 Projects¶
Hands-on projects that combine multiple chapters. Each ships with a sample dataset (CSV) and a step-by-step walkthrough that produces a working spreadsheet, report, or dashboard.
🛠️ Project Index¶
| # | Project | Skills Used | Open |
|---|---|---|---|
| 01 | Sales Dashboard | PivotTables, Charts, Lookups | Start |
| 02 | Personal Budget Tracker | Formulas, Conditional Formatting, Validation | Start |
| 03 | Survey Data Analysis | COUNTIF, Text/Logical Functions, Charts | Start |
| 04 | Inventory Manager | Lookups, Data Validation, IF alerts | Start |
| 05 | Data Cleaning Challenge | Text functions, Remove Duplicates, Power Query | Start |
Each project folder contains a README.md (goal, dataset description, and guided walkthrough) plus one or more .csv data files you can import into Excel to follow along.