Outlines
MICROSOFT EXCEL DASHBOARD & INTERACTIVE REPORT
Course Objectives
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
