Book Online: Login | Register

1300 658 388

Search form

 

 

Learn how to turn raw data into business intelligence to help you make more informed decisions. This virtual training course will focus on learning how to set up a dashboard using tools in Excel to extract meaningful information from large datasets. A dashboard is a powerful visual display of the most important status and performance indicators of your project or business. The course is suitable for Excel versions 2007, 2010 and 2013.

Course Price (inc GST where applicable): 
$99.00
Locations: 
Online
Duration: 
90 mins
Versions: 

2007, 2010, 2013

You'll Learn how to: 

You will learn how to:

  • Work with Excel data in lists and tables
  • Use Validation Rules to create a simple drop-down list user interface
  • Use SUMIF and SUMIFS functions to extract the dashboard data
  • Create dynamic charts
  • Test and modify your dashboard
Course Content: 

Overview of Excel dashboards

Why use dashboards
Types of dashboards

Setting up the dashboard elements

Optimising a list
Building an analysis sheet
Using SUMIF and SUMIFS
Extracting unique values

Building dynamic charts

Chart types
Creating a chart
Modifying a chart

Bringing it all together

Testing the dashboard
Changing variable data and seeing the results

This Course Suits: 

This course will suit you if you work with large data sets in Excel and want to create a simple and dynamic Dashboard which can be used for analysis and reporting.

Prerequisites: 

Successful completion of a TP3 Excel Introduction course or the Creating and Using Simple Formulas online course.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon