Excel Dashboard Course [Online Access]

₹ 1,299

Mashup of - MS Excel Beginner Course, MS Excel Intermediate Course, MS Excel Advanced Course, MS Word, Excel Dashboard, MS PowerPoint and MS Outlook

Excel Superstar offers courses that are uniquely designed to give you a complete tour of Excel Dashboard and its Techniques. Anyone who wishes to master MS Excel or any other Microsoft Office Tools completely can do it here. The mission is to turn our learners into Absolute Professionals who have complete knowledge about MS Office Tools.

Learn Excel Dashboard Course
Full Beginner to Advanced Course
50+ Mp4 Videos
Total 240+ mins of videos tutorials
Training Files
Online Access
Language English
Price including GST
Call 7021329219 for more info

Our Course has got 50+ video tutorials to benefit your Excel and other Microsoft Office course-based Knowledge. These video tutorials will help you to learn ‘How to deliver faster while doing less work.’ These are Educational Videos having fun elements as well so that the learners do not lose the interest. Fun Elements are the extended benefits to users which helps in memorizing the lessons well.

All the courses of MS Office are designed keeping the users in mind. It should deliver its complete value-adding productivity in the Professional life. This will help you to Achieve the quest to Work Smart and achieve more

The same video tutorials are put up on our Website and YouTube Channel. There are training files that will be made available to the Learners.

The list of things that you’re going to get from this course:
1. 50+ top-notch videos
2. All the training materials

Table of Content

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 then 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 Trendline 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 the 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 the 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 the drop-down
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 a better view
0405 Using Macro recording for Trend Chart 01
0406 Using a macro to update pivot based on the Job Type
0407 Triggering macro with any change in sheets
0408 Creating Name Range using the shortcut
0409 Use of MAXIF and MINIF with single and multiple parameters
0410 Create a chart to represent multiple parameters effectively 01
0411 Create a chart to represent multiple parameters effectively 02
0412 Preparing data for Spiderweb chart and change the graph setting
0413 Using a macro to Hide and Unhide working sheets
0414 Inserting Trendline and formatting for a better view
0501 Conclusion of all 3 dashboard

Requirements are simple:

  1. Since you’re getting the Tutorials in the video form, you need a laptop or a Computer.
  2. You need Microsoft office tools in your PC like MS Excel.
  3. If you have a smartphone, such an add-on, view it while you’re free, traveling or whenever you wish to.

This offer is valid in all over India.

In case if you’ve any question or doubt, feel free to clear your doubts. We’re available for assistance.

You can mail us on - <info@excelsuperstar.org>
You can call on - +91 7021329219
Address: Suit No. 1 Sunderdham Society, Near Jai Vaibhav Society, Jambali Gali, Borivali West, Mumbai – 400 092

Find Bank details below to pay via Cash deposit in Bank:
Bank Name: YES BANK
IFSC Code: YESB0000213
Account Number: 021383800001525