Create clarity in your spreadsheets by manipulating your data.  This course will show you how to use Excel tools to visualise and summarise your data so that you can quickly see concise information, trends and patterns.
► Duration: 90 Minutes
► Delivery:  Training Room, Business South (In Person)
This workshop is suitable for anyone who wants to find specific values and information in their data set or identify trends and series from a range of data.

Learning Outcomes:

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

1. Format your data range as a Table
2. Use Conditional Formatting to check for specific information; and to spot trends and series
3. Filter and sort your data
4. Use the filter function for more advanced filters
5. Use the XLookup function to find and retrieve values from your data
6. Create subtotals from large data

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.