What you'll learn
Improve your work skills by learning to use Microsoft Excel with our online 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 online 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 online 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 online 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 online Microsoft Excel course for?
This course is designed for students looking to up-skill 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.
Online Course
This course is now delivered online via Zoom, offering the same high-quality instruction and interactive learning experience as our in-person classes. A Zoom link and instructions will be provided before the course begins.
Course Materials
What You’ll Need for Your Online Class:
- A subscription or free trial of Microsoft Excel.
- Your own laptop or computer capable of running Microsoft Excel.
- HDMI cable and an additional screen for a dual monitor setup (recommended).
Additional Information
This online class is suitable for both Windows and macOS users, as Microsoft Excel functions similarly on both platforms. Make sure your computer meets the system requirements for Microsoft Excel to ensure a smooth experience.
Course testimonials
-
Paula said: Very well designed and delivered course that met all my requirements and expectations! Couldn't wait to get home and try out my new knowledge. Loved the tutor, Denise. She was one of the best instructors I have encountered. I would not hesitate to recommend this course. Looking forward eagerly to Excel 2.
-
Andrew said: I found the course very informative with an excellent tutor. Thank you.
-
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.
-
Bogda said: Individual support throughout the day. The presenter provides clear instructions. The opportunity to practice with individual support with a small group of participants.
-
Adrian said: It was an excellent course overall. Bit rushed in the afternoon. The classroom was freezing cold all day though, could do with a bit of heating on in the winter :)
Course tutors
John Scott
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.
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
Classes Online Courses
<p>Improve your work skills by learning to use Microsoft Excel with our online <a href="https://www.sydneycommunitycollege.edu.au/courses/personal-career-development/microsoft">Microsoft Office
...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
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