Advanced Excel

Introduction to Excel
Security
Short Keys
Practice Data Sheets
Data Formats
Conditional Formatting
Format as Table
Data Sorting
Data Filtering
Remove Duplicates
Data Validation
Text-To-Columns
Data Consolidation
What-if-Analysis
Grouping
Absolute & Relative Referencing
Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
Task1 - Mathematical Formulas
Logical Functions - IF, IFERROR, AND, OR
Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
Vlookup Formula
Task2 - Vlookup Problems
Vlookup with Match Formula - Dynamic Duo
Vlookup using (*) example
Vlookup with Running Countif
Task3 - Vlookup, Running Countif Problem
Lookup Functions - Hlookup, Index Match
Lookup Functions - Indirect, Offset
Vlookup-Indirect Example
Sumif, Indirect, Offset, Match Example
Array Functions
Task4 - Array Problem
Advanced Conditional Formatting using Formula
Data Validation using Indirect Function
Charts, Waterfall Graph
Pivot Table, Dashboards

Powered by GitBook

Vlookup using (*) example

Refer the attached Sheet.

PreviousVlookup with Match Formula - Dynamic Duo NextVlookup with Running Countif

Last updated 5 years ago

On this page

Was this helpful?