Excel Course Sydney Masterclass
Modern Excel Essentials Learn the Essential Excel Skills You Need in Just Half a Day
Microsoft Excel Master Class – Learn the Essentials in Half a Day
Unlock the Power of Excel and Transform the Way You Work. Join us in Chatswood or live online for a high-impact Excel Masterclass designed for professionals, business owners, and anyone who wants to feel confident using Excel in the modern workplace.
This is not just another course, it’s a hands-on, expert-led workshop that delivers real-world Excel skills you’ll use every day. View our Level 2 masterclass.
Location
Chatswood or Virtual
Price: $350 inc GST
- $350 inc GST per delegate
Duration:
3.25 hours
Audience and Prerequisites
- Participants should be comfortable using and navigating Windows, and basic functions including basic formatting, saving and printing.
- Ideal for job seekers, people returning to work after a break or people who need to use Excel in their day to day work
Quick Glance
In just 3 hours, you’ll master:
- Setting up a spreadsheet using formatting and page setup options
- Everyday formulas that save time and reduce errors
- Sorting and filtering data like a pro
- Creating powerful Pivot Tables for instant insights
- Time-saving shortcuts that make Excel feel effortless
Excel Short Course
Our half-day Excel workshop is a fully packed masterclass, combining expert demonstrations with hands-on practice. You’ll learn the most commonly used Excel functions for day-to-day tasks in the modern workplace, including formulas, functions, and time-saving shortcuts, all guided by an expert trainer. Perfect for those looking to boost their efficiency and confidence in Excel, fast. We also have one on one training available.
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.
Explore our other Microsoft Training courses and one on one training
FAQS
What is the maximum class size?
Our classes are strictly limited to a maximum of 6 participants, unlike many other providers, we keep group sizes small to ensure each person receives personalised support and hands-on attention throughout the course.
Where is the Course held?
The course is held in a small, professional conference room equipped with full AV facilities, located on Raglan Street in Manly.
Do I need to Bring my own Laptop?
Yes, all delegates should bring their own laptop, you will also need to have Windows and basic Office apps installed including Excel, Word and Outlook
Will I receive a certificate after completing the Course?
Yes, we provide e-certificates for all participants who successfully complete the course
I'm looking for beginner Excel classes near Sydney, is this suitable?
Perfect for beginners and self taught learners, this practical half day course equips you with the essential Excel skills needed to get more from the software straight away.
Is the course hands on?
Yes, the course is instructor led with hands on exercises all the way through, you will be encouraged to ask questions and get involved!
Will there be any Course Materials?
Yes, course materials are provided electronically after the training. During the session, you’ll have access to hands-on exercises and interactive labs, which you’ll work through alongside your facilitator.
Who is the Facilitator?
Your Facilitator will be Anita Lund who is a seasoned Microsoft Certified Applications Specialist with over 25 years training experience. You can read her online Google Reviews here.
Onsite Training
Roving Trainers
Virtual Training
Training Roll-outs
We're Here To Help!
Call Us
02 9454 7702
Hours
M-F: 9am - 5pm
S-S: Closed