Career Tracks
Free Courses
Practice
Work Experience
Projects
More
For Employers
INR
Sign in
Start Free
Course Contents (0/19)
Excel for Data Analytics (Short & Focused)
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 CLEANING & LOGIC
/
QUIZ: Data Cleaning
Back to EXCEL CLEANING & LOGIC
QUIZ: Data Cleaning
6 minutes
Interactive tutorial
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.
Sign in free
Question 1 of 10
Answer saved
0 answered
Which feature helps you quickly fill a series of numbers, dates, and text patterns by dragging the fill handle?
Auto Fill
Flash Fill
Text to Column
Conditional Formatting
Previous
Next
← Back to Text Functions & Data Quality
Feedback