📊 01 Notes¶
Topic-by-topic notes on using Microsoft Excel for data analytics, from absolute basics to dashboards and What-If analysis. Each note stands alone and links to its matching exercise.
🧭 Chapter Index¶
| # | Topic | Note | Practice |
|---|---|---|---|
| 01 | Introduction to Excel for Data Analytics | Read | Exercise |
| 02 | Entering & Organizing Data | Read | Exercise |
| 03 | Formulas & Cell References | Read | Exercise |
| 04 | Essential Functions (Count, Sum & Statistical) | Read | Exercise |
| 05 | Logical Functions | Read | Exercise |
| 06 | Text Functions | Read | Exercise |
| 07 | Date & Time Functions | Read | Exercise |
| 08 | Lookup & Reference Functions | Read | Exercise |
| 09 | Data Cleaning & Validation | Read | Exercise |
| 10 | Sorting, Filtering & Conditional Formatting | Read | Exercise |
| 11 | PivotTables & PivotCharts | Read | Exercise |
| 12 | Charts, Dashboards & What-If Analysis | Read | Exercise |