arrow_back
Back
lock
Course Tracker
lock
Excel Course Tracker
lock
Section 01 - Excel Shortcuts
lock
Best Excel Shortcuts - Part 1 of 4
lock
Best Excel Shortcuts - Part 2 of 4
lock
Best Excel Shortcuts - Part 3 of 4
lock
Best Excel Shortcuts - Part 4 of 4
lock
How to create custom shortcuts using Quick Access Toolbar (QAT)?
lock
Section 02 - Essentials for Beginners
lock
Three easy ways to do SUM or total of numbers
lock
Basics of MAX & MIN formula
lock
Use of MAX formula in Finance (Tax & Billing)
lock
Use of SMALL & LARGE formula in Finance
lock
Using MEDIAN formula to remove outliers
lock
Using Paste Special (Value, Transpose) for daily work
lock
Paste Special (Transpose) vs TRANSPOSE Formula
lock
Using COUNTBLANK to count blank cells
lock
Difference between COUNT vs. COUNTA
lock
Using Status Bar for Quick Calculations
lock
Using SUMPRODUCT Function in Finance & Costing
lock
Easiest way to calculate YoY Growth Percentage
lock
What is POWER formula
lock
How to calculate the maturity amount of Fixed Deposit
lock
Basics of ROUND formula
lock
Basics of ROUNDUP & ROUNDDOWN formula
lock
Uses of ROUNDUP & ROUNDDOWN formula in Finance
lock
Basics of MROUND formula
lock
Advanced Trick of Round Formula in Finance
lock
Using Autofill feature to create automatic list of Dates
lock
Using Autofill feature to create automatic list of Numbers
lock
Hanging Formula (Excel Formula doesn't work)
lock
Course Feedback
lock
Section 03 - Essential Formatting Tricks
lock
7 ways to use Format Cells
lock
How to hide a text without coloring the cell white?
lock
What is - Numbers stored as Text?
lock
How to write full Cheque numbers with missing zeroes?
lock
What is Superscript inside Format Cells?
lock
Basics of formatting tabular datasets
lock
How to format lengthy headings using Wrap Text & Alignment?
lock
How is Format Painter used to copy & paste formats?
lock
How to use Format Painter multiple times?
lock
How to remove all formatting in one click?
lock
Working with Tables
lock
How to color multiple sheet tabs?
lock
How to use Freeze Panes for Rows & Columns at the same time?
lock
Grouping
lock
Gridlines
lock
How to create a simple drop-down list with Data Validation?
lock
How to remove a drop-down list?
lock
How to activate the Developer Tab in 2007-2019 in Excel?
lock
How to create an interactive Spin Button for an Excel Dashboard?
lock
How to create an interactive Scroll Bar for an Excel Dashboard?
lock
7 Tricks of Comments - Basic to Expert
lock
4 Tricks of Hyperlinking - Basic to Expert
lock
How to hide a sheet so that no one can Unhide easily?
lock
Course Feedback
lock
Section 04 - Sort & Filter
lock
How to Sort numbers from largest to smallest?
lock
How to Sort text alphabetically (A-Z)?
lock
How to Sort dates oldest to newest?
lock
How to Sort rows by cell color?
lock
Best Practice before you sort any dataset
lock
How to do 2-level Sorting?
lock
The hidden trick of Horizontal Sorting
lock
The hidden trick of Sorting using a custom list
lock
The hidden trick to add a blank row between every row using Sort
lock
Basics of Filter & Calculating SUM on the filter list
lock
The most common mistake Filter users make while choosing datasets
lock
Importance of SUBTOTAL formula in a Filtered dataset
lock
SUBTOTAL formula's confusing parameters - Mystery Solved
lock
Number Filter option in Filter
lock
How to navigate a Filtered dataset using Shortcuts?
lock
How is Advanced Filter different than General Filter?
lock
The hidden trick to apply separate Filters on two datasets of the same worksheet?
lock
The hidden trick to paste values on a Filtered dataset
lock
How to use Slicer on a Filtered dataset?
lock
Course Feedback
lock
Section 05 - Cell Reference ($)
lock
Use of Cell Referencing ($) in formulas - Explained
lock
Section 06 - Dates
lock
Why does a Date in Excel looks like a random number?
lock
How to calculate the duration using two dates with timestamp?
lock
Date formulas - DAY, MONTH, YEAR & DATE - Part 1
lock
Date formulas - DAY, MONTH, YEAR & DATE - Part 2
lock
Date formulas - TEXT & WEEKDAY - Part 1
lock
Date formulas - TEXT & WEEKDAY - Part 2
lock
Why is EDATE referred as Expiry Date?
lock
Why is EOMONTH referred as End of Month?
lock
Date formulas - TODAY & NOW with Shortcuts
lock
The hidden trick to rectify dates format using Text to Columns
lock
How to use WORKDAY.INTL formula to calculate project deadline?
lock
How to use NETWORKDAYS.INTL to calculate working days between two dates?
lock
The hidden formula of DATEDIF
lock
How to find the 1st, 3rd and 5th Saturday of any month
lock
Course Feedback
lock
Section 07 - Logical Functions
lock
Basics of Logical Formula - Part 1
lock
Basics of Logical Formula - Part 2
lock
Basics of Logical Formula - Part 3
lock
Quick Recap of Logical Formulas with advanced exercises
lock
Using multiple Logical formulas - IF, AND, OR in an advanced exercise
lock
Logical Check Formulas for Text, Numbers, & Errors including IFERROR
lock
Course Feedback
lock
Section 08 - Data Cleaning
lock
How to remove duplicate values?
lock
Using UPPER, PROPER, & LOWER formulas to change the case of the text
lock
Using TRIM formula to remove excess spaces in a sentence
lock
Using VALUE formula to convert numbers stored as text to a number format
lock
Using LEN formula to calculate the number of characters in a cell
lock
Basics of RIGHT, LEFT & MID formulas
lock
SEARCH vs FIND
lock
SEARCH & MID
lock
How to find and delete all the error values at once?
lock
Shortcut to make best use of Go To (Special) technique
lock
How to fill intermittent blank cells using Go To (Special) technique?
lock
Other uses of Ctrl G - Formula, Constants, Visible cells
lock
Using Text to Column feature to split data values - Part 1 (Delimited)
lock
Using Text to Column feature to split data values - Part 2 (Fixed Width)
lock
When is Text to Column feature used to change the Data Format (General, Text)?
lock
How to convert a series of email IDs to a vertical list for Attendance?
lock
How can Text to Columns help in writing correct SUM & VLOOKUP formulas?
lock
Using CONCATENATE and Ampersand (&) to join values
lock
Find & Replace - Part 1 (with Wildcard Character)
lock
Find & Replace - Part 2 (MS Word vs MS Excel)
lock
Quick Recap of Advanced Find & Replace
lock
SUBSTITUTE - the formula version of Find & Replace
lock
FlashFill - Basics to Advanced
lock
Project - FlashFill, T2C, SUBSTITUTE - Bank Data
lock
Project - Electricity Consumption - Method #1
lock
Project - Electricity Consumption - Method #2
lock
Course Feedback
lock
Section 09 - Pivot Table
lock
Pivot Table (A-Z) Part 1
lock
Pivot Table (A-Z) Part 2
lock
Expert-level Pivot Table Trick using Power Query - Split to Rows
lock
Expert-level Pivot Table Trick using Power Query - Unpivot Column
lock
0905 Pivot Table Frequency Distribution
lock
0906 3 Hidden Pivot Table Option & Settings
lock
0907 Worst Features of Pivot Table
lock
Extra Files
lock
Section 10 - Lookup Formulas (A-Z)
lock
Basics of VLOOKUP for first time users - Why do we need it?
lock
Basics of VLOOKUP for first time users - fix Table Array using $
lock
Basics of VLOOKUP for first time users - TRUE vs FALSE - Part 1
lock
Basics of VLOOKUP for first time users - TRUE vs FALSE - Part 2
lock
Common mistakes of VLOOKUP users - Why do we get N/A?
lock
How to do inter-worksheet VLOOKUP?
lock
Vlookup vs. Hlookup - Simplified
lock
Using VLOOKUp with TRUE for doing Debtors Ageing Analysis
lock
Using VLOOKUp with TRUE for doing Score Grading
lock
Using VLOOKUp with TRUE for doing Food Quality Grading
lock
Using VLOOKUp with TRUE for calculating correct tax rate as per applicable date
lock
Basics of MATCH formula - Part 1
lock
Basics of MATCH formula - Part 2
lock
How to do 2D Lookup using VLOOKUP & MATCH - Example 1
lock
How to do 2D Lookup using VLOOKUP & MATCH - Example 2
lock
How to do inter-worksheet 2D Lookup using VLOOKUP & MATCH? - Example 1
lock
How to do inter-worksheet 2D Lookup using VLOOKUP & MATCH? - Example 2
lock
LOOKUP vs. VLOOKUP vs. HLOOKUP vs. MATCH
lock
How to do Reverse Lookup using INDEX & MATCH formula - Part 1
lock
How to do Reverse Lookup using INDEX & MATCH formula - Part 2
lock
Exercise | Using INDEX & MATCH formula to do Reverse Lookup
lock
Fuzzy Lookup can do what VLOOKUP can't - Lookup for data with different spelling
lock
7 reasons of NA in VLOOKUP
lock
Basics of INDIRECT formula
lock
Create a Dashboard from 25+ worksheets using INDIRECT formula
lock
Use VLOOKUP & INDIRECT formula to pull data from multiple sheets
lock
How to do 3D Lookup using VLOOKUP, MATCH, INDIRECT & name ranges?
lock
Basics - Using OFFSET formula to create Dynamic Ranges
lock
Using OFFSET to create dynamic calculations - Part 1 (Intermediate)
lock
Using OFFSET to create dynamic calculations - Part 2 (Advanced)
lock
Section 11 - Conditional Aggregation
lock
Basics of COUNTIF formula
lock
Basics of SUMIF formula
lock
Basics of AVERAGEIF formula
lock
COUNTIFS & SUMIFS - Part 1 (Intermediate)
lock
COUNTIFS & SUMIFS - Part 2 (Advanced)
lock
Exercise - Using SUMIFS & COUNTIFS with 3 criteria
lock
Exercise - Using SUMIFS to find sum of values between two dates
lock
Using COUNTIFS to find duplicates and reconcile two lists
lock
The hidden trick of COUNTIFS to calculate running count based on the ID value
lock
The hidden trick of COUNTIFS to do VLOOKUP for duplicate values
lock
The hidden trick of SUMIFS to calculate running sum total based on the ID value
lock
Section 12 - Conditional Formatting
lock
Conditional Formatting - Color cells based on errors, blanks, duplicates, user-defined value
lock
Conditional Formatting - Color cells using Data Bars, Icon Sets, Color Scales
lock
Create a Dashboard for comparing Actual vs Budget using Conditional Formatting
lock
Using Conditional Formatting for changing the cell color based on list value chosen
lock
Formula-based Conditional Formatting - color the entire row based on user-selected value
lock
Formula-based Conditional Formatting - color the cell that matches two user criterias
lock
Formula-based Conditional Formatting - Highlight cells that have prohibited values
lock
Section 13 - What If Analysis
lock
Basics of Data Table feature of What-If Analysis
lock
Using Data Table feature of What-If Analysis with INDIRECT formula
lock
Advanced use case of Data Table feature for Loan EMI payments
lock
Limitations of using Scroll Bar & Spin Button
lock
Basics - Using Goal Seek to back-calculate
lock
Basics - Scenario Manager for Best, Basics - Scenario Manager for Best, Worst & Base Case
lock
Section 14 - Report Consolidation
lock
The hidden trick of Consolidation using SUM for multiple sheets
lock
How to use CONSOLIDATE feature of Excel? - Part 1
lock
How to use CONSOLIDATE feature of Excel? - Part 2
lock
How to use SUBTOTAL feature of Excel using one criteria?
lock
How to use SUBTOTAL feature of Excel using two criteria?
lock
The hidden trick of SUBTOTAL feature & Go To (Special) to merge cells into blocks
lock
Section 15 - Printing
lock
Top 10 Printing Tricks & Settings
lock
Section 16 - Workbook & Worksheet Security
lock
Level of Password Security - File vs. Sheet vs. Workbook Structure
lock
How to hide a sheet so that no one can Unhide easily?
lock
How to remove “Protect sheet” Password with Notepad?
lock
How to remove remove “Protect workbook” Password with Notepad?
lock
Section 17 - Special Tricks
lock
The hidden trick to Compare two Excel files
lock
The hidden trick to join cell values without using CONCATENATE
lock
The hidden trick to activate Data Entry Form
lock
How to Copy Text from Image | OneNote Tutorial
lock
PDF to Word Converter - Without Software
lock
Section 18 - Advanced Excel Projects for Finance
lock
Convert "Dr" & "Cr" suffix of Tally dayasets into positive & negative values
lock
Clean-up complex Bank Statement sheet of Borrowers
lock
Analyse payments made to Suppliers using FlashFill, VLOOKUP & Pivot Table
lock
Extract multiple voucher nos. from a cell to create a list
lock
Create a Frequency Distribution of sales ticket size using Pivot Table?
lock
Calculate Stock Revaluation write-off amount using VLOOKUP with TRUE and MATCH
lock
Form 26AS - TDS | What is Form 26AS?
lock
PAN Assessee Status - using MID & VLOOKUP
lock
Section 19 - Advanced Excel Projects for Sales
lock
Calculate Sales Commission using advanced SUMIFS and VLOOKUP with TRUE
lock
Allocate sales value of a project to the individual team members
lock
Sales Visualization - without Charts
lock
Section 20 - Office 365 Updates
lock
UNIQUE
lock
Concat & TextJoin
lock
Project - TextJoin & IF
lock
XLOOKUP - Basic to Advanced
lock
IFS & SWITCH
lock
MAXIFS & MINIFS
lock
Filter
lock
SORT
lock
SORTBY
lock
Sequence
lock
LET
lock
Section 21 - Basics of Macro
lock
Why do we learn Excel VBA Macros?
lock
How to learn Excel VBA Macros?
lock
How to enable Developer Tab in Excel?
lock
Basics of Developer Tab in Excel
lock
Important Macro Security Settings in Excel
lock
How to save Macros in Excel for future use?
lock
How to create a Macros in Excel?
lock
How to run a Macro in all open Workbooks?
lock
Using a Button to run a Macros in Excel
lock
Running a Macro in different ways in Excel
lock
Understanding VBA Workspace in Excel (Basics)
lock
Watch a Macro being recorded
lock
Searching Google for VBA Codes - using the 3 magic words
lock
Searching Google for VBA Codes - in Blogs vs Forum
lock
Section 22 - Excel Charts for Business Dashboards
lock
15 Excel CHARTS recommended by Rishabh
lock
Interactive Excel Dashboard with Option Buttons
lock
Interactive Line chart for EXCEL DASHBOARD
lock
Create Dynamics Dashboard in Excel using Sales Data
lock
Section 23 - Advanced Tricks using Power Query & Power BI
lock
Unpivot Columns (Multiple Columns to Rows)
lock
Multiple LINES into Separate Cells (Split to Rows - Automation)
lock
Pivot Table with Multiple Text Values (Don't Aggregate)
lock
Fuzzy Matching for Multiple Excel Table (Reconciliation)
lock
Merge Queries in Power Query (WHY - Handle Speed & Volume)
lock
Excel Power Query - Custom Column Formula
lock
Power Query for Beginners - Project #1
lock
Section 24 - Combination Formula for Advanced users
lock
VLOOKUP with TRUE and IF Function [Calculate Commissions $]
lock
VLOOKUP with TRUE and $, SUMIFS (Multiple Criteria)
lock
Excel Mastery eBooks
lock
Excel Mastery eBook 1
lock
Excel Mastery eBook 2
lock
Excel Mastery eBook 3
lock
Excel Mastery eBook 4
lock
Excel Mastery eBook 5
Preview - Excel Mastery Program
Discuss (
0
)
navigate_before
Previous
Next
navigate_next