» Courses » Spreadsheets
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Do you use Excel for work or study? Looking for ways to do more with less? Want to tap into the full power of Excel‘s extensive functions and features? If so, this course is for you!
This advanced course explains and puts into practice the full suite of Excel tools to boost your productivity and analytical skills, while learning key theoretical principles to improve reliability and avoid mistakes. Each lesson explores the functions and other powerful features of the Excel application, and then shows how these are reliable solutions for important business tasks, so what has just been learnt can be applied immediately. You‘ll soon be doing things beyond what you ever imagined Excel could do for you, saving hours of time each month.
Let us show you how to take full advantage of Excel, the application you need the most. At the end of this course, you will feel confident to tackle even the most complex business problem, without needing to bring in a professional programmer. The included theory will ensure you‘ll be able to learn even more functions to impress your team and feel assertive in control of your work and business.
Classes are organised into 4 terms each year, with speciality workshops running throughout the year.
Explore our exciting range of courses below
5 records found
Spreadsheets - Mastering Excel
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Do you use Excel for work or study? Looking for ways to do more with less? Want to tap into the full power of Excel‘s extensive functions and features? If so, this course is for you!
This advanced course explains and puts into practice the full suite of Excel tools to boost your productivity and analytical skills, while learning key theoretical principles to improve reliability and avoid mistakes. Each lesson explores the functions and other powerful features of the Excel application, and then shows how these are reliable solutions for important business tasks, so what has just been learnt can be applied immediately. You‘ll soon be doing things beyond what you ever imagined Excel could do for you, saving hours of time each month.
Let us show you how to take full advantage of Excel, the application you need the most. At the end of this course, you will feel confident to tackle even the most complex business problem, without needing to bring in a professional programmer. The included theory will ensure you‘ll be able to learn even more functions to impress your team and feel assertive in control of your work and business.
- Course ID:
- LP2143-12
- Price:
- $630.00 (GST exempt)
- Status:
- Places are available.
- Location:
- Liverpool GHS
- Tutor:
- David Latimer
- Sessions:
- 8 sessions of 2 hours
- Time:
- 7:00pm-9:00pm
- Starts:
- Monday, 04 May 2026
- Finishes:
- Monday, 22 June 2026
Spreadsheets - Mastering Excel
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Do you use Excel for work or study? Looking for ways to do more with less? Want to tap into the full power of Excel‘s extensive functions and features? If so, this course is for you!
This advanced course explains and puts into practice the full suite of Excel tools to boost your productivity and analytical skills, while learning key theoretical principles to improve reliability and avoid mistakes. Each lesson explores the functions and other powerful features of the Excel application, and then shows how these are reliable solutions for important business tasks, so what has just been learnt can be applied immediately. You‘ll soon be doing things beyond what you ever imagined Excel could do for you, saving hours of time each month.
Let us show you how to take full advantage of Excel, the application you need the most. At the end of this course, you will feel confident to tackle even the most complex business problem, without needing to bring in a professional programmer. The included theory will ensure you‘ll be able to learn even more functions to impress your team and feel assertive in control of your work and business.
- Course ID:
- LP3143-12
- Price:
- $630.00 (GST exempt)
- Status:
- Places are available.
- Location:
- Liverpool GHS
- Tutor:
- David Latimer
- Sessions:
- 8 sessions of 2 hours
- Time:
- 7:00pm-9:00pm
- Starts:
- Monday, 03 August 2026
- Finishes:
- Monday, 21 September 2026
Spreadsheets - MS Excel
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Learn how to create and update spreadsheets using Microsoft Excel. Basic Windows skills required. Topics covered include concepts, entering and editing data, formatting, using formulas and functions, printing and charts. Memory stick included in course fee.
- Course ID:
- HH3143-12
- Price:
- $356.00 (GST exempt)
- Status:
- Places are available.
- Location:
- 403 Hume Highway Liverpool
- Tutor:
- John MWATENGA
- Sessions:
- 8 sessions of 2 hours
- Time:
- 7:00pm-9:00pm
- Starts:
- Wednesday, 05 August 2026
- Finishes:
- Wednesday, 23 September 2026
Spreadsheets - MS Excel
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Learn how to create and update spreadsheets using Microsoft Excel. Basic Windows skills required. Topics covered include concepts, entering and editing data, formatting, using formulas and functions, printing and charts. Memory stick included in course fee. Bring your own laptop if you have one.
- Course ID:
- WL3248-12
- Price:
- $269.00 (GST exempt)
- Status:
- Places are available.
- Location:
- 403 Hume Highway Liverpool
- Tutor:
- Fernando Da Costa
- Sessions:
- 1 session of 7 hours
- Time:
- 9:00am-4:00pm
- Starts:
- Saturday, 29 August 2026
- Finishes:
- Saturday, 29 August 2026
Spreadsheets - Programming with Excel: Principles and Practice
***NSW Government Subsidised places available for qualifying applicants. There is also funding available for small business owners/employees if the business has less than 20 employees or a turnover of less than $2M/year. Please contact College office for more information.
Do you already excel with Excel for work or study? Looking for ways to go far beyond its built-in functionality? Want to tap into hidden powers of Excel and Office? Want to understand important IT principles to continue learning about automation and programming? If so, this is the course for you!
Do you know standard Excel supports functional programming and that Microsoft Office includes Visual Basic for Applications (VBA)? In many cases, these are the fastest ways to improve productivity for the non-professional programmer. Just a few lines of procedural code can save you hours of work.
This unique course uses Excel to boost your automation skills while learning key computing principles. Each lesson teaches a fundamental of programming, and then finds a solution to arduous business tasks. By knowing the underlying principles, students will be able to decipher online manuals and go on to understand other programming languages.
Let us show you how to take thorough advantage of Excel, the application you know best, to do things with VBA that otherwise require installing an advanced programming environment. At the end of this course, you‘ll have completed your first VBA project. With the fundamentals under your belt, you‘ll be in a position to pick up more skills over time, impressing your managers or directors, gaining a clear understanding of IT professionals, and feeling innovative with your work and business. No concession.
- Course ID:
- HH3560-12
- Price:
- $840.00 (GST exempt)
- Status:
- Places are available.
- Location:
- 403 Hume Highway Liverpool
- Tutor:
- David Latimer
- Sessions:
- 8 sessions of 2 hours
- Time:
- 6:30pm-8:30pm
- Starts:
- Thursday, 06 August 2026
- Finishes:
- Thursday, 24 September 2026
Agenda
Week 1: POPPING THE HOOD- learn about the Office VBA programming environment and write your first practical computer program in VBA with a basic loop, following common conventions.
Week 2: CREATING PROCEDURES- let‘s think about what a program is, then learn how to design a program, and how to use Excel macro recorder to write parts of that program.
Week 3: INFORMATION DATA- learn about variables, data types, data conversion, type functions, data tables and how computers handle numbers, text and images.
Week 4: FUNCTIONAL PROGRAMMIMNG- learn about computer logic and programs that fit inside an Excel cell, including how to test functions, avoid user input errors and repair sheets with VBA.
Week 5: WORKING LIKE AN ENGINE- learn more about loops, other control structures and error handling to build robust, reliable, time-saving programs.
Week 6: OBJECT ORIENTED DESIGN- learn how VBA reveals the inner workings of Excel from charts to pictures to capacities hidden from users, then practice by writing an output text file program.
Week 7: FIRST PROJECT- put together everything you know, by completing your first project within two hours, with help on hand to get you though errors and other problems you may encounter.
Week 8: USING AI INTELLIGENTLY- learn how to use ChatGPT or other AI language models to fast-track and debug programs while avoiding the pitfalls of code that doesn‘t work or make sense. Demonstrate your first project to your classmates and compare to what AI generates.
Materials
FIRST SESSION NEEDS: (Needs are advised to participants on their confirmation and available on the internet)
Bring your laptop with any version of Excel software, except online or web versions.
Bring a pen to write on your freely-provided course notes.
Search our courses
Your student record
Your wishlist
- Save courses for later enrolment by selecting a course and clicking Add to Wishlist.
How about something completely different?
Art Studio - Wonderful Watercolour
- Watercolour is a superbly smooth, graceful and adaptable medium to work with, and watercolour paintings are most certainly a visual delight to see. Watercolour allows you to create soft backgrounds, enables you to manipulate and overlap colours, to beautifully blend as well as refine and define areas of detail. Whether you are totally new to watercolour or have a little know-how, you are warmly invited to come along for some watercolour exploration. Throughout this workshop Jo will introduce ...Read on
Photography - Getting to Know Your Camera - Pop Up Class
- Join Neoklis for his Photography Pop-Up Workshop, set amongst the magnificent Australian Botanic Garden Mount Annan, where you'll delve into the intricacies of your camera, from setting it up meticulously to mastering its controls. Discover the art of adjusting shutter speeds and depth of field, fundamental elements for capturing remarkable and unforgettable images.
This workshop is tailored for individuals who have recently acquired a camera, those seeking a refresher with their current ...Read on
Tech Savvy Seniors - Internet Email Staying Safe Online and Online Banking
- This workshop is designed for Seniors 60+ (or ATSI 50+) who have heard of the Internet but are not sure what it can offer them. You will learn how to get online, surf the net, do effective searches, and find the right Internet plan for you. Learn how to navigate and scroll through websites effectively, download files, using and storing pages in your favourites folder, change your internet browser's home page, enlarge a webpage, watch movies online, how to create your own email account, read and ...Read on

Like Us on Facebook
Facebook