Excel - Creating High Impact Business 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. This training will provide you with a solid foundation that you can use to build your own reports.

Mike Thomas
Instructor:
Mike Thomas
Date:
Tuesday, August 13, 2019
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
90 Minutes

More Trainings by this Expert   Product Id : 502668

Price Details
$150 Live
$290 Corporate Live
$190 Recorded
$390 Corporate Recorded
Combo Offers
Live + Recorded
$289 $340 Live + Recorded
Corporate (Live + Recorded)
$599 $680 Corporate
(Live + Recorded)
Price Detail Options
Overview:

No matter what business you are in, a report is a critical tool in your communication armoury. 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.

Why should you Attend: 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. This training will provide you with a solid foundation that you can use to build your own reports.

Areas Covered in the Session:

  • Charts: Style and design tips and tricks to tell your story / convince your audience
  • Charts: Creating powerful infographics using built-in Excel functionality
  • Pivot tables: Fundamentals
  • Pivot tables: Percentages in 5 clicks without formulas
  • Pivot tables: Fonts, number formatting and layout options
  • Pivot tables: Grouping data based on month or numeric range
  • PowerMap: An Excel addin that lets you display and analyse geographic data as a visual map (2013 & 2016 only)

Learning Objectives:
  • The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts and presenting geographic-based data
  • In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a percentage (no formulas, arithmetic or programming required!), make the pivot table eye-catchingly appealing to read and then group the data (by month or numeric range)
  • In the visual communication (charts/graphs) section, you'll 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
  • The final part of the training will focus on Excel's Power Map tool (2013 and 2016 only) which lets you plot geographic (country, region, state etc) data on an interactive 3-D globe or custom map

Who Will Benefit:
  • This training is categorised as intermediate-to-advanced. It is aimed at existing users of Excel who need to learn how to create visually impactful Excel reports
  • 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


Speaker Profile
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 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered 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 organisations 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.




Your Recently Viewed Webinars

Payment Methods

Contact Us

NetZealous LLC,
39658 Mission Boulevard, Fremont,
CA 94539, USA.

Information

  Refund Policy
  +1-800-447-9407
  Fax: 302 288 6884
  support@compliance4All.com