Creating Dashboards in Excel
Dashboards are useful for presenting complex information in a more user-friendly way. This course will guide you through the fundamentals of creating dashboards in Excel, enabling you to produce professional charts and interactive visualisations that will inform users.
This course will enable you to
- Produce visually appealing and informative dashboards
- Create a variety of popular Excel charts
- Create interactive visualisations for the analysis of dashboards, using dynamic functions
- Hide sheets, use scroll lock and protect your dashboards
About the course
As accountants, we often have vast amounts of data to present. Creating dashboards is a very useful way of transforming complex data into clear, and presentable information. Using dashboards, we can convey the meaning behind data quickly and effectively.
This course will enable you to create visually appealing and informative dashboards in Excel. It guides you through the steps needed to organise and collect your data, and how to create professional charts and interactive visualisations that will inform users.
Look inside
Contents
- What's a dashboard?
- What's a dashboard?
- Where to start
- Charting demonstrations
- Inputs and calculation sheets
- Creating a custom visual overlay
- Waterfall charts
- Gauge charts
- Sales versus budget
- Tidying up our chart
- Making dynamic and interactive visualisations
- The function junction
- Automating charts with named ranges
- Continuing with automating charts with named ranges
- Named ranges
- Chart enhancement
- Form controls
- Putting it all together
- Putting it all together
- Dashboard protection
- Hidden and very hidden sheets
- Setting scroll lock
How it works
Author
Reviews
| Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
|---|---|---|---|---|
| Access to this course | ||||
| Total CPD unitshourshours | 4 unitshourshours | 21 units20 hours21 hours | 1,500+ unitshourshours | 1,500+ unitshourshours |
| Access period | 120 days | 120 days | 12 months | 12+ months |
| Audit-proof CPD completion certificate | ||||
| Immediate access to our entire CPD catalogue | ||||
| Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more! | ||||
| Account manager on hand to support your team’s needs | ||||
| Learn more | Learn more | Learn more | ||
Why not upgrade?
Find the best way to complete your CPD
You might also like
Take a look at some of our bestselling courses