Explore
Career Tracks
Free Courses
Practice Labs
SQL Benchmark
Work Experience
Job Hunt Tracker
Portfolio Projects
AI Resume Grader
Career Tracks
Free Courses
Practice
Projects
For Employers
Blog
Support
INR
Sign in
Micro Free Courses
Excel for Data Analytics (Short & Focused)
19 lessons
1. THE EXCEL ESSENTIALS
Video lesson
1. Interface & Navigation
7m
Video lesson
2. Cell Referencing
12m
Interactive tutorial
3. QUIZ: Excel Basics
5m
2. EXCEL CLEANING & LOGIC
Video lesson
1. Data Cleaning
21m
Video lesson
2. Text Functions & Data Quality
15m
Interactive tutorial
3. QUIZ: Data Cleaning
6m
Video lesson
4. Lookup Functions
5m
Interactive tutorial
5. QUIZ: Lookup functions
6m
Video lesson
6. Logical & Math Functions
8m
Reading
7. GUIDE: Logical & Math Functions (IF, COUNTIF, AVERAGEIF)
3m
Project submission
8. SUBMISSION: Module 2
32m
3. EXCEL PIVOT TABLES
Video lesson
1. Pivot Table Basics
6m
Video lesson
2. Interactivity
3m
Video lesson
3. Conditional Formatting & Charts
8m
Reading
4. GUIDE: Report Connections, Date Grouping & Formatting
3m
Interactive tutorial
5. QUIZ: Pivot Tables
6m
Project submission
6. SUBMISSION: Pivot Tables
32m
4. EXCEL DASHBOARDS
Video lesson
1. Building the Dashboard
11m
Project submission
2. SUBMISSION: Dashboard
33m
Browse Topfolio
All courses
Practice
Projects
Career tracks
Home
/
Courses
/
Excel for Data Analytics (Short & Focused)
/
EXCEL PIVOT TABLES
/
QUIZ: Pivot Tables
Back to EXCEL PIVOT TABLES
QUIZ: Pivot Tables
6 minutes
Interactive tutorial
Loading lesson...
Feedback
