Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for intermediate learners who have a basic level of familiarity with writing Microsoft Excel formulas, but no prior knowledge of Pivot Tables. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 12 lessons, 3 exercises and 1 Exam. It covers the following topics:
- Preparing your data for pivot Tables
- Formatting pivot tables
- Changing pivot table output values
- Grouping date columns
- Updating pivot tables with new data
- Pivot table subtotals
- Sorting pivot table data
- Apply filters to pivot tables
- Build charts from a pivot table
- Updating formulas with new data
- Pivot table data in formulas
Key Outcomes
Once you have completed this course you will know how to create Pivot Tables for any dataset. You will know how to format your Pivot Table results, refresh Pivot Tables with new data, sort and filter these results and even create charts from your Pivot Table results.