Excel Mastery Program Bundle

Excel (24 hrs.) + Excel VBA (6 hrs.) + PowerPoint (3 hrs.)
This Bundle includes:
  • Get 3 Courses - Excel Mastery Program + VBA Mastery Program + Become a Presentation Specialist (340+ HD Videos)
  • 24+ hours of Excel Pre-recorded Hindi videos
  • 6 hours of Excel VBA Pre-recorded Hindi & English Videos
  • 3 hours of PowerPoint Pre-recorded Hindi video
  • 1-Year Access
  • Excel & Excel VBA Mastery eBook
  • Practice files
  • Certificate of completion
  • No Refund
Enroll Now
LEARN MORE

Who this course is for:

Every professional who uses Excel & PowerPoint has a different career goal. For example:
  • Analyze data: CA, MBA, Engineers, Analysts
  • Work faster & Automate reports: Accountants
  • Become an Excel Expert: Consultant, Freelancers
  • Become a Presentation Specialist

What will you learn?

Course Narrator

Rishabh Pugalia

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

Happy Learners

See our 310+ reviews on Trustpilot

Excel Mastery Program Curriculum

Learn Excel in Hindi (24 hrs. + 240 Videos)

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

Excel VBA Mastery Program Curriculum

Learn Excel VBA in Hindi

01
Introduction
2 Lessons
Why do we learn Excel VBA Macros?
How to learn Excel VBA Macros?
02
Basic Settings
4 Lessons
How to enable Developer Tab in Excel?
Basics of Developer Tab in Excel
Important Macro Security Settings in Excel
How to save Macros in Excel for future use?
03
Record & Run Macros
6 Lessons
How to create a Macros in Excel
How to run a Macro in all open Workbooks
Using a Button to run a Macros in Excel
Running a Macro in different ways in Excel
Understanding VBA Workspace in Excel (Basics)
Watch a Macro being recorded
04
Google Readymade VBA Codes
2 Lessons
Searching Google for VBA Codes - using the 3 magic words
Searching Google for VBA Codes - in Blogs vs Forum
05
Know Your Workspace
4 Lessons
VBA Workspace - a detailed tour
How to increase the font size of the VBA Codes
3 shortcuts to write VBA Codes faster
VBA Code Testing Tricks
06
Objects, Properties, Methods
4 Lessons
Concept of Objects, Properties, Methods in Excel VBA - Part 1
Concept of Objects, Properties, Methods in Excel VBA - Part 2
Concept of Objects, Properties, Methods in Excel VBA - Part 3
Concept of Objects, Properties, Methods in Excel VBA - Part 4
07
Range & Cells Object
3 Lessons
Range and Cells Object in Excel VBA
Example - Using Cells Object with a simple Do-While Loop
What is OFFSET property in Excel VBA
08
Range Navigation
3 Lessons
Range Navigation in Excel VBA (Basics)
Exercise - Finding Last filled Row and Next Row in Excel VBA
Exercise - Finding Last Column No. (English)
09
Variable Declaration
7 Lessons
Variables - Concept, How and Why declare Variables, Initialization
Variables - Data Types
Variables - Best Practices to name Variable
Variables - How to remember to declare Variables (Option Explicit)
Variables - DIM vs SET
Pvt vs Public - Part 1 (English)
Pvt vs Public - Part 2 (English)
10
Loops
8 Lessons
Loops - For Next Loop - Basics
Loops - If Then Else with For Next Loop
Loops - For Each Next - Basics
Loops - If Then Else with For Each Next Loop
Loops - Do While Loop - Basics
Loops - Do Until Loop - Basics
Loops - With Statement
Loops - Select Case - Basics
11
Input Box & Message Box
9 Lessons
Input Box - Basics
Input Box - Inserting user input in a cell
Input Box - Different Value Types
Input Box with IF Then Else Statement
MsgBox Introduction (English)
MsgBox - Part 1 (English)
MsgBox - Part 2 (English)
MsgBox - Part 3 (English)
MsgBox - Part 4 (English)
12
User Forms
15 Lessons
Project 1: Text Box and Command Button - Basics
Project 1: Text Box and Command Button - Designing
Project 1: Text Box and Command Button - Configuring
Project 1: Text Box and Command Button - Load button
Project 2: Option Button and Command Button - Basics
Project 2: Option Button and Command Button - Configuring
Project 3: Option Button in Multiple Clusters (3 ways) - Part 1
Project 3: Option Button in Multiple Clusters (3 ways) - Part 2
Multi Page - Introduction (English)
Multi Page - Part 1 (English)
Multi Page - Part 2 (English)
Multi Page - Part 3 (English)
Check Box - Part 1 (English)
Combo Box - Method 1 (English)
Combo Box - Method 2 (English)
13
User Defined Functions (UDF)
5 Lessons
Basics of User Defind Functions (UDF)
UDF Example 1 – Score Result with IF END IF (English)
UDF Example 2 – Cell Comments (English)
UDF Samples – Series A (English)
UDF Samples – Series B (English)
14
ActiveX Controls
2 Lessons
Form Controls vs ActiveX Controls (English)
MouseMove Event w. Appln Statusbar (English)
15
Events
8 Lessons
Introduction of Events (English)
Events – Workbook_Open and Worksheet_Activate (English)
Exercise 1 – Tracking Workbook Opens (English)
Exercise 2 – Tracking Workbook Save (English)
Event – Worksheet_BeforeDoubleClick (English)
Event – Worksheet_Change (English)
Event – Worksheet_Calculate
Pivot Table – Refresh – WorkSheetActivate (English)
16
Excel VBA Projects
2 Lessons
Excel VBA for Non-Coders Project 1
F&R Text CHR

MS PowerPoint Curriculum

Learn MS PowerPoint in Hindi

01
Download Practice files
Download PowerPoint Practice files
02
Video Tutorials
30 Lessons
Basics of Shape & Text Formatting
BPowerPoint’s Color Picker tool = Eyedropper
Top 3 Text Formatting Tricks
Draw a perfect circle or a square or a straight line
Rotate objects with speed and precision
Why Group & Ungroup Objects
How to create auto-aligned duplicates
Using Smart Guides to align shapes
How to align objects lightning fast using QAT
How to use Format Painter with a shortcut
Convert boring text paragraphs to SmartArt in 3 steps
Course feedback (Help Other learners)
Ungroup a SmartArt
Convert pictures to SmartArt in 3 steps
How to crop pictures
Create a Magnifier Effect
Layering Images with Shadow effect
Create NEW shapes using Merge Shapes feature
Convert Font Symbols to editable shapes
What are Harvey balls
Break a Chart into separate reusable pieces
Removing simple background from an image
Removing complex background from an image
Advanced Visuals - Heatmap
Trick - Copy Text from Picture using MS OneNote
Use SlideMaster to create Corporate Templates
Change slide background
Replace Font & Embed Font
Online Resources – Use Icons and Images for IMPACT
Course feedback (Help Other learners) - Drop Your Reviews on Course Page
03
Storytelling Strategies
1 Lesson
7 Storytelling Strategies

1 Year Access

₹ 4999 365 Days
  • 3 Courses (340+ HD Videos)
  • 24+ hours of Excel Pre-recorded Hindi videos
  • 6 hours of Excel VBA Pre-recorded Hindi & English Videos
  • 3 hours of PowerPoint Pre-recorded Hindi video
  • 1-Year Access
  • Excel & Excel VBA Mastery eBook
  • Practice files
  • Certificate of completion
  • No Refund
ENROLL NOW
Get started now!
"I am an accountant at CA Firm. And I was faced lot of problems daily in calculations and interpretations the data. Now I do my all excel work easily. When first time i was saw the YouTube video of you (Excel superstar), I realized that you are amazing teacher sir and no one is comparable with you. And your style and the way of teaching the concepts is very unique and pure. You don't have any illogical reasons but your all reasons are fully logical behind the every excel formula. I feel proud of myself that I have teacher like you and I am student of you sir."
Jitanshu Masih
Student

Frequently Asked Questions (FAQs)

No, and I must explain why. The platform on which we host our video courses charges us an annual fee. That’s why the lifetime access option has been replaced with affordable 1-year access.

This course isn’t a copy-paste video course made by some 25-year-old ‘influencer’. We share lecture by lecture details of what’s inside this course. Check our YouTube videos, and see what people wrote in the comment section.

This course has been created by a Chartered Accountant who has worked with KPMG & J.P. Morgan. He has 16 years of experience and has taken 1000s of official in-house sessions at 70+ companies.

If you want to learn the basics of VLOOKUP or Pivot Table, you can find free videos on YouTube. However, if you want (a) practice files, (b) structured program to keep you focused, and (c) an experienced instructor, then buying the course will help you achieve your goal.

It took me 16 years of learning & work experience to be able to present my knowledge in a condensed and structured format. I am a Chartered Accountant, who has worked with KPMG (Audit) and J.P. Morgan (Investment Banking). And then conducted Corporate Training for 70+ corporate houses over the last 12 years. I teach what is really needed to stand out in the cut-throat corporate sector.

We do not have LIVE sessions.

There are 340+ videos totaling 32+ hours. If you give 2 hours every week, you can finish the course within 5 months.

There is no refund policy. There are a lot of sample videos on my YouTube channel. You can check them before buying the course.

No, but you can watch them online unlimited times during your course access period.

Once you complete the course, you will get a course completion certificate. There are no additional charges for that.

If you wish to get a certificate from Microsoft, then you can explore its various certification examinations. E.g., Microsoft Office Specialist – Exam 77-420: Microsoft Excel 2013. Please note that they charge separate exam fees.

Link – https://docs.microsoft.com/en-us/learn/certifications/mos-excel-2013/