Creating High Impact Business Reports in Excel

Price: $

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

This workshop will provide a skill set upgrade, regardless of the level you are as an Excel user!

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.

Credits

Credit Hours:

Field of Study:

Program Level:

Basic Knowledge

Prerequisites:

None

Advance Prep:

Delivery Method:

Group Internet Based

Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Purchase This On-Demand Webinar