OVERVIEWPivot
Tables are one of the most powerful tools in Excel’s data analysis and Business
Intelligence (BI) armory. Mike discusses
how to quickly and easily build the reports, dashboards and charts that help
you to summarize, analyze, interpret and understand your data.
The
webinar provides a clear and deep understanding about:
·
Creating a
simple Pivot Table with 6 clicks
·
Using Filters and Slicers to limit what is shown in a Pivot Table
report
·
Best practices
for updating a Pivot Table when the source data changes
LEARNING OBJECTIVES
Use
Pivot Tables to turn raw data into meaningful and insightful reports
Structure
your raw data in the right way
Design
and format your Pivot Table reports so that they are easy to read and
understand
Summarise
your data in different ways including totals, counts and percentages
Use
Pivot Tables to create monthly summary reports
Convert
a Pivot Table into a visualisation
WHO WILL BENEFIT
You
should attend this training if you need to use Excel to quickly build reports
and summaries or if you simply want to learn how to create Pivot Tables to
improve your knowledge of Excel.
You
don't have to be proficient in the use of Excel to attend. If you can create
basic worksheets and can copy and paste and apply basic formatting to cells,
you’ll be able to follow along.
Although
the training will be delivered using Excel 2016 for Windows, most of the
functionality demonstrated is available in earlier versions of Excel (2007,
2010, 2013)
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.
For more detail please click on
this below link:
https://goo.gl/xZPVoK
Email: support@trainingdoyens.com
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
Loading Purplepass...
