End User Applications Category Banner Image

Microsoft Excel - The Essentials (EXLL1)

  • Length 1 day
  • Price  NZD 435 exc GST
Course overview
View dates &
book now

Why study this course

Learn the fundamentals of Microsoft Excel, Microsoft's powerful spreadsheeting application.

Request Course Information


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


Microsoft Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.


Who is the course for?

This course is intended for students who wish to gain a foundational understanding of Microsoft Excel. You'll use Excel to create spreadsheets and workbooks containing values and formulas that can be used to store, manipulate, and share data.


Course subjects

Getting started in Microsoft Excel

  • 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


Prerequisites

None


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.