DAILY UPLOADS - 8:00 AM (GMT)
WANT TO BE THE SMARTEST PERSON IN THE ROOM?

Welcome to your daily dose of Excel wisdom—where each episode unlocks a powerful function or technique to boost your productivity. From essential formulas to advanced data analysis and dashboard design, I’ll help you transform raw data into smart insights. Whether you're a beginner or brushing up your skills, there's always something new to learn—one episode at a time!

How to create column charts in excel l Excel chart series l Part-1 l Complete beginner guide
4:42
How to create column charts in excel l Excel chart series l Part-1 l Complete beginner guide
Calaculate workdays between dates using Networkdays function in Excel | TUTORIAL 29
3:03
Calaculate workdays between dates using Networkdays function in Excel | TUTORIAL 29
WORKDAY FUNCTION l TUTORIAL 28 l CALCULATE PROJECT DEADLINES BASES ON BUSINESS WORKING DAYS
4:21
WORKDAY FUNCTION l TUTORIAL 28 l CALCULATE PROJECT DEADLINES BASES ON BUSINESS WORKING DAYS
How to Use the NOW Function in Excel for Timestamping Entries | Quick Excel Tip l TUTORIAL 27
2:29
How to Use the NOW Function in Excel for Timestamping Entries | Quick Excel Tip l TUTORIAL 27
How to Use TODAY Function in Excel | Real-Life Uses for Dynamic Date Tracking l Tutorial 26
3:32
How to Use TODAY Function in Excel | Real-Life Uses for Dynamic Date Tracking l Tutorial 26
RANK FUNCTION l TUTORIAL 25 l ASSIGN RANKS AUTOMATICALLY l HOW TO USE RANK FUNCTION
3:20
RANK FUNCTION l TUTORIAL 25 l ASSIGN RANKS AUTOMATICALLY l HOW TO USE RANK FUNCTION
INDEX MATCH FUNCTION l TUTORIAL 24 l Xlookup function vs Index Match?
4:50
INDEX MATCH FUNCTION l TUTORIAL 24 l Xlookup function vs Index Match?
HOW TO USE XLOOKUP FUNCTION IN EXCEL l TUTORIAL 23 l NO NEED OF VLOOKUP OR HLOOKUP ANYMORE
3:26
HOW TO USE XLOOKUP FUNCTION IN EXCEL l TUTORIAL 23 l NO NEED OF VLOOKUP OR HLOOKUP ANYMORE
HOW TO USE HLOOKUP FUNCTION IN EXCEL l TUTORIAL 22 l FIND VALUES IN THE DATASET EASILY
2:46
HOW TO USE HLOOKUP FUNCTION IN EXCEL l TUTORIAL 22 l FIND VALUES IN THE DATASET EASILY
HOW TO USE VLOOKUP FUNCTION IN EXCEL l TUTORIAL 21 l FIND DATA AUTOMATICALLY
4:43
HOW TO USE VLOOKUP FUNCTION IN EXCEL l TUTORIAL 21 l FIND DATA AUTOMATICALLY
HOW TO CREATE A DROP-DOWN LIST IN EXCEL l TUTORIAL 20
3:33
HOW TO CREATE A DROP-DOWN LIST IN EXCEL l TUTORIAL 20
IFS FUNCTION l TUTORIAL 19 l EASIER WAY OF TESTIN MULTIPLE CONDITIONS IN EXCEL
4:43
IFS FUNCTION l TUTORIAL 19 l EASIER WAY OF TESTIN MULTIPLE CONDITIONS IN EXCEL
IF FUNCTION l TUTORIAL 18 l HOW TO USE IF WITH MULTIPLE CONDITIONS l NESTED IF EXCEL
4:59
IF FUNCTION l TUTORIAL 18 l HOW TO USE IF WITH MULTIPLE CONDITIONS l NESTED IF EXCEL
IF FUNCTION I TUTORIAL 17 l HOW TO USE IF FUNCTION IN EXCEL l MOST IMPORTANT FUNCTION IN EXCEL
3:57
IF FUNCTION I TUTORIAL 17 l HOW TO USE IF FUNCTION IN EXCEL l MOST IMPORTANT FUNCTION IN EXCEL
COUNT, COUNTIF, UNIQUE, SUMIF l TUTORIAL 16 l SALES ANALYSIS MADE EASY!
4:43
COUNT, COUNTIF, UNIQUE, SUMIF l TUTORIAL 16 l SALES ANALYSIS MADE EASY!
SORTBY FUNCTION l TUTORIAL 15 l Apply multiple conditions to sort data automatically!
2:51
SORTBY FUNCTION l TUTORIAL 15 l Apply multiple conditions to sort data automatically!
FILTER & UNIQUE FUNCTION l TUTOTIAL 14 l Apply filter function and forget about filtering manually!
4:42
FILTER & UNIQUE FUNCTION l TUTOTIAL 14 l Apply filter function and forget about filtering manually!
SORT FUNCTION l TUTORIAL 13 l Don’t use filter button to sort data. Apply Sort function and forget.
3:04
SORT FUNCTION l TUTORIAL 13 l Don’t use filter button to sort data. Apply Sort function and forget.
SEQUENCE & CONCAT l TUTORIAL 12 l Don’t use fill handle!!
3:47
SEQUENCE & CONCAT l TUTORIAL 12 l Don’t use fill handle!!
EOMONTH FUNCTION l TUTORIAL 11 l Calculate month end date in seconds!
2:51
EOMONTH FUNCTION l TUTORIAL 11 l Calculate month end date in seconds!
MIN AND MAX FUNCTION l TUTORIAL 10 l Find the lowest or highest value in a range in seconds!
3:46
MIN AND MAX FUNCTION l TUTORIAL 10 l Find the lowest or highest value in a range in seconds!
EDATE FUNCTION l TUTORIAL 9 l Calculate due date for your loans or bills in seconds!
1:36
EDATE FUNCTION l TUTORIAL 9 l Calculate due date for your loans or bills in seconds!
UNIQUE + SUMIF FUNCTION l TUTORIAL 8 l Find unique values in second and save hours of manual work!
2:50
UNIQUE + SUMIF FUNCTION l TUTORIAL 8 l Find unique values in second and save hours of manual work!
AVERAGEIF FUNCTION l TUTORIAL 7 l Find average value based on specific criteria!
2:31
AVERAGEIF FUNCTION l TUTORIAL 7 l Find average value based on specific criteria!
AVERAGE FUNCTION l TUTOTIAL 6 l Don’t calculate averages manually, use Average function!
1:26
AVERAGE FUNCTION l TUTOTIAL 6 l Don’t calculate averages manually, use Average function!
SUMIF FUNCTION l TUTORIAL 5 l Calculate total SUM of values or range based on specific criteria!
3:19
SUMIF FUNCTION l TUTORIAL 5 l Calculate total SUM of values or range based on specific criteria!
SUM / AUTO SUM FUNCTION l TUTORIAL 4 l Calculate total sum of values using SUM function
3:33
SUM / AUTO SUM FUNCTION l TUTORIAL 4 l Calculate total sum of values using SUM function
CONDITIONAL FORMATTING l EXCEL TUTORIAL 3 l Don’t format data manually, use conditional formatting!
2:42
CONDITIONAL FORMATTING l EXCEL TUTORIAL 3 l Don’t format data manually, use conditional formatting!
DATA FORMATTING l EXCEL TUTORIAL 2 l EXCEL IS EASY WITH NAV
2:08
DATA FORMATTING l EXCEL TUTORIAL 2 l EXCEL IS EASY WITH NAV
EXCEL BASICS - TUTORIAL 1 l EXCEL IS EASY WITH NAV
0:50
EXCEL BASICS - TUTORIAL 1 l EXCEL IS EASY WITH NAV