(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

Keystroke Learning - Main Menu
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 
Building Excel Dashboards

Microsoft Excel
Building Excel Dashboards

Microsoft Excel Computer Training Course

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.

Course Details

Course Skill Level

Intermediate

Class Size

10 Students (max)

Course Duration

½ Day Training Course

Class Times

9:00am -12:30pm

Price

$350+GST

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

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
Keystroke Learning - Building Computer Skills to Enable Success

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 @ info@keystrokelearning.com.au

Melbourne Training Venue

Level 2 / 52 Albert Rd
South Melbourne, VIC, 3205

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success

Log in