This course introduces training using Pivot Tables and Pivot Charts in the Microsoft Excel software application.Upon completion of this training, the learner will be able to:
1. Construct a pivot Table Using a set of raw data.
2. Customize a pivot table.
3. Create calculated fields and items.
4. Insert Slicers into a pivot table.
5. Add settings to slicers.
6. Insert a timeline into a pivot table.
7. Add settings to a timeline.
8. Using recommended options when creating a pivot table.
9. Constructing Pivot Table Charts.
10. Customizing Pivot Table Charts.
11. Moving Pivot Table Charts.
12. Using Pivot Chart Tools.
This course is designed to be taught virtually using the virtual learning portal. The training material can be used as a guide. The lectures are presented as a step-by-step guide for the material. For the virtual learning, the learning can be the most effective if the spreadsheets are downloaded from the portal and open during the lectures to understand the concept being taught.
Learn the ins and outs of statistical analysis with Excel 2013
4.7
★★★★★ 4.7/5
1,298 students
