Learn how to create an interactive whole of organisation infographic report using Microsoft Excel.
Overview
Learn how to create an interactive whole of organisation infographic report using Microsoft Excel.
Key topics:
- Build a data table with conditional formatting
- Build some revenue and expense pie charts to display a percentage
- Create some revenue analysis using a chart within chart technique
- Incorporate a picture into the analysis
- Add some conditional formatting to create a chart from Excel cells and wingdings
Objectives
- Create a holistic view of the organisation, display interactive data from operations, finance and human resources
- Create active x combo boxes for different metrics to display in the report
- Create analysis by region or team/department
- Build summary tables and create trends in the charting which can be turned on or off
- 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.