SPECIALISTS IN FINANCIAL MODELLING
0 item(s) $0.00 AUD + GST

Data Analysis and Reporting

Course info

Duration : 1 day

Cost: $990.00 inc. GST.

Testimonials

"Clear presentation, well organised and great examples used which can be adopted to current business models and workpapers.Customised in-house Data Analysis Course, Sydney, July 2011"

View testimonials for this course

Download the course outline

Upcoming workshops

There are currently no workshops scheduled for this course.

Take this course in-house

Online Courses

Interested in taking this course online? Register your interest now!

This course is offered in-house only, but is also part of our Data Analysis & Dashboard Training workshops which are held regularly in Sydney, Melbourne and Brisbane.  If you are interested in Data Analysis, you might also consider the Data Analysis Masterclasses Special Event being run by Chandoo in Australia in 2015.

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 2010 and the new 2013.

Each participant on this course receives a hard copy of the book Using Excel for Business Analysis.   Re-using your copy, got several participants or want to book on multiple courses?  Consider making a bulk booking and save.

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

If you are unsure about your level of Excel, you might also consider joining the online Excel School prior to coming on the course.

Who should attend this course?

This course is intended for anyone who needs to create reports in order to interpret and present information.  It is expected that students should have had some exposure to business or finance principles.

Course Format

Public courses are run in a computer laboratory with workstations provided. Participants may bring their own laptops if they prefer.   The course is demonstrated using the latest version of Microsoft Excel, but students can use other versions of Excel if they prefer.  Course materials contain instructions for all versions, and Excel 2011 for Mac users are also catered for.  PCs are used during this course, so Apple Macintosh users may prefer to bring their own laptops.

Students are encouraged to share their own experiences with the class, and are welcome to bring examples of their own data or reports to discuss during the course

Learning Objectives

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.

By the end of the day, participants will:

•    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

Fundamentals of Data AnalysisTraining photo

•    Challenges in Data Analysis
•    Data Relationships; One to Many, Many to One
•    Mean, Median & Mode
•    Common Data Analysis terminology

Data Analysis Tools

•    Comparison between Excel & Access
•    What’s new in Office 2007 / 2010
•    Shortcuts for data manipulation in Excel
•    Pivot Tables

Using Excel as a Data Analysis Tool

•    Essential Excel tools & functions
•    Working with text
•    Cleaning your data
•    Creating a robust formula
•    Forecasting

Charting in Excel

•    Working with charts in Excel 2007/2010
•    Charting on different axis
•    Bubble and Waterfall charts
•    Charting with dynamic ranges

Chart and Table Design

•    Tables vs. Charts/Graphs
•    Visual Design; presenting data graphically
•    Choosing the correct chart to display your findings
•    Charting dos and don’ts

Dashboard Reporting

•    Purpose and benefits of Dashboards
•    Common mistakes when building a Dashboard
•    Creating a Dashboard in Excel

Balanced Scorecards

•    What is a Balanced Scorecard?
•    Benefits and pitfalls of a Balance Scorecard

Comments from Past Students

“I will take some excellent tips away with me from today – thank you!”
"Course was well balanced with practice and theory. Presenter was very knowledgeable and topics were easy to understand."
“The content is packed but presented in a simple, informative and effective way.”