By the end of the course, you will be introduced to the benefits of Pivot tables/reports, update your Pivot table and manipulate only the data you are interested in and make it easier to read. Delegates must be experienced in using Windows and a mouse and at least one other Windows package (for example Word or Excel).
What you will learn
- Manipulate your pivot table, such as, rearranging the layout, adding and removing fields
- Group data manually
- Display subtotals
- Change the look of your pivot table
- Show numerical information so it appears as a percentage of the total
- Use the GETPIVOTDATA function to extract data from a pivot table