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

BUY NOW

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

 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