View classes (on this page)

Learn to use Microsoft Excel with our Microsoft Office training courses in Sydney.

Microsoft Excel is an industry-standard spreadsheet. 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 or online, then this course is for you.

Skilled users of  Microsoft Excel are sought after in the workplace. Improved data management in your small business will give you a leading edge to make more effective data-driven decisions. Using Microsoft Excel the user can identify trends by assembling data from various sources. Effective use of Microsoft Excel can streamline tiresome tasks. Effective users of Microsoft Excel develop strong analytical thinking skills. 

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. This 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. Upon completion of the Level 1 course, students can progress to our Microsoft Excel Level 2 course.

Ideal for

This course is designed for beginners, no prior knowledge of Microsoft Excel is required however a basic understanding of computers is assumed. Students should be familiar with the basic functions of a computer operating system including using a mouse and keyboard, copying and pasting, creating folders, opening files, saving files and know how to navigate a web browser.

This course is for anyone looking to do add Microsoft Excel to their toolkit. You may consider enrolling if you want to learn how to use excel for personal financing, your small business, or to add excel to your resume. This beginners Excel course is designed for:

  • Those looking to increase their employability when applying to jobs.
  • Anyone looking to gain valuable insights into their personal or work-related data.
  • Those looking to improve efficiency in their workflow.
  • Anyone who has used Excel before but needs a refresher of the basics.

Course Outcomes

This is a beginner’s course and aims to give the new workbook user a thorough grounding in the basics of creating and working with workbooks using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed workbooks employing sound design and documentation principles. By the end of this course, you should be able to:

  • Navigate your way around Microsoft Excel
  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data within workbooks and worksheets
  • Understand the different types of Excel data in a worksheet
  • Understand and work with ranges in a worksheet
  • Copy and paste data
  • Understand, create and work with everyday formulas and functions
  • Understand and use formula cell referencing
  • Use font formatting techniques
  • Align the contents of cells in several different ways
  • Format rows and columns in a worksheet
  • Manage data in a list using sort and filter techniques
  • Understand and use the number formatting features
  • Print workbook data
  • Create effective charts
  • Understand points to consider to avoid problems in your worksheets
  • Successfully create graphs & charts

Course Content

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 easily locate Excel workbooks
  • 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 effect 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 pre-defined 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 filter 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 upon your data
  • Understand Excel charts and the choosing the right chart for your data
  • Create, move and resize your chart
  • Edit your chart
  • Print your chart

Help and Hints

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

Additional Information

  • Comprehensive notes are provided for the course are provided in PDF format. Hard copies of the notes are available for a $25 fee.
  • This class is taught in a Windows and Macintosh environment. We have available 8 Windows and 6 Macintosh computers We do not reserve computers for students so arrive slightly early if using a certain type of machine is important to you.

This course has no current classes. Please join our waitlist and we will notify you when we have places available. Join waitlist for Microsoft Excel Course: Level 1

This course has no current classes. Please join our waitlist and we will notify you when we have places available. Join waitlist for Microsoft Excel Course: Level 1

Great reasons to enrol in a short course with us

Small classes

A personal approach means quality learning, so you can enjoy plenty of interaction with your instructor and the chance to ask questions.

Short & sweet

Our short courses & workshops get straight to the point, providing the skills you need with minimal commitment of your precious time.

Facilities & equipment

Our range of venues suit every type of course, are easy to get to, and have the equipment and tech needed to support your learning.

Easy, secure enrolment

Enrol online 24/7 with a safe, convenient 3-step process, and you can change your mind up to 7 days before class starts.

Quality instructors

Our educators bring first-hand experience and knowledge, with up-to-the-minute practices from diverse industries.

For business, or pleasure

Our courses help you rapidly increase your skills and knowledge, for professional development or personal interest.

4.7 starsaverage rating on Google

1,400+courses to choose from

99%customer support rating

Course testimonials:

  • said: A good refreshment and update since i last learned Excel about 20 years ago.

  • said: Olga was an amazing tutor, I learnt a lot and throughly enjoyed this one day course :)

  • said: It was a good experience. The tutor was mindful of each student's level of understanding. She was patient and knowledgeable. Small class size - yeh !!!

  • said: 4 Stars!

  • said: I found the course very informative and Liz was an excellent tutor. Thank you.