This programme will be delivered over two days, each day with a two-hour session that will teach you some spreadsheet essentials. We will cover best practices when starting a spreadsheet, entering data more efficiently, and skills that will allow you to make the most of a spreadsheet’s features.

Facilitated via Zoom by Grant Baldwin - with our Adult Community Education (ACE) Team providing onsite assistance at Far North REAP.

What these sessions will cover:

Session 1

•           Introduction to spreadsheets.

•           Formatting cells. Conditional Formatting.

•           Creating a table.

•           Introduction to formula.

•           Sorting and filtering information.

•           Fill and Flash Fill.

Session 2

•           Data validation – Making your data entry more accurate.

•           Apply conditional formatting to cells.

•           Moving around the spreadsheet,

•           An introduction to functions.

•           Pivot Tables – how to quickly summarise and analyse your data.

•           Shortcut keys.

Suitable for beginners or anyone wanting a refresher on utilising Microsoft Excel.