Identifier: 54498127

Duration:

Subscription Period: 365 Days

Language: English

Cost: AUD 62.00

 

Action

Add To Cart

Overview

Learn how to display your data in multiple chart forms and then add trend lines using in-built analysis to project how data might appear in the future.

This recorded webinar will focus on creating three very different charts.

Key topics:

  • Charts to use, and charts not to use, to show trends
  • A trending column chart with shapes are the primary series
  • A bullet chart (essentially an attractive stacked column chart)
  • A four segment line chart, each with its own series

Objectives

  • Create trends using the ‘Forecast’ formula to track future sales or spend projections
  • Add data tables to your report and create in cell formula which appears as a chart
  • Add shapes to your charts to highlight when targets are met (these move dynamically as the goal posts shift)
  • Work through the detailed tasks accompanying the webinar to test your knowledge 

Audience

Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.

loading...