Need Help? Chat with us

Excel Course in Hindi

Buy Excel Course in Hindi [Pendrive]
INR 2499
Watch & Learn Excel through videos on TV or Computer, Mobile Unprotected Pendrive
90 MP4 videos (Hindi)
87 MP4 videos (English) – Bonus
Total 900+ mins of videos tutorials
Free Courier
Free Training Files (For practice)
Free 16 GB Pen Drive
Excel Course in Hindi [Online Access]
INR 1299
Actual Price INR 2̶4̶9̶9̶ / Watch & Learn Excel through videos on TV or Computer, Mobile
90 MP4 videos (Hindi)
87 MP4 videos (English) – Bonus
Total 900+ mins of videos tutorials
Online Access
Free Training Files (For practice)
Lifetime Access

 Learn Excel Course In Hindi

Apane Excel trainer dost ko jaanie:

  • Name: Mr. Rishabh Pugalia
  • Profession: Chartered Accountant
  • Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
  • 4.0 years of work experience in the area of Audit, Investment Banking & Proprietary trading
    • Program Director & Training Instructor – Advanced Excel Course, Advanced PowerPoint, Financial Modeling, VBA Macros
    • 7.0 years of work experience in Corporate Training, eLearning Content Development
    • Under him, He has trained more than 12,000 professionals across 14+ cities
    • Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy
    • Conducted CPE seminars for Chartered Accountants – Kolkata, Mumbai, Jodhpur

Jaanie, anya students ka kya kahana hai iss Excel Training course ke bare me:




Course Curriculum

✅ AutoSum function in Excel ✅ Round function in Excel
✅ Max function in Excel ✅ MRound function in Excel
✅ Average function in Excel ✅ Formatting Tricks to write x3 in Excel
✅ CountBlank function in Excel ✅ Dates – Concepts, Issues & Related Formulas – Part 1
✅ Count and Counta function in Excel ✅ Dates – Concepts, Issues & Related Formulas – Part 2
✅ Status bar in Excel ✅ Dates – Concepts, Issues & Related Formulas – Part 3
✅ Data Formatting in Excel ✅ Sort Data in Excel | Descending order
✅ Autofill dates in Excel ✅ Sort Data in Excel | Alphabetically
✅ Autofill numbers in Excel ✅ Sort by Dates in Excel
✅ Format Painter in Excel ✅ Sort by Color in Excel
✅ Table Formatting in Excel ✅ Filter Data and then Calculate Sum in Excel
✅ How to store numbers as text in 1 minute in Excel ✅ Filter in Excel
✅ Sumproduct function in Excel ✅ Working with filtered Data in Excel
✅ Calculate Year on Year percentage Growth ✅ Number filter in Excel
✅ Add serial numbers column before sorting in Excel ✅ 2 level sorting in Excel
✅ Format Painter Continuously in Excel ✅ Subtotal function in Excel
✅ Color multiple sheet tab in Excel ✅ Filter & SUBTOTAL formula
✅ Warm-up I: Key Shortcuts ✅ Remove Duplicates values in Excel
✅ Warm-up II: Essential formulas & application tricks – Part 1 ✅ UPPER, LOWER, PROPER to change text case in Excel
✅ Warm-up II: Essential formulas & application tricks – Part 2 ✅ Trim function in Excel
✅ Warm-up II: Essential formulas & application tricks – Part 3 ✅ Value function in Excel
✅ Formatting Tricks – Part 1 ✅ Len function in Excel
✅ Formatting Tricks – Part 2 ✅ Left – Right – Mid function in Excel
✅ Formatting Tricks – Part 3 ✅ Delete Error cells by using Go To Special in Excel
✅ Formatting Tricks – Part 4 ✅ Excel Shortcut keys: Ctrl + Enter
✅ Cell Referencing ($) ✅ Fill Intermittent Blank cells in Excel
✅ Cell Referencing ($) ✅ Substitute function in Excel
✅ Cell Referencing ($) ✅ Text Formulas I – UPPER, PROPER, LOWER, TRIM, T, N, REPT
✅ Cell Referencing ($) ✅ Text Formulas II – SEARCH vs. FIND, LEFT-RIGHT-MID, LEN
✅ Cell Referencing ($) ✅ Text Formulas II – SEARCH vs. FIND, LEFT-RIGHT-MID, LEN
✅ Adding leading Zeroes in cheque number in Excel ✅ Text Formulas III – REPLACE, SUBSTITUTE
✅ Create Drop-down in Excel in 30 seconds ✅ Master logical statements: True or False in Excel
✅ Remove Drop-down in Excel ✅ Simple logical statement: True or False in Excel
✅ Freeze Panes in Excel ✅ Excel Logical function – AND, OR
✅ Activate Developer Tab in 2007-2016 in Excel ✅ Vlookup function in Excel | Part 1
✅ Dashboard Trick – Create a spin Button in Excel ✅ Vlookup function in Excel | Part 2
✅ Dashboard Trick – Create a scroll Bar in Excel ✅ Countif function in Excel | Cell Counting
✅ Hyperlinked Shortcuts in Excel ✅ Sumif function in Excel | Adding numbers
✅ Calculate Fixed Deposit in Excel | Part 1 ✅ Averageif function in Excel
✅ Calculate Fixed Deposit in Excel | Part 2 ✅ Color cells based on cell value in Excel
✅ Roundup and Rounddown function in Excel ✅ Color cells based on cell error or blanks in Excel
✅ Round function in Excel | Practical Applications ✅ Charts – Basic Concepts of chart
✅ Round Tricks from Excel Superstar in Excel ✅ Basic Charts – Bar, Column, Pie




✅ Dashboard: Grouping, Data Validation Part – 1 ✅ Match function in Excel | Part 2
✅ Dashboard: Grouping, Data Validation Part – 2 ✅ D Lookup | Vlookup and Match in Excel | Part 1
✅ Dashboard: Grouping, Data Validation Part – 3 ✅ D Lookup | Vlookup and Match in Excel | Part 2
✅ Data Validation II  (Numbers, Dates, Text length) ✅ D Lookup | Vlookup and Match in Excel | Part 3
✅ Credit Default Swaps (Out of the box Excel) ✅ D Lookup | Vlookup and Match in Excel | Part 4
✅ Horizontal Sort in Excel ✅ VLookup & HLookup – Concepts, Issues & Applications – Part 1
✅ Add a blank row in Excel ✅ VLookup & HLookup – Concepts, Issues & Applications – Part 2
✅ Sort Data by Custom list in Excel ✅ VLookup & HLookup – Concepts, Issues & Applications – Part 3
✅ Multi-level Sort & Custom Sort; Color Sorting ✅ VLookup & HLookup – Concepts, Issues & Applications – Part 4
✅ Text to Columns – Part 1 ✅ VLookup & HLookup – Concepts, Issues & Applications – Part 5
✅ Text to Columns – Part 2 ✅ Lookup – VLOOKUP with MATCH – Part 1
✅ Text to Columns – Part 3 ✅ Lookup – VLOOKUP with MATCH – Part 2
✅ Text to Columns – Part 4 ✅ Lookup – VLOOKUP with MATCH – Part 3
✅ Text to Columns – Part 5 ✅ Lookup – HLOOKUP with MATCH – Part 4
✅ Joining data strings using CONCATENATE, & ✅ SUMIFS, COUNTIFS, Remove Duplicates – Part 1
✅ Text to Columns – Applications, Tricks – Part 1 ✅ SUMIFS, COUNTIFS, Remove Duplicates – Part 2
✅ Text to Columns – Applications, Tricks – Part 2 ✅ SUMIFS, COUNTIFS, Remove Duplicates – Part 3
✅ Text to Columns – Applications, Tricks – Part 3 ✅ Pivot Table in Excel
✅ Find & Replace – Advanced ✅ Pivot Table – Applications with % Computation, Grouping – Part 1
✅ IF function and Nested IF function in Excel ✅ Pivot Table – Applications with % Computation, Grouping – Part 2
✅ Logical formulas I: IF, AND, OR, Nested IF – Part 1 ✅ Pivot Table – Applications with % Computation, Grouping – Part 3
✅ Logical formulas I: IF, AND, OR, Nested IF – Part 2 ✅ Pivot Table – Applications with % Computation, Grouping – Part 4
✅ Logical formulas I: IF, AND, OR, Nested IF – Part 3 ✅ Tables
✅ Logical formulas II: ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR ✅ Conditional Formatting I (Blanks, Errors, Values, Duplicates)
✅ Vlookup function in Excel | Part 3 ✅ Conditional Formatting III (Data Bars, Color Scales, Icon Sets)
✅ Vlookup function in Excel | Part 4 ✅ Hyperlinks in Excel
✅ Vlookup function in Excel | Part 5 ✅ Formula Auditing techniques
✅ Use Vlookup to find the Debtors Ageing analysis in Excel ✅ File Security & password Protection
✅ I bet you wouldn’t know this Vlookup trick in Excel | Score Grading ✅ File Security & password Protection
✅ I bet you wouldn’t know this Vlookup trick in Excel |Food Grading ✅ Printing
✅ Using Vlookup find Service tax in Excel ✅ Comments
✅ Excel vlookup in Multiple sheets ✅ Split Windows, Viewing multiple Windows
✅ Vlookup vs. Hlookup in Excel ✅ Hyperlinking
✅ Match function in Excel | Part 1
✅ Advanced Filter
✅ Advanced Filter
✅ Advanced Find & Replace – Part 1
✅ Advanced Find & Replace – Part 2
✅ LOOKUP vs VLOOKUP vs HLOOKUP vs MATCH
✅ Excel Ninja Shortcut – Part 1
✅ Excel Ninja Shortcut – Part 2
✅ Excel Ninja Shortcut – Part 3
✅ Excel Ninja Shortcut – Part 4
✅ Reverse 2-way Lookup – INDEX with MATCH Part 1
✅ Reverse 2-way Lookup – INDEX with MATCH Part 2
✅ Reverse 2-way Lookup – INDEX with MATCH Part 3
✅ Microsoft Add-in Fuzzy lookup in Excel
✅ Reverse 2-way Lookup – INDEX with MATCH – Part 1
✅ Reverse 2-way Lookup – INDEX with MATCH – Part 2
✅ Reverse 2-way Lookup – INDEX with MATCH – Part 3
✅ Bonus Topic – INDIRECT()
✅ Bonus Topic – OFFSET()
✅ Subtotal Function – Part 1
✅ Subtotal Function – Part 2
✅ Subtotal Function – Part 3
✅ 3-D Data Consolidation from same/different Workbooks – Part 1
✅ 3-D Data Consolidation from same/different Workbooks – Part 2
✅ Conditional Formatting II (Formula-based)
✅ What IF Analysis – Scenario Managers
✅ What IF Analysis – Goal Seek
✅ What IF Analysis – Data Tables
✅ What IF Analysis – Using Form Control Buttons
✅ Special Charts: Thermometer Charts
✅ Special Charts: Multi-axis charts
✅ Special Charts: Exploded Pie charts
✅ Special Charts: Trendline Chart
✅ Special Charts: Stacked % Column chart
✅ Macros – Overview, Developer tab, Settings
✅ Macros – Recording, Running; Using Buttons to run Macros
✅ HR Survey Data – Power Query
✅ Power Pivot Intro
✅ Business Writing Skill (SCQA)
✅ Top 10 Excel Formulas

AutoSum | Excel | Max function | Average function | Count formula | Vlookup | Formula | Excel formula |Excel function | Data formatting | Autofill | Sorting Data |Filter | Advanced filter | Autofill date | Freeze Panes | Learn Excel in Hindi |Pivot table | TRIM function | Table formatting | Excel course in Hindi | Excel in Hindi | Indirect function | Index function | IF function | NestedIF function | Sumproduct function | Sumifs function | countifs function | Subtotal function | Match function | 2D lookup | 3D Consolidate | Goal seek | formula bar | Thermometer chart | Multi-axis chart | Dashboard tricks | Excel Shortcuts | Shortcuts | Fuzzy lookup | flash fill | Protect Sheet | Protect Workbook | Indirect formula | Text-to-Column | Excel2007 | Excel 2010 | Excel 2013 | Excel 2016 | Learn Excel in Hindi | Excel Course Hindi English Mix