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: Lookup functions
Back to EXCEL CLEANING & LOGIC
QUIZ: Lookup functions
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
What is the first argument required in both VLOOKUP and XLOOKUP functions to specify what you are searching for?
Table range
Lookup value
Column index number
Range lookup
Previous
Next
← Back to Lookup Functions
Feedback