Excel - Creating High Impact Business Reports
22 Nov 2017
- 02:30 AM to 04:00 AM EST
90 Minutes

Using Excel to Create Visually Appealing and Meaningful Reports

Excel - Creating High Impact Business Reports

Mike Thomas has 27 years experience in corporate IT training, working with and for organizations across a diverse range of industries including pharmaceutical, healthcare, legal, retail and public sector. He designs and delivers face-to-face, virtual, written and video-based training and provides IT support to users. Mike’s key technical skills include Microsoft Office, Lync, SharePoint, VBA development and database development.

There is no webinar video currently available. Please check back soon.

No matter what business you are in, a report is a critical tool in your communication armory. 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 (KPIs) upon which a business or project is measured. Get it wrong and you'll end up with something that nobody understands or wants to read.

Join this session with Excel trainer Mike Thomas where 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 session will provide a solid foundation that you can use to build your own reports. The session will focus primarily on four areas: PivotTables, charts/graphs, the Power View report add-in, and how to present geographic information

In the PivotTables section, you will learn how to create a basic PivotTable, display numbers as a percentage (no formulas, arithmetic or programming required!), make the PivotTable eye catching and appealing to read and then group the data (by month or numeric range). In the visual communication (charts/graphs) section, you will 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. With Excel's Power View add-in, available only in the 2013 and 2016 versions, you'll learn how to create visual reports containing interactive charts, graphs, maps, and other visuals that bring your data to life. The final part of this session will cover Excel's Power Map tool, also available in the 2013 and 2016 versions only, which lets you plot geographic (country, region, state, etc.) data on an interactive 3-D globe or custom map.

Session Highlights
• Charts: Style and design tips and tricks to tell your story/ convince your audience
• Charts: Creating powerful infographics using built-in Excel functionality
• PivotTables: Fundamentals
• PivotTables: Percentages in 5 clicks without formulas
• PivotTables: Fonts, number formatting and layout options
• PivotTables: Grouping data based on month or numeric range
• Power View: Creating a visually stunning interactive report
• PowerMap: An Excel add-in that lets you display and analyze geographic data as a visual map

Learning Objectives
In this Excel training session, 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 webinar will provide you with a solid foundation that you can use to build your own reports.

Who Should Attend
• Existing Excel users who need to learn how to create visually impactful Excel reports
• Those who want training using Excel 2016

You may also like

HR Certification Institute Approved Provider

Proskilleducator.com is an HRCI Approved Provider and can assign recertification credit hours (based on HR Certification Institute standards) to HR-related continuing education events, including qualification for PHR, SPHR or GPHR recertification credits. The use of this seal is not an endorsement by HR Certification Institute of the quality of the program. It means that this program has met HR Certification Institute’s criteria to be pre-approved for recertification credit.

SHRM Approved Recertification Provider

"proskilleducator.com" is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.  Our program is valid for PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org