Microsoft Excel Pivot Table Training

OVERVIEW

Pivot 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: [email protected]

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

Others Details

Microsoft Excel Pivot Table training that focuses on efficiently creating pivot tables for building reports and summaries.