In-House Computer Training Available!
Have a large group that needs Excel training? We can bring this course to you!
For more information, call Wendy Allard at 848-932-7651 or send an email to firstname.lastname@example.org.
We also Offer Other Excel Classes!
Please visit our Computer Classes page for all upcoming course offerings.
This workshop teaches participants the powerful features of Microsoft Pivot tables. Pivot tables allow you to sort, filter, group, count, summate, and format data easily and efficiently.
Attendees will learn how to:
- Use one or more tables
- Drill down
- Refresh Pivot data
- Sort data
- Grouping and filter data
- Add calculated fields and items
- Use slicers
- Place subtotals and grand totals
- Apply layouts and styles
Students will work heavily on hands-on activities with an instructor to explore the variety of features within Pivot Tables and tackle different scenarios for when to use them.
Our pivot table training builds off of topics contained in our Excel Level 1, 2, 3, and 4 courses. We highly recommend that students complete prior Levels of Excel to receive a general overview before delving deep into pivot tables.
Computers will be provided for hands-on learning.
Note: Most of the skills taught in this class are applicable to 2010, 2013 and 2016 versions of Excel. Windows operating system is used for instruction in all Microsoft Office workshops.
Prerequisite: Microsoft Office Excel Level 4 training required