excel manage lists 2017 - Excel - Creating High Impact Business Reports -BY AtoZ Compliance

Key Take Away:
The training will focus on 4 areas - Pivot tables, charts/graphs, the Power View report add-on and how to present geographic information.
Overview:
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.
Why Should You Attend:
Details of the 4 main sections that will be covered –
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!), and make the pivot table eye-catching 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.
With Excel's Power View add-on (2013 and 2016 only) 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 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.
Areas Covered In This Webinar:
Pivot tables: Fundamentals
Pivot tables: Percentages in 5 clicks
Pivot tables: Fonts, number formatting and layout options
Pivot tables: Grouping data based on month or numeric range
Charts: Style and design tips and tricks to tell your story / convince your audience
Charts: Creating powerful infographics using built-in Excel functionality
Power View: Create a visually stunning interactive report
PowerMap: An Excel add-on 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 Will Benefit:
The training is aimed at existing users of Excel who need to learn how to create visually impactful Excel reports.
For more information, please visit : http://bit.ly/2tY45MC
Email: support-AT-atozcompliance.com
Toll Free: +1- 844-414-1400
Tel: +1-516-900-5509
Speakers Profile:
Mike Thomas
Mike Thomas has worked in the IT training business since 1989. His expertise and experience covers creating and delivering training courses, writing training materials and recording and editing video-based tutorials.
He is a subject matter expert in a range of Microsoft technologies and has also worked extensively with Mac OSX and Mac-related software since 2006, however, his passion is for all-things-Excel.
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 organizations across a diverse range of sectors.
In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.