Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Microsoft Excel - The Essentials

Code:
EXLL1
Days:
1 Day
Price:
$350 excl GST
Code:
EXLL1
Days:
1 Day
Price:
$350 excl GST
CPD Eligible
6 cpd hour(s)
Overview:
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.
Download Course Outline
Course Outline (PDF)

Objectives:

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.

Target Audience:

Anyone new to Microsoft Excel or those with limited experience.

Prerequisites:

To ensure success on this course, you should be familiar with using personal computers and should have experience using a keyboard and mouse.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class