Module 1 – Data Visualization & Cleansing
- Conditional formatting
- More on charts (bar, histogram, pie charts)
- Sort & Filter (removing duplicate data)
- Module Quiz
Module 2 — Data Organization using Pivot Tables
- Creating tables & summarizing data using Pivot tables
- Pivot Chart
- Module Quiz
Module 3 — Advanced Functions for Data Analytics
- AutoFill, and automatically-updating fields
- Arithmetic functions (SUM, AVERAGE, etc.)
- VLOOKUP and IFERROR
- Module Quiz
Curriculum
- 3 Sections
- 3 Lessons
- 6 Weeks
Expand all sectionsCollapse all sections
- Module One: Data Visualization & Cleansing2
- Module Two: Data Organization using Pivot Tables2
- Module Three: Advanced Functions for Data Analytics2
