Improve your work skills by learning to use Microsoft Excel with our practical online training course. Designed for complete beginners, this course introduces you to the fundamentals of spreadsheets, formulas and data analysis so you can work more efficiently and confidently.
You’ll learn how to build accurate formulas, apply essential functions, format worksheets professionally and create charts to present data clearly. Whether you use Excel for work or personal projects, these foundational skills will help you organise information, streamline tasks and gain insights from your data.
This entry-level course is ideal for those wanting to boost their employability or prepare for further Excel study, such as progressing to an intermediate-level course.
Learning Outcomes
- Create accurate formulas using BODMAS and cell references (relative, absolute and mixed).
- Use core functions such as SUM, AVERAGE, COUNT, SUMIF and COUNTIF to analyse data.
- Format, sort and visualise data with professional layouts, filters, charts and print setup tools.
Course Content
- Basic formulas and order of operations (BODMAS)
- Core functions and absolute cell references ($A$1)
- Copy and Paste Special techniques
- Formatting, merging cells and number formats
- Sorting, filtering, freeze panes and print setup
- Charts and Sparklines
Online Delivery
This course is delivered online via Zoom with live instruction and interactive learning. You will receive a Zoom link and instructions prior to the session.
Schedule & Pricing
- 9:30am – 3:30pm (one-day workshop)
- Delivered online via Zoom
- Please check the website for upcoming dates and current pricing
Details
You will learn
- Build formulas using BODMAS and correct cell references
- Apply essential Excel functions like SUM, AVERAGE and COUNTIF
- Create charts and format worksheets professionally
You will get
- Live online training via Zoom
- Step-by-step guidance from an experienced tutor
- Practical exercises to build real-world Excel skills
Appropriate for
Beginners with no prior knowledge of Microsoft Excel who want to upskill for work or personal use (basic computer skills required).
Preparation
What to bring
- Laptop or computer with Microsoft Office 365 or Office 2016+
- Stable internet connection for Zoom access
- Optional second monitor and HDMI cable for dual-screen setup
What to wear
Your Teacher
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 for Beginners
Coming Soon: More classes in the works!
Join the waitlist
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