Microsoft Excel Dashboard & Interactive Report

The objectives of an Excel dashboard and interactive report course is to provide participants with the skills and knowledge to create dynamic and interactive data visualizations that facilitate analysis and decision-making.

The course typically covers topics such as:

• Creating and formatting data tables and pivot tables to organize and summarize data.
• Building advanced charts and graphs to represent data visually, such as dynamic charts, sparklines.
• Using Excel functions and formulas to manipulate data and create calculated fields.
• Creating dynamic and interactive dashboards and reports, such as using slicers, filters, and timelines.
• Designing custom user interfaces to enhance the user experience, such as using drop-down menus, buttons
• Applying best practices for data visualization and communication to improve the effectiveness of reports and dashboards.

By the end of the course, participants should be able to create dynamic and interactive reports and dashboards that facilitate data analysis and decision-making. 

Course Outline:

• Module 1 : Excel Dashboard 
• Module 2 : Data Visualisation Tools 
• Intro To Excel Dashboards 
• Using The Proper Visualizations 
• Dashboard Creation Process 
• Selecting The Right Chart? 
• Chart Making Process 
• Formatting Tricks 
• Module 3 : Creating Interactive Reports 
• An Alternative To The Vlookup Function 
• Calculating Standard Deviation 
• Showing Data Dispersion With Error Bars 
• Variance Analysis Dashboard 
• Returning A Value Based On User Input 
• Incorporating Controls 
• Incorporating Hyperlinks 
• Module 4 : Analysing Data With Pivot Reports 
• Creating A Pivot Report 
• Creating A Dynamic Range For Data 
• Expansion 
• Incorporating Visual Analysis 
• Adding Interactive Elements 
• Slicing & Dicing Data 
• Querying Pivot Reports 
• Module 5 : Automating Dashboards With Functions 
• OFFSET Function 
• COUNTA Function 
• Structuring Your Data 
• Linked Textbox 
• Named Ranges & Formulas 
• Module 6 : Automating Dashboards With VBA
• Basics Of VBA & Macros 
• Incorporating Macros In Dashboards