✍️ 02 Exercises¶
Hands-on practice for each chapter. Read the matching note first, then work through the steps in Excel and check your reasoning against the answers.
✍️ Exercise Index¶
| # | Topic | Exercise | Note |
|---|---|---|---|
| 01 | Introduction to Excel for Data Analytics | Practice | Note |
| 02 | Entering & Organizing Data | Practice | Note |
| 03 | Formulas & Cell References | Practice | Note |
| 04 | Essential Functions | Practice | Note |
| 05 | Logical Functions | Practice | Note |
| 06 | Text Functions | Practice | Note |
| 07 | Date & Time Functions | Practice | Note |
| 08 | Lookup & Reference Functions | Practice | Note |
| 09 | Data Cleaning & Validation | Practice | Note |
| 10 | Sorting, Filtering & Conditional Formatting | Practice | Note |
| 11 | PivotTables & PivotCharts | Practice | Note |
| 12 | Charts, Dashboards & What-If Analysis | Practice | Note |