Data Analytics with Excel¶
Microsoft Excel for data analytics — organized for fast learning, practice, and hands-on projects, from absolute basics to dashboards and What-If analysis.
Course Flow¶
- Read the topic notes for the current chapter.
- Work through the matching exercise.
- Test yourself in the quiz hub (25 random questions per attempt).
- Build a project to apply the skills to real data.
Chapters¶
| # | Topic | Start |
|---|---|---|
| 01 | Introduction to Excel for Data Analytics | Introduction |
| 02 | Entering & Organizing Data | Entering & Organizing Data |
| 03 | Formulas & Cell References | Formulas & Cell References |
| 04 | Essential Functions (Count, Sum & Statistical) | Essential Functions |
| 05 | Logical Functions | Logical Functions |
| 06 | Text Functions | Text Functions |
| 07 | Date & Time Functions | Date & Time Functions |
| 08 | Lookup & Reference Functions | Lookup & Reference |
| 09 | Data Cleaning & Validation | Data Cleaning & Validation |
| 10 | Sorting, Filtering & Conditional Formatting | Sort, Filter & Format |
| 11 | PivotTables & PivotCharts | PivotTables |
| 12 | Charts, Dashboards & What-If Analysis | Charts & Dashboards |