Creating High Impact Business Reports in Excel
Summary
Join us for a 90-minute workshop, where you’ll discover the most vital Excel reporting tools, which will assist you in decision making and communicating performance.
Gain critical knowledge for creating more accurate and visually appealing reports.
The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts, and presenting geographic-based data with Power Map.
You’ll discover the following and more:
- Excel techniques to minimize errors, save time & impress your audience
- How to analyze critical data more effectively with key commands & formulas
- Powerful PivotTable tools to speed-up your calculations & enhance the outcome
- Easy shortcuts to create charts with a few clicks: Keys to create & customize charts
- Discover insights that wouldn’t normally “stick out”: Get started with Power Map
Objectives
Mastering Excel Charts: Keys to Creating & Modifying Charts
- How to prepare your spreadsheet and speed-up your workflow
- Keys to organizing your charts: Setting the plumbing & choosing your style
- Design tips & tricks to communicate your message & look professional
- Ways to create powerful infographics using built-in Excel functionality
Leveraging PivotTables: Expert Methods for Accurate & Efficient Reports
- How to have complete data control & include every detail you need to know
- Tools to make your data work for you: Slicers, filters & more
- PivotTable shortcuts: Automate previously dreadful analyses
- Ways to format your PivotTable reports to make effective decisions
Getting Started with Power Map: Analyze Information in New Ways
- Methods to map your data & plot TONS of data visually
- Discover how to display & analyze geographic data in 3-D
- Solutions for sharing your story: Engage your audience like never before
Who should attend
Regardless of the business you’re in, your data as well as the reports that contain it, are the most critical tools for decision making and communicating performance. This training is aimed at existing users of Excel who need to learn how to create visually appealing Excel reports for increased impact. 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.
About the Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.