Build essential spreadsheet skills with this practical Excel for Beginners course delivered live online. Perfect for those new to Microsoft Excel or looking to strengthen their foundations, this course will teach you how to confidently navigate spreadsheets, create formulas, apply formatting and present data clearly using charts.
You’ll learn how to use core Excel functions, manage and organise data, and prepare professional worksheets for printing and sharing. Whether you’re using Excel for work or personal projects, these fundamental skills will help you save time, improve accuracy and boost your productivity.
This entry-level course is ideal for anyone wanting to increase their value in the job market and build a strong base before progressing to intermediate Excel training.
Course Content
- Basic formulas using BODMAS and core functions (SUM, AVERAGE, COUNT, SUMIF, COUNTIF)
- Absolute cell referencing, copy and Paste Special tools
- Formatting, sorting and filtering data effectively
- Print setup, freeze panes and managing large spreadsheets
- Creating charts and Sparklines for data visualisation
Online Delivery
This course is delivered online via Zoom, offering interactive, real-time instruction. You will receive a Zoom link and joining instructions prior to class.
Course Materials & Requirements
- Microsoft Office 365 or Office 2016 (or later)
- Laptop or computer capable of running Microsoft Excel
- Dual monitor setup recommended (HDMI cable and additional screen)
- Suitable for both Windows and macOS users (some shortcuts may vary)
Schedule & Pricing
- 9:30am – 3:30pm (one-day workshop)
- Class size capped at 15 students
- Course fee from $399
Details
You will learn
- Create accurate formulas using BODMAS and core Excel functions
- Apply absolute and relative cell references correctly
- Format, sort and visualise data using charts and filters
You will get
- Live online training with an experienced tutor
- Practical exercises and real-world examples
- Skills to prepare professional, print-ready worksheets
Appropriate for
Beginners with no prior Excel experience who want to build foundational spreadsheet skills; basic computer knowledge assumed.
Preparation
What to bring
- Laptop or computer with Microsoft Excel installed
- Microsoft Office 365 or Office 2016+
- Second monitor setup recommended for easier learning
What to wear
Your Teacher
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
Coming Soon: More classes in the works!
Join the waitlistBe the first to know when this class has new dates! Add your email to the waitlist.