Pivot Tablets Essentials for Data Analytics in Excel virtual, sheridan

OVERVIEW
Pivot Tables are considered by many to be the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate, and chart data in minutes.

A Pivot Table displays a summary of a selected data set in a condensed format of rows, columns, data fields, and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real time. This table empowers the user to view and analyze large amounts of information.

WHY SHOULD YOU ATTEND?
A Pivot Table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Working with pivot tables is one of the most useful data analysis capabilities in Excel.
Upon completion of this program, participants should be able to:

Work smarter, faster, and more effectively
Boost profit, efficiency, and productivity
Strengthen your resume and higher pay options
Achieve more in less time with higher quality results.
Improve job satisfaction, team performance, and professionalism
Gain a strong competitive advantage at the peer and business level

LEARNING OBJECTIVES
To gain a practical “hands-on” understanding of how to efficiently create, manage, and display PivotTables, charts and timelines in Excel for maximum effectiveness.

AREAS COVERED
Data table design essentials
Understand PivotTables
Create your own PivotTable
Define the PivotTable structure
Switch and Delete PivotTable fields
PivotTable Tools – analyze and design
Summary value calculations and format
Column and Row filters

About speaker
Ray’s professional and relaxed style reflects his thorough understanding of advanced learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.

With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.

Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.

Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.