Call: 1300 768 368 or

Plum Solutions

Data Analysis and Dashboard Reporting in Excel

Sydney $880.00 AUD per person

Training Course Overview

Training Course ID: (PS)-00011

With the huge amount of data available to us every day, a well-built and designed dashboard reports is one of the best ways to interpret and communicate large quantities of information. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs.

Duration
1 Day 9:00am - 5:00pm
Provider
Plum Solutions
Venue
Level 10, 10 Barrack st
Type
Public / Open

Detailed Course Information

Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics which don’t mean anything or can’t be made sense of, it’s no wonder that data is often misinterpreted or not communicated at all. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs. Covering dashboard reporting, balanced scorecards, visual design of charts and tables, we will also discuss the new charting and analysis features of Excel 2010 and 2013.

This course is very hands-on and practical. Each participant will be expected to create their own reports, charts and models utilising the tools and techniques covered during the course.

At the end of the day, participants will:

  • Understand the principles of data analysis
  • Learn to synthesise and summarise information into a logical framework.
  • Consider when to use a chart or a table
  • Know how to use visual effects to improve their reports and presentations
  • Explore how to summarise, present and communicate data clearly and concisely
  • Learn the principles of good dashboard design and presenting data graphically
  • Discover the tools to analyse data & build reports using your existing Excel tools and skills (and perhaps a few you didn't know you had!)

Related Training Courses

Provider Terms & Condition

Plum Solutions

Plum Solutions delivers training in the following course categories

  • Financial Modeling
  • Financial Services

Plum Solutions Training Courses and Open Programs in Sydney, Melbourne and Brisbane, Australia. With Training Courses available in these categories:


Short Courses and In-House Training Programs:


Accounting & Taxation | Business Courses | Communication Skills | Financial Services

Call us to book on 1300 768 368

I need to
book training
for myself!

1  Select Dates

Tuesday, 10 Jun 2014

2  Add Attendees


View Payment Options

Payment Options

"Don't forget to add your donation to Tools for Schools at checkout"

A small donation will make a huge difference"

more info

I would like to
send this course
to a friend!
I need to
arrange training
for my team!

Request a Quote