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.
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.
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