How to Create High-Impact Excel Reports

Training Format: Recorded Webinar

Format Type: DVD

Speaker(s): Mike Thomas

Supporting File(s) : Download Zip (2.75 MB)

Webinar Date: Wednesday, March 01, 2017

Training Duration : 90 minutes

Training Material Download : Training Materials (Password Required) (1.45 MB)


Untitled Document

Make High Impact Reports In Excel Using These Tips

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 (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.

Excel reporting skills are in high demand! This webinar How to Create High-Impact Excel Reports by Mike Thomas will provide you with a solid foundation that you can use to build your own reports. In this 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. The webinar supports MS Excel 2010, 2013 and 2016 version of MS office software.

Learning Objectives

After attending this webinar, you’ll be able to learn the quickest and best ways to work in Excel 2016, including:

  • Using Pivot Tables to create summary reports
  • Making a Pivot Table visually appealing—fonts, number formatting, layout etc
  • Using formulas and functions in a report: LOOKUP, INDEX, MATCH and more
  • Visual communication in Excel using charts and infographics
  • Bring your reports to life using the free “Power View for Excel” add-in
  • Creating 3-D geographic reports using the free “Power Map for Excel” add-in

Session Highlights
You will learn the quickest and best ways to create reports, including these capabilities:

  • Pre-requisites for source data—preparing data so it can be analyzed by a PivotTable
  • Creating a PivotTable with a minimum number of steps
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Exploring the best techniques for updating PivotTables
  • Creating PivotTables from multiple input sources (different worksheets and workbooks)
  • Creating ad hoc and date-based groupings within a PivotTable
  • Using Conditional Formatting with PivotTable data

Who Should Attend

Novice or expert Excel users who need to expand their knowledge of Excel functions and need to improve their day-to- day efficiency as they work with this powerful software.

  • Data analysts
  • Finance professionals
  • Leaders
  • Human Resource Professionals
  • Office Managers
  • Staff
  • All Excel users

Have a question? Ask your doubts at the Q&A session after the live event and get special advice pertaining to your specific situation, straight from our expert 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. In 2012 Mike founded where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural and .. Read More >>



( * ) Single User Price Only.

For Multiple Users/Group, Call 1-800- 270-5740.


Data Visualization With Excel
by Mike Thomas

How To Build An Effective Dashboard With Microsoft Excel
by Mike Thomas

Advanced Techniques For Creating Great PowerPoint Presentations
by Mitzi Gibson Katz