Advance your Microsoft Excel skills online and learn powerful data analysis tools with our Excel Intermediate course! This hands-on training is designed to take your foundational knowledge to the next level, introducing key tools such as PivotTables, VLOOKUP, conditional formatting, and data validation. You'll learn how to organise, analyse, and present data effectively—an essential skill for professionals seeking to boost productivity and mastery of Excel in the workplace.
Through interactive online learning, you'll discover how to automate tasks, work with complex formulas, and become proficient in using Excel for a wide range of business applications. Whether you're preparing financial reports, managing inventory, or analysing customer data, this course equips you with techniques to improve your workflow using advanced Excel features.
Course Outline
- Logical functions (IF, AND, OR)
- Lookup functions (XLOOKUP, VLOOKUP)
- Date and text functions
- Mixed referencing and Flash Fill
- Conditional formatting and data validation
- Data tables, sorting, and filters
- Formula auditing and duplicate data management
- Essential Excel shortcuts
Schedule & Pricing
- Option 1: Online via Zoom — 18–19 Feb 2026, 9:30am–12:45pm
- Option 2: In-person at Rozelle — 13 Mar 2026, 9:30am–3:30pm
- Price: $399
Course Materials
- Microsoft Office 365 or Office 2016+
- Computer or laptop capable of running Excel
- HDMI cable and dual monitor setup (recommended)
- Note: Taught on Windows; Mac users welcome with some variation in shortcuts/functions
You will learn
- Use advanced functions like IF, AND, OR, VLOOKUP, XLOOKUP
- Automate data entry and perform advanced filtering
- Apply conditional formatting and troubleshoot formulas
You will get
- Comprehensive digital course materials
- Expert-led interactive online sessions
- Practical skills for workplace Excel use
Appropriate for
This course is designed for students who have completed the Excel for Beginners course or have foundational Excel knowledge. Ideal for professionals aiming to upskill in data analysis and spreadsheet management.
What to bring
- Microsoft Office 365 or Office 2016+ installed
- A computer or laptop with Excel capabilities
- Dual screens or HDMI cable (recommended)
What to wear
Sydney Community College
38 reviewsSydney Community College is a registered charity with a voluntary Board of Directors.
The College has a mission to offer innovative continuing adult education and training programmes that support individual efforts and facilitate sustainable social change.
We do this by:
- Providing quality continuing adult education opportunities for people to build practical and theoretical skills and develop knowledge;
- Leveraging from and developing community capacity and inclusivity;
- Developing innovative affordable and accessible skills training programmes;
- Partnering with like organisations to deliver learning opportunities for disadvantaged individuals and communities;
- Partnering with all levels of government to deliver education policy objectives.
Cancellations & Refunds
If the organiser cancels the class:
You are entitled to a full refund.
If you can't attend the class:
You’re welcome to send someone in your place.
OR
- A refund can be requested 10 days before class starts. An admin fee of AU$45.00 applies.
Terms & Conditions
At Sydney Community College, we know that plans can change unexpectedly. Whether it’s a shift in your schedule, a family emergency, or just a change of heart, we want to support you in the fairest way possible.
At the same time, we’re a not-for-profit organisation that commits resources to running each class—so last-minute cancellations can significantly impact our ability to offer quality, affordable programs.
That’s why we’ve created a simple, transparent policy that balances your need for flexibility with our need to plan and deliver courses sustainably. Our cancellation policy offers two clear options, depending on when you notify us:
Cancel More Than 10 Days Before the Course Starts – You can choose to receive a full refund, minus a $45 administration fee OR a non-refundable credit note valid for 12 months for the full value you paid for the course. This credit can be used towards any future course at the College.
Option 2: Cancel Within 10 Days of the Course Starting - You’ll receive a credit note valid for 12 months for 50% of the course fee you paid for the course. This credit can be used towards any future course at the College.
Please note that both refund and credit options are only available before the course begins. Once the course has started—or if you decide to withdraw after it has commenced—no refunds or credits can be issued. If you need to cancel your enrolment, just email us and we’ll take care of it based on the timelines above.
Have more questions about this class?
Tags:
Excel Intermediate: Data Analysis Tools
Be the first to know when this class has new dates! Add your email to the waitlist.
Your Next Adventure Starts Here
Join thousands of learners exploring new skills and passions. Whether online or in person, our classes are designed to inspire, connect, and bring joy to learning. Start your journey today!
Explore classes