Course Overview
Build practical Microsoft Excel skills and learn how to work smarter, faster and more confidently with spreadsheets in this hands-on Excel masterclass. Designed to focus on the Excel skills that deliver the greatest value in today’s workplace, this practical course will help you save time, reduce errors and improve productivity.
Whether you are creating reports, managing budgets, tracking information or analysing data, you will learn straightforward Excel techniques that can make everyday spreadsheet tasks easier and more efficient. The course focuses on practical skills rather than complex theory, helping you understand how to create and format spreadsheets, use formulas and functions, organise information and analyse data.
You will explore essential Microsoft Excel features including SUM, AVERAGE, MIN, MAX and COUNT, as well as AutoSum, AutoFill, Excel Tables, sorting, filtering, subtotals and an introduction to Pivot Tables. You will also learn useful keyboard and mouse shortcuts and discover how to prepare professional spreadsheets for printing and sharing.
This Microsoft Excel training course is ideal for office workers, administrators, small business owners, job seekers and anyone wanting to strengthen their digital and spreadsheet skills. Guided by an experienced Microsoft Certified Professional, you will develop practical Excel skills that can be applied immediately at work, during study, in business or for personal projects.
Macquarie Community College operates from a range of venues across Northern and Western Sydney, including Blacktown, Carlingford, Chatswood, Epping, Mt Druitt, Richmond, and Ryde. Enrol now!
What you will learn
Course outline
In this Excel masterclass you will learn how to:
- Create and work confidently with Excel workbooks and worksheets
- Enter, edit and format numbers, dates and text professionally
- Use keyboard and mouse shortcuts to work faster and more efficiently
- Apply practical formatting techniques to improve the appearance and readability of spreadsheets
- Create formulas to perform calculations
- Use essential Excel functions including SUM, AVERAGE, MIN, MAX and COUNT
- Use AutoSum and AutoFill to save time and reduce repetitive tasks
- Edit and troubleshoot formulas
- Understand the difference between relative and absolute cell references
- Use Insert Function to find and apply functions
- Organise and manage data using Excel Tables
- Keep important rows and columns visible using Freeze Panes
- Sort, filter and search data to quickly find information
- Summarise data using subtotals
- Understand how Pivot Tables can be used to create summary reports
- Prepare spreadsheets for printing
- Use Print Preview to check and refine worksheet layouts
- Add professional headers, footers and page numbering
- Adjust page orientation, scaling and sizing for better presentation
- Control printed output using page breaks and page setup options
Course outcome
By the end of this course, participants will be able to create and format professional Excel spreadsheets with greater confidence and use essential formulas and functions to perform calculations and analyse information.
You will be able to organise, sort, filter and manage data using practical Excel features, summarise information using tables, subtotals and Pivot Tables, and apply time-saving techniques and shortcuts to work more efficiently.
You will also understand how to prepare spreadsheets professionally for printing and sharing, helping you improve accuracy, reduce repetitive manual work and apply practical Excel skills immediately in the workplace, during study or in your own business.
What you need to know
Entry requirements
This course is suitable for participants who already have basic computer skills and want to develop practical Microsoft Excel skills for work, business, study or everyday use.
Participants should be comfortable opening, editing and saving files, creating folders and organising documents, downloading and uploading files, and locating files on their computer. Basic keyboard, mouse and internet browsing skills are also required.
Participants must have access to a computer with the Microsoft Office desktop applications installed and available.
What you need to provide
- Your own laptop
- Windows computer (please advise if you are a Mac user)
- Microsoft Excel desktop application installed
- Access to your Microsoft account
- Pen and notepad
Other information
This is a practical 3.25-hour hands-on Microsoft Excel masterclass.
Sample files will be provided to participants by email before the course.
No textbook is required. Comprehensive course notes are provided.