Learn how to display your data in a range of visually appealing charts using Microsoft Excel.
Description
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
Learning 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.