Skip to content
Intermediate to Advanced Excel
Advanced Excel Material
Demo Advanced Excel
Sample Lesson
Collapse
Demo Advanced Excel
11 Topics
Informational Functions
Data Fixing
Mobile Number Validation
Employee Feedback Validation
Vlookup Basic
Vlookup with Mutliple Criteria
Vlookup with Duplicate Values
Index & Match Functions with Drop Down
Profit & Sales Correlation
Create Your Dashboard
Data From Web
Functions
Expand
Functions
5 Topics
Excel Functions
Text Functions
Date & Time Functions
If Function, AND & OR Operators
Informational Functions
Go To Special
Expand
Go To Special
1 Topic
Data Fixing
Relative, Mixed & Absolute Referencing
Expand
Relative, Mixed & Absolute Referencing
1 Topic
Relative, Mixed & Absolute
Data Validation
Expand
Data Validation
11 Topics
List
Typed List
Mobile Number Validation
Employee Feedback Validation
Only Text Values
Only Upper Case Values
Prevent Future Dates
List with Named Range
Restrict Text Length
Dynamic List
Dependent Drop Down List
Goal Seek
Expand
Goal Seek
1 Topic
Two Examples
SUMIF, IFS, COUNTIF, IFS
Expand
SUMIF, IFS, COUNTIF, IFS
1 Topic
SUMIF, IFS, COUNTIF, IFS
Table
Expand
Table
1 Topic
Format as Table & Add on Capabilities
Array
Expand
Array
1 Topic
Array with Sum & Max Functions
Conditional Formatting
Expand
Conditional Formatting
4 Topics
Inbulit Conditional Formatting
Custom Conditional Formatting
Dynamic Search & Highlight
Partial Match
Auto-fill, Flash Fill & Custom Lists
Expand
Auto-fill, Flash Fill & Custom Lists
3 Topics
Auto Fill
Flash Fill
Custom Lists
Vlookup/ Hlookup/ Xlookup
Expand
Vlookup/ Hlookup/ Xlookup
20 Topics
Vlookup Basic
Vlookup with Array
Vlookup with Mutliple Criteria
Vlookup with Range
Vlookup with Named Range & Benefits
Vlookup with Match Function
Vlookup with Column Reference
Vlookup with Table
Vlookup with Dropdown
Two-Way Lookup
Partial Vlookup
Vlookup to leftside
Case Sensitive Lookup
Vlookup with Trim Function
Vlookup if IFERROR
Vlookup with Multiple Column Search
Vlookup with Two Tables
Vlookup with Duplicate Values
Bonus: Hlookup & Xlookup
Quiz – Test Your Knowledge – 20 MCQs
Offset Function
Expand
Offset Function
6 Topics
Offset – Basic
Offset with Sum – Horizontal
Offset with Sum – Vertical
Offset with Match
Offset with Average
Offset with Countif
Index & Match Function
Expand
Index & Match Function
5 Topics
Index Function Basic
Index Function with Area Number
Match Function Basic
Index & Match Functions as replacement to Vlookup Function
Index & Match Functions with Drop Down
Pivot Table & Chart
Expand
Pivot Table & Chart
13 Topics
Interface
Data Introduction: Super Store Data
Create Your First Pivot Table
How To Make Pivot Table Dynamic
Slicer & Timeline
Group & Ungroup Dates
Conditional Formatting In Pivot
Create Your First Chart
How To Make Pivot Chart Dynamic
Chart Gap
Top 10 Customers
Compare One sub-category Against Others
Profit & Sales Correlation
Power Pivot
Expand
Power Pivot
2 Topics
Introduction: How Is Power Pivot Different From Pivot Table
Avoid Vlookup Using Data Model
Designing Dashboard
Expand
Designing Dashboard
1 Topic
Create Your Dashboard
Power Query
Expand
Power Query
3 Topics
Why Power BI & How Does It Work?
Data From Web
Combine Files From Folder In 1 click
Protection
Expand
Protection
3 Topics
Protect Sheet
Protect Workbook
Make Your Workbook Read Only
1 of 2
Previous Topic
Next Topic
Index & Match Functions with Drop Down
Intermediate to Advanced Excel
Demo Advanced Excel
Index & Match Functions with Drop Down
Previous Topic
Back to Lesson
Next Topic
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
