Advanced Excel & Excel Dashboard Course
INR 2299
Actual Price INR 6̶0̶0̶0̶ / Watch & Learn Advanced Excel & Excel Dashboard Course through videos on TV or Computer
Excel Course 170+ MP4 videos (Hindi & English)
Dashboard Course 50+ MP4 videos (English)
Total 19+ hrs. of videos tutorials
Free Courier
Free Training Files (For practice)
Free 16 GB Pen Drive
Learn Excel & Dashboard Course In Hindi & English
There are Excel Formulas that you must know. Most of the jobs these days require advanced Excel Skills. Pivot Table, Sheet Referencing, HLOOKUP, Vlookup and INDEX MATCH are the Powerful Formulas that you need to learn to be an expert at work. We have the Advanced Excel Course in Hindi especially designed to make you an expert at Excel.
The People need to know and understand about the Working knowledge of interactive Dashboards. The importance of creating impressive and easy to understand visual reports by creating Dashboards. This will help you to analyze reports better. Check our course and feel the magic of Dynamic Excel Dashboards Course.
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, 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:
Advanced Excel ToC
✅ Microsoft Add-in Fuzzy lookup in Excel |
✅ Flash fill in Excel | Data Cleaning |
✅ Hide a sheet so that no one can easily Unhide in Excel |
✅ Confidential – Remove “Protect sheet” Password with Notepad |
✅ Confidential – Remove “Protect workbook” Password with Notepad |
✅ Making a text magically invisible in Excel |
✅ OFFSET function in Excel |
✅ Indirect function in Excel |
✅ Text to Columns in Excel |
Excel Dashboard Course ToC
0101 Introduction to Dashboard Course |
0102 Introduction to 1st Dashboard |
0201 Understanding the data |
0202 Text Function |
0203 Dynamic data Create Table |
0204 Naming the dynamic data and the using it in function |
0205 Preparing 1st Pivot and updating data |
0206 Classic view and Filling blank with zero in Pivot |
0207 Create Chart for comparison from the Pivot |
0208 Create Trend line from the Pivot |
0209 Creating Pie Chart from Slab Report from Pivot |
0210 Preparing Framework for DashBoard |
0211 Inserting Slicer using Chart |
0212 Customize Slicer Setting |
0301 Brief on 2nd Dashboards |
0302 Importing Data from the Internet |
0303 Converting Line Item into a Currency Table |
0304 Calculation of Currency using INDEX and MATCH |
0305 Creating Slabs using Vlookup True Parameter |
0306 Creating Qtrs based on Financial or Calendar Selection |
0307 Preparing the base by removing duplicate for Dashboard |
0308 AverageIF for calculating Country Wise Salary |
0309 Substituting ERROR with zero using IFERROR |
0310 Introduction to Function INDIRECT Part 1 and 2 |
0311 Using Function INDIRECT to Retrieve AverageIF from relevant sheet |
0312 Using Function CountIf with INDIRECT to calculate No OF Emp |
0313 Calculating Contribution Country wise No Of Emp |
0314 Using NameRange to simplify calculation |
0315 Using NameRange with formula in 2nd Dashboard |
0316 Introduction to Offset Function |
0317 Offset Function in Excel |
0318 Using Offset Function in Dashboard |
0319 Use of MINIF in Dashboard |
0320 Use of MAXIF in Dashboard |
0321 Using Average to get Designation Wise Experience result |
0322 Using MAXIF with multiple conditions |
0323 Using MINIF with multiple conditions |
0324 Dynamic Dropdown List |
0325 longitude and latitude with plotting data on dashboard |
0326 Using REPT Function based on the percentage calculation |
0327 Activation of Developer Tab and creating Scroll Bar |
0328 Inserting Trend chart based on data |
0329 Advance INDEX and MATCH with multiple references |
0330 Inserting Spark Line |
0331 Insert World Map into the chart |
0332 Plotting Data on Map Chart |
0333 Controlling Map Preview from dropdown |
0334 Summarising 2nd Dashboard |
0401 Brief on 3rd Dashboards |
0402 Implementation of OFFSET for dynamic data |
0403 Creating Trend Chart from 2 Pivot Table |
0404 Modifying the Chart Settings for better view |
0405 Using Macro recording for Trend Chart 01 |
0406 Using macro to update pivot based on the Job Type |
0407 Triggering macro with any change in sheets |
0408 Creating Name Range using shortcut |
0409 Use of MAXIF and MINIF with single and multiple parameters |
0410 Create chart to represent multiple parameters effectively 01 |
0411 Create chart to represent multiple parameters effectively 02 |
0412 Preparing data for Spiderweb chart and change the graph setting |
0413 Using macro to Hide and Unhide working sheets |
0414 Inserting Trendline and formatting for better view |
0501 Conclusion of all 3 dashboard |