Course Overview
Take your Microsoft Excel skills to the next level and learn how to work more efficiently with business data, reporting and automation in this practical Excel masterclass. Designed for people who already understand the fundamentals of Excel, this hands-on course focuses on advanced Excel skills that can make a real difference in today’s workplace.
You will learn how to use powerful Excel functions including SUMIF, COUNTIF, IF, IFS, VLOOKUP and XLOOKUP to analyse information, retrieve data and create smarter spreadsheets. You will also explore practical techniques for cleaning and preparing data, improving data entry and reducing errors.
The course introduces Excel automation using macros, helping you discover how repetitive tasks can be automated to save time and improve productivity. You will learn how to record macros, assign them to buttons and use the Personal Macro Workbook to make frequently used automations available across multiple workbooks.
In today’s data-driven workplace, Excel users are increasingly expected to do more than enter information into spreadsheets. This Microsoft Excel training course will help you build confidence working with business data, automate routine processes and create more accurate and reliable spreadsheets with less manual effort.
Ideal for office workers, administrators, managers, project staff, small business owners and professionals who regularly work with spreadsheets, this course focuses on practical Excel techniques that can be applied immediately in the workplace.
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:
- Use workplace Excel functions including SUMIF, COUNTIF, IF, IFS, VLOOKUP and XLOOKUP
- Analyse data more effectively and retrieve information from multiple sources
- Apply logical functions to automate calculations and decision-making
- Clean and prepare data for reporting
- Use practical text functions including CONCAT, TEXTJOIN, LEFT, RIGHT, PROPER and UPPER
- Set up Data Validation
- Create drop-down lists to improve consistency and simplify data entry
- Control and validate user input to reduce errors and improve data quality
- Record macros to automate repetitive Excel tasks and save time
- Assign macros to worksheet buttons and toolbar buttons for quick access
- Use the Personal Macro Workbook to make frequently used automations available across multiple workbooks
Course outcome
By the end of this course, participants will be able to work more confidently with advanced Excel functions and workplace automation tools. You will understand how to clean, prepare and analyse data more efficiently and create smarter spreadsheets that reduce manual effort and improve accuracy.
You will also develop practical skills for automating routine Excel tasks and streamlining reporting processes, helping you save time and improve productivity when working with business data.
The techniques covered in this Excel masterclass can be applied immediately in the workplace, helping you work more efficiently with spreadsheets, reporting and everyday data management.
What you need to know
Entry requirements
This course is designed for participants who already understand the fundamentals of Microsoft Excel and want to develop more advanced Excel skills for business, reporting, data analysis and workplace productivity.
Participants should have basic experience using a computer and be comfortable opening, editing and saving files. You should know how to create folders and organise documents, download and upload files, and locate files on your 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.
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.
The course may be delivered face to face on campus in Chatswood or as a live instructor-led online session.