Skip to main content
Charts and Dashboards

Build Your First Dashboard

If you’d like to visualize your data on a larger scale, dashboards are the answer. These offer a single-page overview of all the company’s KPIs and are accessible in nature. In this course, you’ll learn how to build an interactive dashboard, which can be viewed regularly as the numbers update throughout the year.

Intermediate        11 Lessons        120 Minutes        CPD Credits
Start Today

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 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.

Start Today

Learning 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


1. Why Build Dashboards?
2. Designing Your Dashboard
3. Calculating Headline Values
4. Adding Charts to Your Dashboard
5. Time-Based Charts
6. Segmenting by Customer Size

Read More

7. Sales Team Analysis
8. Add Interactive Buttons to the Dashboard
9. Link Sales KPIs to Buttons
10. Ranking Metrics
11. Formatting Your Dashboard
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world