Course
|
Excel

Build Your First Dashboard

Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Explain the purpose of a dashboard in Excel
Design the layout of a dashboard
Calculate the headline values of a dashboard
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Build Your First Dashboard

Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Explain the purpose of a dashboard in Excel
Design the layout of a dashboard
Calculate the headline values of a dashboard
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

11 Lessons
Why Build Dashboards?
3 MINS
LESSON
Why Build Dashboards?
Exercise

Dashboards are a convenient way of extracting insights from data. Find out why and how companies build dashboards in this lesson.

Designing Your Dashboard
5 MINS
LESSON
Designing Your Dashboard
Exercise

The hardest part of building the dashboard is the initial design. At this stage, you need to decide information to include and where it will sit on the dashboard.

Calculating Headline Values
6 MINS
LESSON
Calculating Headline Values
Exercise

Most dashboards will have some headline values such as total revenue and growth rate. Here I'll show you how to calculate these values and include them in the dashboard

Adding Charts to Your Dashboard
5 MINS
LESSON
Adding Charts to Your Dashboard
Exercise

Charts make it easier to spot trends and insights from our data. As a result they are a crucial component of all dashboards.

Time-Based Charts
5 MINS
LESSON
Time-Based Charts
Exercise

Time-based charts are one of the most common types of charts you'll create in a dashboard. Here, we'll learn how to split annual revenue by month.

Segmenting by Customer Size
5 MINS
LESSON
Segmenting by Customer Size
Exercise

Profitability and cost can often vary by customer type. It's often worth segmenting customers by industry or by size to gain additional insights into your customers.

Sales Team Analysis
6 MINS
LESSON
Sales Team Analysis
Exercise

In this lesson, we'll analyse the performance of our salesforce, calculating the annual revenue generated by each sales manager.

Add Interactive Buttons to the Dashboard
5 MINS
LESSON
Add Interactive Buttons to the Dashboard
Exercise

Interactive buttons allow you to include more information on the dashboard and enhance the user experience. Find out how to add a simple dropdown button in this lesson

Link Sales KPIs to Buttons
5 MINS
LESSON
Link Sales KPIs to Buttons
Exercise

In this lesson, we'll learn how to link our sales KPIs to the input button. Now when we select a sales manager, his KPIs will update automatically on the dashboard

Ranking Metrics
5 MINS
LESSON
Ranking Metrics
Exercise

To rank our sales managers in terms of performance, we'll need use the RANK() function for each of our sales team metrics.

Formatting Your Dashboard
4 MINS
LESSON
Formatting Your Dashboard
Exercise

It's important that your dashboard fits on one screen and is formatted neatly so users will be inclined to use it. Some formatting tips in this lesson will help you accomplish this task.

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo