Crunching the big data.  This course will show you how you can easily and efficiently analyse, visualize, and make sense of complex data sets with Pivot tables. With Pivot Tables you can summarise, group , filter and analyse your large data set to gain insights without complex formulas.
► Duration: 2 hours
► Delivery:  Training Room, Business South (In Person)

This workshop is suitable for anyone who uses large and complex data sets and needs to easily organise this data into more palatable information.
Learning Outcomes:

By the end of this session you will be able to:

1. Prepare your data
2. Create a Pivot table
3. Group Data
4. Summarise Data
5. Use Filters and Slicers
6. Use Timelines
7. Complete calculations in Pivot Tables
8. Create a Pivot Chart

 Kevin has 25 years’ experience in delivering Microsoft Office training. He has worked with individuals, small and large businesses, local authorities and  government departments helping staff to improve their engagement with the software they use.

Excel is a powerful tool to record, analyse and manipulate data. With Simply Training.co Kevin has successfully shown his clients how to use this tool to more effectively manage their data and take back time by using the many timesaving features available in Excel.


Not-for-Profit organisations, clubs and charities that are eligible* will receive a 50% subsidy.
Subsidised workshops are due to the generous support of Otago Community Trust.
*Eligibility criteria: Not-for-Profit organisations, charities, and incorporated societies are to be a registered organisation with a NZBN #, Society # or Charities #.
Please provide us with the NFP name when you register. Terms and conditions apply.