This course is for anyone who is experienced in using Windows and a mouse and at least one other Windows package (for example Word or Excel).
Aims
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.
What you will learn
In particular you will be able to:
- 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.
Timetable
Session One
Getting Started; What is a Pivot Table; Setting up your data; Creating a PivotTable; Formatting a PivotTable.
Session Two
Manipulating a PivotTable; Modifying the Layout; Grouping Data; Showing & Hiding Totals.
Session Three
Customising Values & Exporting; Editing your data values; Adding more data values; Creating calculated fields.
Session Four
PivotCharts; Creating a PivotChart; Modifying a PivotChart.
The ‘Small Print’
The course will run from 10am to 4:45pm (light cold buffet 1pm to 1:45pm). Please be careful to arrive by 9.45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.
