top of page
Excel Videos
(Browse through various Excel related learning videos)
DATEDIF Function
Use of Date Functions
VLOOKUP Concept
Range Lookup Argument in VLOOKUP
Match function
Match Function - Match Type
Text Functions
GSTR2A Reconciliation Part 1
GSTR2A Reconciliation Part 2
GSTR2A Reconciliation Part 3
Remove Password Easily
Audit With Excel - Part 1
Audit With Excel - Part 2
Audit With Excel - Part 3
Indirect Function
Pivot Table Introduction
Pivot with Slicer
Pivot Table using Data Model
Pivot Calculative Field
Sumproduct Function
SumProduct with Date
CHOOSE Function
Index and Match
Index With Reference
Database Functions - DSUM
bottom of page