Excel - Creating High Impact Business Reports

Mike Thomas

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 the exceltrainer.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 organ........

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

Why should you attend?

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
Power View: Create a visually stunning interactive report (2013 & 2016 only)
PowerMap: An Excel addin that lets you display and analyse geographic data as a visual map (2013 & 2016 only)

Who can 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 Excel 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 and Power View are not available in Excel 2010. Not all versions of Excel 2013/2016 include Power Map and Power View. If in doubt whether this training is relevant for your version of Excel, please check with your IT department.

Webinar Id: ISSMTE002

Training Options

Duration: 90 mins

View Anytime

Ratings:

View Reviews