Advanced Excel & Excel Dashboard Course

[vc_row][vc_column][vc_column_text][rpt name=”advanced-excel-excel-dashboard-course-online-access”][/vc_column_text][vc_column_text]


[/vc_column_text][vc_empty_space height=”5px”][/vc_column][/vc_row][vc_row full_width=”stretch_row” el_class=”overlay_2 fixed_bg” css=”.vc_custom_1453381142995{margin-bottom: 42px !important;padding-top: 66px !important;padding-bottom: 66px !important;background-image: url( !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column][vc_custom_heading icon=”fa fa-amazon” text=”Advanced Excel & Dashboard Course with Pendrive
Cash on Delivery available on Amazon
Click Here” font_container=”tag:div|font_size:28px|text_align:center|color:%23ffffff|line_height:34px” google_fonts=”font_family:Poppins%3A300%2Cregular%2C500%2C600%2C700|font_style:700%20bold%3A700%3Anormal” link=”|title:Cash%20On%20Delivery%20Available|target:%20_blank|”][/vc_column][/vc_row][vc_row css=”.vc_custom_1450960276268{margin-bottom: 73px !important;}”][vc_column][vc_column_text]

 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:

[/vc_column_text][vc_column_text]Learn Excel in Hindi Youtube ReviewLearn Excel in Hindi Youtube ReviewLearn Excel in Hindi Youtube Review[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_separator border_width=”2″][vc_column_text]

Course Curriculum

[/vc_column_text][vc_btn title=”Download the PDF Course Brochure here” style=”outline-custom” outline_custom_color=”#2b4b80″ outline_custom_hover_background=”#2b4b80″ outline_custom_hover_text=”#ffffff” size=”lg” align=”center” i_align=”right” i_icon_fontawesome=”fa fa-file-pdf-o” add_icon=”true” link=”||target:%20_blank|”][vc_separator border_width=”2″][vc_column_text]

Advanced Excel ToC

[/vc_column_text][vc_tta_tabs color=”mulled-wine” active_section=”1″][vc_tta_section title=”Beginner Mode” tab_id=”1504862635043-4c48f33f-f98c”][vc_column_text]

AutoSum function in Excel Number filter in Excel
Max function in Excel Remove Duplicates values in Excel
Average function in Excel Create Drop-down in Excel in 30 seconds
CountBlank function in Excel Remove Drop-down in Excel
Count and Counta function in Excel Freeze Panes in Excel
Master logical statements: True or False in Excel Format Painter in Excel
Simple logical statement: True or False in Excel Table Formatting in Excel
Status bar in Excel Hyperlinks in Excel
Data Formatting in Excel UPPER, LOWER, PROPER to change text case in Excel
Autofill dates in Excel Trim function in Excel
Autofill numbers in Excel Round function in Excel
Sort Data in Excel | Descending order MRound function in Excel
Sort Data in Excel | Alphabetically How to store numbers as text in 1 minute in Excel
Sort by Dates in Excel Value function in Excel
Sort by Color in Excel Len function in Excel
Filter Data and then Calculate Sum in Excel Left – Right – Mid function in Excel
Filter in Excel ✅ Excel VBA (Macro Basic)
Working with filtered Data in Excel ✅ Basics of Charts in Excel

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Intermediate Mode” tab_id=”1504862635127-eada3a38-962b”][vc_column_text]

Pivot Table in Excel Calculate Year on Year percentage Growth
Vlookup function in Excel | Part 1 Add serial numbers column before sorting in Excel
Vlookup function in Excel | Part 2 2 level sorting in Excel
Vlookup function in Excel | Part 3 Subtotal function in Excel
Vlookup function in Excel | Part 4 Format Painter Continuously in Excel
Vlookup function in Excel | Part 5 Color multiple sheet tab in Excel
Use Vlookup to find the Debtors Ageing analysis in Excel Color cells based on cell value in Excel
I bet you wouldn’t know this Vlookup trick in Excel | Score Grading Color cells based on cell error or blanks in Excel
I bet you wouldn’t know this Vlookup trick in Excel |Food Grading Adding leading Zeroes in cheque number in Excel
Using Vlookup find Service tax in Excel Calculate Fixed Deposit in Excel | Part 1
Excel vlookup in Multiple sheets Calculate Fixed Deposit in Excel | Part 2
Vlookup vs. Hlookup in Excel Formatting Tricks to write x3 in Excel
Excel Logical function – AND, OR ✅ Pie Chart in Excel
IF function and Nested IF function in Excel ✅ Chart Trick – Best way to present Charts in Excel
Countif function in Excel | Cell Counting ✅ View bar in Excel
Sumif function in Excel | Adding numbers ✅ Comments in Excel
Avaergeif function in Excel ✅ Print Excel Sheets
Sumproduct function in Excel ✅ Dashboard

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Advanced Mode” tab_id=”1504863754220-a41541d9-e8f1″][vc_column_text]

✅ Delete Error cells by using Go To Special in Excel ✅ Dashboard Trick – Create a scroll Bar in Excel
✅ Excel Shortcut: Ctrl + Enter ✅ Hyperlinked Shortcuts in Excel
✅ Fill Intermittent Blank cells in Excel ✅ Horizontal Sort in Excel
✅ Match function in Excel | Part 1 ✅ Add a blank row in Excel
✅ Match function in Excel | Part 2 ✅ Sort Data by Custom list in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 1 ✅ Thermometer Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 2 ✅ Multi-axis Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 3 ✅ Formula Security
✅ 2D Lookup | Vlookup and Match in Excel | Part 4 ✅ Formula Audit
✅ Roundup and Rounddown function in Excel ✅ 3D Data Consolidation in Excel Part 1 & 2
✅ Round function in Excel | Practical Applications ✅ Goalseek in Excel
✅ Round Tricks from Excel Superstar in Excel ✅ Substitute and Replace function in Excel
✅ Substitute function in Excel ✅ Joining data strings using CONCATENATE, &
✅ Activate Developer Tab in 2007-2016 in Excel Reverse 2-way Lookup – INDEX with MATCH Part 1
✅ Dashboard Trick – Create a spin Button in Excel Reverse 2-way Lookup – INDEX with MATCH Part 2
✅ Create Scenario in Excel Reverse 2-way Lookup – INDEX with MATCH Part 3

[/vc_column_text][/vc_tta_section][vc_tta_section title=”GOD Mode” tab_id=”1504863799073-94e7792c-4e21″][vc_column_text]

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

[/vc_column_text][/vc_column][/vc_row][vc_row][/vc_row][vc_column width=”1/3″][/vc_column][vc_tta_accordion][vc_tta_section title=”Section 1: Introduction” tab_id=”1517999627152-be73555d-00c3″][vc_column_text]

0101 Introduction to Dashboard Course
0102 Introduction to 1st Dashboard

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 2: 1st Dashboard using Pivot” tab_id=”1517999627256-30108534-8243″][vc_column_text]

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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 3: 2nd Dashboard using Functions” tab_id=”1517999735743-1a0cd789-92ad”][vc_column_text]

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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 4: 3rd Dashboard using Functions & Macros” tab_id=”1517999804921-5bbac916-8731″][vc_column_text]

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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 5: Conclusion” tab_id=”1517999876571-38ee81cb-c09c”][vc_column_text]

0501 Conclusion of all 3 dashboard


[/vc_column_text][vc_row][vc_column][vc_single_image image=”3664″ img_size=”medium” alignment=”center” onclick=”custom_link” img_link_target=”_blank” link=””][/vc_column][/vc_row]