In this webinar, you'll learn not only how to turn raw data into meaningful information but also how to present that data in a visually attractive way. This training will provide you with a solid foundation that you can use to build your own business reports.
In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a percentage (no formulas, arithmetic or programming required!), make the pivot table eye-catchingly appealing to read and then group the data (by month or numeric range).
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.
Note: The training will be delivered using the latest version of 2016 for Windows although for users of earlier versions, some of the functionality is available in Excel 2010 and much of the functionality is available in Excel 2013.
IMPORTANT: PowerMap is not available in Excel 2010.
Why Should You Attend:
The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts and presenting geographic-based data.In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a percentage (no formulas, arithmetic or programming required!), make the pivot table eye-catchingly appealing to read and then group the data (by month or numeric range).
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.
Note: The training will be delivered using the latest version of 2016 for Windows although for users of earlier versions, some of the functionality is available in Excel 2010 and much of the functionality is available in Excel 2013.
IMPORTANT: PowerMap is not available in Excel 2010.
Areas Covered in the Webinar:
- 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)
Who Will Benefit:
- Accountants
- CPAs
- CFOs
- Financial consultants
- Controllers
- Banking
- Finance
- Insurance
- Education
- Telecom
- IT
- Marketing
- Sales
- Investments
- Pharmaceutical
- Medical Devices
- FDA
- Aviation
- Energy
- Retail
- Human Resource
- Logistics & Supply Chain
- Accounts
- Audit
Course Provider
Mike Thomas,
