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

Sumif, Indirect, Offset, Match Example

Refer the Attached Sheet.

PreviousVlookup-Indirect Example NextArray Functions

Last updated 5 years ago

On this page

Was this helpful?

Sumif, Indirect, Offset, Match Example.xlsx