Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Automate Excel
·
Module 12
Interactive Dashboards and Final Outputs
1
Dashboard Layout Design
Design and create a dashboard layout with placeholders for KPIs, charts, and controls.
2
Automating Dashboard Refresh with VBA
Write a VBA macro to refresh all data sources, including PivotTables, for a dashboard.
3
Populating KPI Cells with VBA-Calculated Metrics
Populate dashboard KPI cells with key metrics calculated via VBA.
4
Automating Reports with Form Controls
Add form control buttons to the dashboard to execute various report generation macros.
5
Dynamic Data Filtering with Dropdown Menus
Add a form control dropdown menu to the dashboard to dynamically filter displayed data.
6
Exporting Worksheets to Dynamically Named PDFs
Write a macro to export a specific worksheet or dashboard to a PDF file with a dynamic filename.
End of course,
Back to course
Previous module
Automating Financial Reports with VBA
Next module