Course Content:

Getting started 

Spreadsheet terminology 
The Excel environment 
Navigating a worksheet 
Using a template

Entering and editing data 

Entering and editing text and values 
Entering and editing formulas 
Saving and updating workbooks 

Modifying a worksheet 

Moving and copying data 
Moving, copying, and viewing formulas 
Absolute and relative references 
Inserting and deleting ranges, rows, and columns 

Functions

Entering functions 
AutoSum 
Other common functions

After completing this course, students will be able to:

Recognise spreadsheet terminology; start Microsoft Excel and identify the components of the Excel interface; create a blank workbook; navigate worksheets; and open a downloaded template.

Enter and edit text and values; use AutoFill; enter formulas and examine the order of operations; save and update a

workbook; and save a workbook in different file formats.

Move and copy data; use the Office Clipboard; move and copy formulas; use AutoFill to copy formulas; use Paste Link; view formulas; work with relative and absolute references; and insert and delete ranges, rows, and columns.

Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.

Prerequisites 

You should be comfortable with the Windows environment.

Bring your own device.

When:  Tuesday 1st October, 2019, 9am-12noon
Where:  Level 3, 15 Daly Street, Lower Hutt
Fee:  $300 +GST (those wanting to attend the 2nd workshop on the same day can attend courses for $450+GST)