Accounting & Finance

Accounting & Finance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Business Management

Discover business management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Business Process Improvement

Business Process Improvement Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Legal & Compliance

Legal & Compliance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Procurement & Purchasing

Procurement & Purchasing Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Real Estate Management

Real Estate Management Training Courses Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart Building Services | Property Development | Property Asset Management | Retail Property Management | Operations and Facilities Management | Property Investment

view coursesgroup bookings

Supply Chain Logistics

Supply Chain Logistic Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Personal Development

Personal Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Training & Facilitation

Training & Facilitation Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Training by Industry

Industry Specific Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

First Aid Training

Discover first aid training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Workplace Health & Safety

Workplace Health & Safety Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Certificates & Diploma

Certificates & Diploma Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Communication Skills

Discover communication skills training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Customer Service

Discover customer service training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Government / Public Sector

Government / Public SectorTraining Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

TOP CATEGORIES

Government

Human Resources

Discover human resources training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Leadership Development

Discover leadership development training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Management Training

Discover management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

People Development

People Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings
Plum Solutions
Availability: BOOK NOW
more info

Data Analysis and Dashboard Reporting in Excel

Brisbane

$880.00per person

1 Day, 9:00am - 5:00pm

Public / Open

"Discover how to ""tame"" your data and make it work for you! 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. "
    Data Analysis Tools
  • Tool selection – Excel vs. other BI alternatives
  • What’s new in Office 2010 / 2013
  • Shortcuts for data manipulation in Excel
  • Pivot Tables
  • Overview of the free Microsoft add-in to Excel, PowerPivot


  • Using Excel as a Data Analysis Tool
  • Essential Excel tools & functions
  • Working with text
  • Cleaning your data
  • Creating a robust formula


  • Charting in Excel
  • Working with charts in Excel 2010/13
  • 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
  • What is a dashboard?
  • Purpose and benefits of Dashboards
  • Common mistakes when building a Dashboard
  • Creating a Dashboard in Excel


  • Dashboard Design
  • Principles of dashboard design best practice
  • Selecting the correct chart to display data
  • Adding icons and images to dashboards
  • Effective use of colour and logos
  • Making dashboards dynamic

    By 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!)
"Discover how to ""tame"" your data and make it work for you! 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. "
    Data Analysis Tools
  • Tool selection – Excel vs. other BI alternatives
  • What’s new in Office 2010 / 2013
  • Shortcuts for data manipulation in Excel
  • Pivot Tables
  • Overview of the free Microsoft add-in to Excel, PowerPivot


  • Using Excel as a Data Analysis Tool
  • Essential Excel tools & functions
  • Working with text
  • Cleaning your data
  • Creating a robust formula


  • Charting in Excel
  • Working with charts in Excel 2010/13
  • 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
  • What is a dashboard?
  • Purpose and benefits of Dashboards
  • Common mistakes when building a Dashboard
  • Creating a Dashboard in Excel


  • Dashboard Design
  • Principles of dashboard design best practice
  • Selecting the correct chart to display data
  • Adding icons and images to dashboards
  • Effective use of colour and logos
  • Making dashboards dynamic

    By 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!)

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

Need Approval?