Microsoft Excel Building Excel Dashboards

Microsoft Excel

Building Excel Dashboards

Course Overview

Participants in this Microsoft Excel – Building Excel Dashboards half-day course will gain hands-on experience in the set up an Excel Dashboard to provide analysis, insights, and alerts for your business.

You will prepare a calculation spreadsheet based on raw data, then add an interface to visualise your data. This fast-paced course means you won’t need to be away from the office for a full day.

The course assumes you have a solid working knowledge of Excel, those who are working with spreadsheets created by others will also benefit from attending this course.

Am I Ready For This Training?

Participants should have a good understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Microsoft Excel Intermediate training course, or have some prior experience using simple Excel Spreadsheets, including entering and editing data, creating formulas and IF functions, along with some basic charting.

Once you’ve completed this course, you may also like to attend one of our Excel Advanced courses, or if you prefer a ½ day course, then Excel Pivot Tables may compliment this course.

Course Details

Course Skill Level

Introduction

Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

½ Day Training Course

Class Times

9:00am – 12:00pm or 1:00pm – 4:00pm

Your Course Includes

Price

$440.00

Upcoming Public Courses

Courses

There are no upcoming courses at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

Read our Course Terms and Conditions

Course Content

Dashboard Overview

Exploring Excel Dashboards
Dashboard Examples

Preparing your Data

Working with Raw Data
Converting Lists to Tables

Creating Summary Sheets

Using SumIF and SumIFs
Using CountIF and CountIFs
Summarising Data
Working with Dynamic Data

Validating Data

About Data Validation
Setting up Validation Rules
Input Messages
Error Alerts

Building the Dashboard

Setting up a Visualisation
Building Charts from Dynamic Data
Setting up Validation
Using Conditional Formatting
Adding Sparklines

*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.

Learn Today Face to Face Online with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily.

When you complete our training course, you will be ready to apply your new skills right away.

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us at info@keystrokelearning.com.au

(03) 9999 7780

Training Centre