No matter what business you are in, a report is a critical tool in your communication armoury. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder or Project Manager) a valuable insight into the Key Performance Indicators (KPI’s) upon which a business or project is measured. Get it wrong and you'll end up with something that nobody understands and nobody wants to read. In the visual communication (charts/graphs) section, you'll learn how to enhance and customize a standard chart ("from drab to fab") as well as how to create infographic-style charts using nothing but Excel. The final part of the training will focus on Excel's Power Map tool (2013 and 2016 only) which lets you plot geographic (country, region, state etc) data on an interactive 3-D globe or custom map.
Agenda
- Charts: Style and design tips and tricks to tell your story / convince your audience
- Charts: Creating powerful infographics using built-in Excel functionality
- Pivot tables: Fundamentals
- Pivot tables: Percentages in 5 clicks without formulas
- Pivot tables: Fonts, number formatting and layout options
- Pivot tables: Grouping data based on month or numeric range
- PowerMap: An Excel addin that lets you display and analyse geographic data as a visual map (2013 & 2016 only)
