Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for intermediate learners who have some familiarity with building charts in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 11 lessons, 3 exercises and 1 Exam. It covers the following topics:
- Why build dashboards?
- Designing the layout of your dashboard
- Calculating headline values
- Adding charts to your dashboard
- Creating time-based charts
- Segmenting the data by customer size
- Performing sales team analysis
- Adding interactive buttons to the dashboard
- Linking sales KPIs to interactive buttons
- Ranking metrics
- Formatting the dashboard
Key Outcomes
Once you have completed this course you will know how to design a full sales reporting dashboard in Excel, add charts to your dashboard and even include interactive dropdown buttons on your dashboard. What’s more, you’ll know which data and which visualisations to use for different KPIs and analyses.