This workshop is suitable for those who have a good understanding of the fundamentals of Excel and want to do more with the data they use.

Learning Outcomes:

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

1. Name cells and ranges
2. Understand how to apply Absolute References to formulas
3. Create and use IF statements
4. Apply Filtering and Sorting to data
5. Use the Filter Function
6. Apply Text functions
7. Create formulas across worksheets
8. Create Tables to apply more analysis to your data
9. Use Conditional Formatting to review patterns and trends
10. Freeze rows to keep them in view when scrolling down a worksheet.

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 time saving 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.