How to Create High-Impact Excel Reports

Download Training Material

Training Materials (Password Required)

Training Details

Training Format : Recorded Webinar

Webinar Date: Wednesday, March 01, 2017

Format Type: DVD

Presenter(s):Mike Thomas

Training Duration:90 minutes

Training Material Download Training Materials
(Password Required)

(1.45 MB)

Supporting File(s) Download Zip
(2.75 MB)

Training Description


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.

About Trainer

Mike Thomas , ,

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in..

Read More >>

Order Now