Data Analysis & Reporting in Excel

Melbourne $880.00 AUD per person

Training Course Overview Add to Compare Add to My Development Plan

Training Course ID: (PS)-00007

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.

Duration: 1 Day 9:00am - 5:00pm
Provider: Plum Solutions
Venue: Level 8, 500 Collins Street, Melbourne
Type: Public / Open

Course content includes:

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

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

Prequisites:

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 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: