Booking Information
Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle site.
About this Course
A dashboard is a single-page overview of a company’s KPIs. The information is normally provided in tables, graphs, and charts so that senior members of staff can quickly see how departments and products are performing.
Across 11 lessons, you’ll learn the most efficient ways of extracting insights from data and find out why and how companies build dashboards.
By the end of the course, you’ll feel confident in creating your own dashboard of your company’s KPIs to suit the audience of your project.
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. It covers the following topics:
- Why Build Dashboards?
- Designing Your Dashboard
- Calculating Headline Values
- Adding Charts to Your Dashboard
- Time-Based Charts
- Segmenting by Customer Size
- Sales Team Analysis
- Add Interactive Buttons to the Dashboard
- Link Sales KPIs to Buttons
- Ranking Metrics
- Formatting Your Dashboard
Key Outcomes
- Explain the purpose of a dashboard in Excel
- Design the layout of a dashboard
- Calculate the headline values of a dashboard
- Add various charts to a dashboard
- Add interactive charts to a dashboard
- Add formatting to a dashboard
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.