Improve your digital proficiency with this online Microsoft Excel course designed for beginners. Whether you're starting from scratch or enhancing your foundational knowledge, this course will teach you how to navigate spreadsheets, create formulas, format data, and build clear, professional charts. Excel's powerful features can help streamline tasks, analyze data, and improve work accuracy—skills highly valued both in professional and personal tasks.
Join this comprehensive online learning experience with live instruction delivered through Zoom. With hands-on guidance, you'll confidently begin your journey into data management and organisation using one of the world’s most widely used tools.
Course Outline
- Build and apply formulas using BODMAS
- Use functions like SUM, AVERAGE, COUNT, SUMIF, and COUNTIF
- Learn absolute, relative, and mixed references ($A$1)
- Use Paste Special functions (values, formats, transpose, etc.)
- Format worksheets: merge cells, apply number formats, use basic sorting and filters
- Prepare spreadsheets for printing and use freeze panes
- Generate visual insights with Charts and Sparklines
Schedule & Pricing
- Online via Zoom: Feb 2–3, 2026, 9:30 AM – 12:45 PM | $399
- In-person: Feb 20, 2026, 9:30 AM – 3:30 PM at 2A Gordon St, Rozelle | $420
Course Requirements
- Microsoft Office 365 or Office 2016 (or newer)
- Your own computer capable of running Microsoft Excel
- HDMI cable and second monitor (recommended but optional)
- Note: Tutor instructs using Windows; Mac users are welcome with some variation in shortcuts
You will learn
- Build accurate formulas using BODMAS and core functions
- Format and manage Excel data professionally
- Create charts and print-ready workbooks
You will get
- Live expert instruction via Zoom
- Hands-on Excel practice in real-time
- Confidence using foundational Excel tools
Appropriate for
Beginners with basic computer literacy who want to gain foundational Microsoft Excel skills for personal or professional use.
What to bring
- Laptop with Microsoft Excel installed
- HDMI cable and secondary monitor (optional)
- Basic computer literacy
What to wear
Sydney Community College
Sydney 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 for Beginners: Fundamentals & Functions
Be the first to know when this class has new dates! Add your email to the waitlist.