Excel: The Essentials
13 Stanley Street, Sydenham, ChristchurchTicket Information
- Additional fees may apply
Restrictions
Website
Listed by
Objectives
This course is intended for students who wish to gain the foundational understanding of Microsoft Excel. You will use Microsoft Excel to create spreadsheets and workbooks containing values and formulas that can be used to store, manipulate, and share data.
Prerequisites
You should be comfortable with the windows environment.
What you’ll learn
After completing this course, students will be able to:
- Open Microsoft Excel and identify the components of the Excel interface; identify spreadsheet areas and terminology; create and save a workbook; navigate worksheets; and enter and edit text and values.
- Create simple mathematical formulas; move and copy formulas using AutoFill and use Paste Link; view formulas in a spreadsheet; work with relative and absolute references; and use the SUM function, AutoSum, and other common functions to perform calculations in a worksheet.
- Modify a worksheet by inserting and deleting ranges, rows, and columns; find and replace text and data; check spelling and use the other research and proofing tools.
- Format text, cells, rows, and columns; apply colour and borders; format numbers; apply conditional formats; use the Format Painter; and create and use templates.
- Preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.
- Manage worksheets by inserting, renaming, deleting, moving and copying sheets; navigate Excel views and set workbook properties.
Who should attend:
Anyone new to Microsoft Excel or those with limited experience.
Course outline
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
Price includes courseware and materials.
Training will be in one of our custom designed PC suites, so you do not need to bring anything.
Lunch and light refreshments are provided.
Please note that there is free parking in the surrounding streets, however we do not have client parking on site. Parking at The Colombo is not permitted. Please consider this when allowing for your arrival time.
Our training centre is fully wheelchair accessible.
Our Terms and Conditions can be found here: https://auldhouse.co.nz/terms-and-conditions
Log in / Sign up
Continuing confirms your acceptance of our terms of service.
Post a comment