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
6m
Video lesson
2. Cell Referencing
8m
Interactive tutorial
3. QUIZ: Excel Basics
15m
2. EXCEL CLEANING & LOGIC
Video lesson
1. Data Cleaning
10m
Video lesson
2. Text Functions & Data Quality
12m
Interactive tutorial
3. QUIZ: Data Cleaning
20m
Video lesson
4. Lookup Functions
10m
Interactive tutorial
5. QUIZ: Lookup functions
15m
Video lesson
6. Logical & Math Functions
15m
Reading
7. GUIDE: Logical & Math Functions (IF, COUNTIF, AVERAGEIF)
8m
Project submission
8. SUBMISSION: Module 2
60m
3. EXCEL PIVOT TABLES
Video lesson
1. Pivot Table Basics
12m
Video lesson
2. Interactivity
10m
Video lesson
3. Conditional Formatting & Charts
10m
Reading
4. GUIDE: Report Connections, Date Grouping & Formatting
8m
Interactive tutorial
5. QUIZ: Pivot Tables
20m
Project submission
6. SUBMISSION: Pivot Tables
60m
4. EXCEL DASHBOARDS
Video lesson
1. Building the Dashboard
10m
Project submission
2. SUBMISSION: Dashboard
60m
Browse Topfolio
All courses
Practice
Projects
Career tracks
Home
/
Courses
/
Excel for Data Analytics (Short & Focused)
/
EXCEL CLEANING & LOGIC
/
QUIZ: Data Cleaning
Back to EXCEL CLEANING & LOGIC
QUIZ: Data Cleaning
20 minutes
Interactive tutorial
Loading lesson...
Feedback
