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.

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.

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