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. Prerequisites You should be comfortable with the Windows environment.
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description
ONLINE WEBINAR
At Course Completion
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.
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
Event Information
When: Tuesday 7th July 2020
Where: Online
Time: 9am - 12pm
Fee: $300+GST
Click here to learn about how Auldhouse can deliver this workshop to you in the comfort of your own home or workplace.
Presented By
