Excel Dashboard Tutorial From Basic to Advanced

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. As a professional, you may have access to tons of data. But, the important aspect of decision making is drawing actionable and relevant conclusions.

If you give your boss an Excel file with customer call data 10,000 rows and 300 columns, your boss won't be able to take a decision from this raw data.You will still need to summarize this with key variables as levers so the dashboard operator can quickly draw patterns and derive conclusions.

I don’t want to make you shine for your Boss. I want you to become the BOSS. This MS Office Training will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.

What’s covered in the Excel Dashboard course?

• ✓ Dashboard fundamentals (Optional): Design tips, Data formats, Formatting, Data cleaning, Sparklines, Spider, waterfall and bubble charts, List- controlled graphs, pivot tables and dynamic functions. Skip this section if you’re already an intermedia user
• ✓ Learn to create 4 types of dashboards from scratch with 100+ techniques
  • ✓ Single sheet tracker controlled by list field across multiple sheets
  • ✓ Pivot table dashboard using interlinked pivots, slicers and button-controlled charts
  • ✓ Map chart dashboard using Advanced Excel functions
  • ✓ Dynamic Dashboards using Excel Macros

You will learn the following techniques in excel dashboard:

1. Naming the dynamic data and the using it in function
2. Create Chart for comparison from the Pivot table
3. Create Trend line from the Pivot table
4. Creating Pie Chart from Slab Report from Pivot table
5. Inserting Slicer using Chart & Customize Slicer Setting
6. Creating Waterfall Chart
7. Creating Bubble Charts
8. Extract data from multiple sheet using OFFSET, INDIRECT and CELL
9. Form controls for interactive dashboard.
10. Creating Thermometer chart
11. Importing Data from the Internet
12. Converting Line Item into a Currency Table
13. Calculation of Currency using INDEX and MATCH
14. AverageIF for calculating Country Wise Salary
15. Dynamic Dropdown
16. Button-controlled charts and spark lines
17. List longitude and latitude with plotting data on dashboard
18. Using REPT Function based on the percentage calculation
19. Advanced INDEX and MATCH with multiple references
20. Insert World Map into the chart
21. Plotting Data on Map Chart and Controlling Map Preview from drop-down
22. Preparing the base by removing duplicate for Dashboard
23. Implementation of OFFSET for dynamic data
24. Using macro to update pivot table based on the Job Type
25. Preparing data for Spiderweb chart and change the graph setting
26. Use of Array functions like MAXIF and MINIF with single and multiple parameters
27. Creating Name Range using shortcut and many more