Download our guide to end user applications

Microsoft Excel - Beginner

Length 1 day
Price NZD 420 exc GST

Course overview

View dates &
book now

Why study this course

Unlock the power of Excel spreadsheets to effectively analyse, share, and manage your day-to-day data with this comprehensive one-day Excel for beginners course. Gain practical skills and knowledge that can be applied in any professional setting to enhance your productivity and decision-making abilities.

The course covers the important basics from creating and formatting spreadsheets and charts to sorting and filtering data.

After completing this course, you may be interested in our Intermediate and Advanced courses.

Note: Excel 2016, Excel 2019, Excel 2021, and Excel 365 are all desktop application versions of Microsoft Excel. Excel 2016, Excel 2019, and Excel 2021 are the perpetual, bought-outright, stand-alone versions of the software; Excel 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.

Aligns to certifications

Request Course Information

What you’ll learn

At the completion of this course, you should be able to:

Create, navigate and manage workbooks and worksheets
Work with ranges, formulas and basic functions
Apply formatting to fonts, rows and columns for clarity
Use worksheet tools such as sorting, page setup and printing
Create effective charts to visually present data

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is designed for users new to Microsoft Excel and spreadsheeting as a concept. You'll learn all key basic Excel skills and be ready to put them into practice in the workplace.

Course subjects

Getting to Know Excel

What are Spreadsheets, Worksheets, and Workbooks?
Columns, Rows, Cells, and Ranges
The Excel Interface and Ribbon
Keyboard Navigation Options
Creating Workbooks and File Formats

Using Formulas and Functions

About Functions and AutoComplete
Using the Insert Function Dialog Box
AutoSum and Status Bar Calculations
Automatic Workbook Calculations
Mathematical Operators and Order of Operations

Working with Data

Selecting Cells and Data Entry
Cut, Copy, and Paste Operations
Paste Options and Live Preview
AutoFill and FlashFill Features
Undo and Redo Functions

Working with Rows and Columns

Inserting and Deleting Rows/Columns
Clearing Data from Cells
Changing Column Width and Row Height
Hide and Unhide Functions

Managing Worksheet Structure

Sorting and Filtering Data
Sorting vs Filtering Concepts
Sorting Data in Ascending/Descending Order
Enabling and Using Filters
Text Filters and Clearing Filters
Data Organisation Best Practices

Formatting Text and Cells

Fonts and Format Cells Dialog Box
Format Painter and Mini Toolbar
Applying Borders and Fills
Number Formats and Custom Formatting
Aligning Cell Content and Text Wrapping

Printing Workbook Contents

Define Page Layout and Print Options
Page Setup and Print Preview
Headers, Footers, and Margins
Page Orientation and Scaling Options
Page Breaks and Print Titles

Managing Large Workbooks

Format, Rename, and Colour Worksheet Tabs
Grouped Worksheets Operations
Repositioning, Inserting, or Deleting Worksheets
Hiding/Unhiding Worksheets
Worksheet References in Formulas

Customising Excel Environment

Customise General, Language, and Formula Options
Version Control and Save Options
Customise Ribbon and Quick Access Toolbar
Add-ins and Developer Tab
Advanced and Trust Centre Options

Search and Replace Data

Cell Names and Range Names
Find, Replace, and Go To Functions
Spell Check and Spelling Dialog Box
Data Validation and Error Checking
Accessibility and Help Options

Prerequisites

No previous experience with Microsoft Excel is necessary. This course is suitable for people who have never worked with Excel or have only had very limited exposure to it.

This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding printing and using a web browser is an asset, but not required.

M365 Adoption and Training Plans

Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.

Learn more

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.