Data Analysis & Reporting in Excel

Melbourne

$770.00

Training Course ID: (PS)-00007

Overview: 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. This course will help you understand how to "tame" your data and make it work for you! 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 2007.

Training Course Details

Duration
1 Day 9:00am - 5:00pm
TypePublic / Open
Provider

Plum Solutions

CPD0
Venue

Level 8, 500 Collins Street, Melbourne

VersionIntermediate

Outlines

Training Course Outlines:

Course content includes:

  • Fundamentals of Data Analysis
  • Common Analysis Tools
  • Chart and Table Design
  • Dashboard Reporting
  • Balanced Scorecards

Outcomes

Training Course Outcomes:

  • Understand the principles of data analysis
  • Be aware of different tools available to perform their analysis
  • Consider when to use a chart or a table
  • Know how to use visual effects to improve their reports and presentations
  • Understand the concepts of dashboard reporting and balanced scorecards
  • Know how to summarise, present and communicate data clearly and concisely

Accreditations / Prerequisites
Course Accreditations:

Course Prerequisites:

The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a regular basis, and are comfortable with using its tools and functions.
At minimum, it is assumed that participants will know how to:
• Navigate confidently in Excel
• Create and use formulas
• Link between workbooks
• Build a basic chart

Related Courses

Related Courses:

390 visited

People Visited:

390 people visited

BOOK THIS COURSE

Select Dates

Tuesday, 24 Jul 2012

Add Attendees (Min 1 and Max 10)




Attendees x 0

Add To Cart

Selected Course Date:

Course Attendees:

PRICE / Person:

$770.00