Microsoft Excel Course: Level 1

What you'll learn

Improve your work skills by learning to use Microsoft Excel with our Microsoft Office training courses in Sydney!

Microsoft Excel is an industry-standard spreadsheet software. It is part of the Microsoft Office Suite and is the most common programme used across a variety of commercial applications. If you would like to learn how to construct and manage data using Microsoft Excel in Sydney, then this course is for you.

This entry-level Microsoft Excel course in Sydney will increase your value in the job market and help you gain valuable insights into whatever data you choose to work with. Using Microsoft Excel, the user can identify trends by assembling data from various sources and can streamline tiresome tasks. Upon completion of the Level 1 course, students can progress to our Microsoft Excel Course: Level 2.

Learning outcomes

By the end of this Microsoft Excel course, you will have enhanced your career prospects by :

Open and navigate within workbooks and worksheets
Understand the different types of Excel data in a worksheet
Understand, create and work with everyday formulas and functions
Manage data in a list using sort and filter techniques
Understand and use the number formatting features

Course content

What will be covered in this Microsoft Excel course?

Getting Familiar with Excel

Understand how Excel works
Recognise and work with the Excel environment
Use Excel’s Ribbon to access commands
Use shortcut menus and the Quick Access toolbar to easily perform actions
Add command buttons to the Quick Access toolbar

Creating a New Workbook and Work with Existing Workbooks

Understand the structure of a workbook
Create a new workbook with text, numbers, dates and formulas
Edit data, view and understand the impact on formulas
Open existing Excel workbooks
Use Recent files and folders to locate Excel workbooks easily
Navigate in the workbook using different techniques
Run the Spell Checker

Edit, Select, Copy and Move in a Workbook

Learn different techniques to edit formulas
Use undo and redo
Examine the difference between delete and clear cells
Learn how to select ranges, including cells that are adjoining and non-adjoining
Copy and move cells using various methods
Understand the different effects that move or copy will have on formulas
Use the fill feature to perform quick copying

Formulas, Functions and Formula referencing

Understand and create formulas that add, subtract, divide and multiply
Use Excel’s predefined functions to add, average and determine the highest and lowest number
Create more complex formulas
Use and understand Absolute versus Relative cell referencing
Examine and understand the effect on formulas when formulas are copied
Explore common error messages in formulas

Present Your Excel Work Effectively

Use font formatting techniques such as bold, indent, colours and format painter
Use various cell alignment techniques to control where data aligns
Use various number formatting techniques such as $ and % to present numbers effectively
Insert and delete columns and rows
Control the size of columns and rows

Work with Lists

Reassemble list rows by sorting
Perform a multi-level list sort
Use filtering to view only list data that interests you
Use filtering techniques such as multiple filters and wildcards to refine your displayed list

Printing your work

Understand Excel’s print options
Print part or all of your workbook

Create Charts

Use charts to “tell the story” by creating dynamic chart visuals based on your data
Understand Excel charts and choose the right chart for your data
Create, move and resize your chart

Help and Hints

Use Excel’s inbuilt help
Hints on how to plan and write effective workbooks
Best practice for creating a workbook

Intended audience

Who is this Microsoft Excel course for?

This course is designed for students looking to upskill and is suitable for beginners with no prior knowledge of Microsoft Excel. However, a basic understanding of computers is assumed to ensure a smooth learning experience.

Course venue

Rozelle Campus

2A Gordon Street, Rozelle NSW 2039 (corner of Gordon St & Victoria Rd on the grounds of St. Joseph's Church)

Course materials

What to bring to class

A USB to save your work and handouts

Additional information

Please note the following:

This class is taught in a Windows and macOS environment. We have available 8 Windows and 6 Apple Mac computers. We do not reserve computers for students so arrive early if using a certain type of machine is important to you.

Course testimonials

Marielle said: Denise is a fantastic tutor; patient and engaging. She was able to break down complex information into digestible chunks and exercises.
Russell said: The material was well structured and clear. It was presented without stress and everyone's issues appeared to be addressed. I'm a total beginner so I found it practical.
Chloe said: I highly recommend Excel to anyone who wants to learn the basics or refresh their Excel skills. The tutor is patient and extremely experienced.
Mairead said: The tutor was great and really helpful. A great course that really developed my knowledge in Excel. Thank you Denise!
Sarah said: Tutor was patient and made sure everyone understood a topic before moving on

Course tutors

John Scott

John applies the latest advanced practices in the fields of business, leadership, organisational psychology, analytics, and engineering to educational delivery. He has been involved in management...

View John Scott's profile

Classes Online Courses

Microsoft Excel Course: Level 1

Fri 19 Jul 2024

1 session, 7 hours total

9:30am - 4:30pm (UTC+10:00)

2A Gordon St, Rozelle

John Scott

When	Time	Where	Session Notes
Fri 19 Jul 2024	9:30am - 4:30pm	A1-2: Computer Room - 2A Gordon St, Rozelle

If there isn't a class to suit you, please join our waitlist and we will notify you when we have places available. Join waitlist for Microsoft Excel Course: Level 1