Excel Pivot Table
This course focuses on developing skills and knowledge to manipulate large datasets. Using techniques including sort, filter, group and outline and subtotals, you will learn how to quickly summarise large data lists and find important information. You will also learn how to create Pivot Tables and Pivot Charts in Excel to effectively analyse and visualize data and make informed decisions.
Snapshot
Duration: 1 day
Version: 2010, 2013, 2016
Target Audience: Experienced users of Excel who work with large data lists and databases.
Prerequisites: Successful completion of a MCI Solutions Access Intermediate course or equivalent.
Learning outcomes
At the end of this program you will be able to:
- Use tools for sorting and filtering data lists
- Use subtotals
- Group data lists and create outlines for quick summary views
- Create and modify Pivot Tables from large data lists and databases
- Create and modify Pivot Charts to visualize large data lists and databases
Need a scalable, cost-effective solution to team training?
Try our Live Virtual Class Subscription. Access over 60 different training modules from just $10 per seat! Try it free for one month for you and one employee.