Excel Course in Hindi

Buy Excel Course in Hindi [Pendrive]
INR 3000
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 799
Actual Price INR 3̶0̶0̶0̶ / 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