EOFY sale: up to 30% off selected CPD automatically applied. Ends 31 March.
CPD 1.5 hours On Demand Course Online

Applied charts and dashboards - Session 3 - Turning data into information

Applied charts and dashboards - Turning date into information forms the third part of a six course series that discusses the merits of relating key business narratives visually.

$109.09

non-member : $130.91

Description

How do you convert masses of data into key insights and other useful information? This session looks at some of the professional tips of using Excel to assist you.

  • Working with Tables
  • Using PivotTable
  • Working with PivotCharts
  • Slicers vs. filters vs. FILTER
  • Quick charts, Sparklines and Analyze (sic) Data
  • Microsoft’s Recommendations

This 'Applied charts and dashboards' series will help fine tune your interactive charting / dashboarding skills and hone your reporting techniques and hone your reporting techniques. Understand the importance of colour, dashboard positioning, formats, styles and know which visual to use when, how and why. A mix of supporting theory, combined with many hands-on illustrative examples, used to work through concurrently or afterwards. 

You can find more information about the other five sessions in the 'Agenda' tab. 

 

Agenda

Presenter