This workshop is suitable for anyone who is using a spreadsheet in their organisation and would like to be more efficient.

Learning Outcomes:

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

1. Enter data into multiple cells at once.
2. Set up data validation to restrict what can be entered into a cell, therefore improving accuracy of data entry.
3. Use 3D references to add data from multiple sheets.

By the end of this session you will have a knowledge of:

1. Using consolidate to summaries data from multiple sheets.
2. Using Power Query to combine data from different sources.
3. How to create a simple Pivot Table.

Please register before 28 April 2026

Presenter:  Grant Baldwin
Grant set up Custom Spreadsheet Solutions to build customised spreadsheets for organisations and provide coaching in spreadsheet use. His clients are able to work more efficiently and spend time on the parts of their jobs they enjoy instead of dealing with repetitive tasks or manual calculations.

Grant has 20 years’ experience working with spreadsheets. He has used them to do everything from presenting official statistics, to calculating investment returns, determining medication dosing, recording school competition results, and solving penguin puzzles.

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 (OCT). *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.  Please note that as part of our reporting requirements, your organisation name, the course name, and the course cost will be shared with OCT.  Funding support applies to both the OCT funding boundary and courtesy of Business South, the wider Otago and Southland NFP organisations. Terms and conditions apply.

Feedback from previous attendees:
“Really enjoyed the session today, Grant”
“Thanks so much for your help yesterday, I learnt heaps”