Intermediate to Advanced Excel

Advanced Excel Material
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
 5 Topics
Excel Functions
Text Functions
Date & Time Functions
If Function, AND & OR Operators
Informational Functions
Go To Special
 1 Topic
Data Fixing
Relative, Mixed & Absolute Referencing
 1 Topic
Relative, Mixed & Absolute
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
 1 Topic
Two Examples
SUMIF, IFS, COUNTIF, IFS
 1 Topic
SUMIF, IFS, COUNTIF, IFS
Table
 1 Topic
Format as Table & Add on Capabilities
Array
 1 Topic
Array with Sum & Max Functions
Conditional Formatting
 4 Topics
Inbulit Conditional Formatting
Custom Conditional Formatting
Dynamic Search & Highlight
Partial Match
Auto-fill, Flash Fill & Custom Lists
 3 Topics
Auto Fill
Flash Fill
Custom Lists
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
 6 Topics
Offset – Basic
Offset with Sum – Horizontal
Offset with Sum – Vertical
Offset with Match
Offset with Average
Offset with Countif
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
 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
 2 Topics
Introduction: How Is Power Pivot Different From Pivot Table
Avoid Vlookup Using Data Model
Designing Dashboard
 1 Topic
Create Your Dashboard
Power Query
 3 Topics
Why Power BI & How Does It Work?
Data From Web
Combine Files From Folder In 1 click
Protection
 3 Topics
Protect Sheet
Protect Workbook
Make Your Workbook Read Only
1 of 2
0% Complete
0/129 Steps
Previous Topic

Vlookup with Duplicate Values

Intermediate to Advanced Excel Demo Advanced Excel Vlookup with Duplicate Values
In Progress
Lesson Progress
0% Complete

Previous Topic
Back to Lesson
Next Topic
error: Content is protected !!