Explore
Career Tracks
Micro Free Courses
Task Courses
Practice
Interview Practice
Work Experience
Projects
Career Track
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: Lookup functions
Back to EXCEL CLEANING & LOGIC
QUIZ: Lookup functions
15 minutes
Interactive tutorial
Loading lesson...
