In this course, students will use Microsoft Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is intended for students who wish to gain the foundational understanding of Microsoft Excel.
No events to show
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
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.
Who Should Attend
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)