All courses
In this self-paced online course, you will learn financial modelling best practice in detail – learning how to confidently construct robust and transparent financial models that can be easily used and understood by others.
This course provides an introduction to the disciplines and techniques underpinning the construction of financial models that are transparent and easy to use. The course is structured around tried-and-tested best practice techniques that are the distillation of the lessons learned (often the hard way) over many years working as a professional financial modeller. It is taught in an engaging manner, making use of our real “war stories” and practical exercises, including a case study embedded throughout.
If you are about to embark on a career that requires building financial models, or you are already doing such work but have never been shown the ropes, then this is the course for you.
This course is a more detailed compilation of our one day, face-to-face, Financial Modelling Best Practice Course. This 60-hour course is much more comprehensive and learning is self-managed through an online Learning Management System (Canvas).
This aim of this course is to provide a systematic and comprehensive overview of best practice financial modelling, providing you with the knowledge and confidence to construct professional financial models.
By the end of this course, you should be able to:
- review and critique financial models against best-practice principles
- design and construct financial models that adhere to best-practice principles
- analyse and break down complex problems into simple conceptual models
- evaluate and apply pertinent spreadsheeting analysis techniques to solve problems
- describe the value and use of financial models to understand the current financial situation and analyse the potential future performance of a business
- communicate confidently and effectively within a business, using the tools and techniques of financial modelling.
Financial modelling foundations
In this first topic, we will tackle the foundational concepts of financial modelling and learn everything covered in our one-day best practice financial modelling course. We will consider why we build models, who we build them for, and how to go about doing it.
We will go through an Excel 101 introduction to the functions and formulas available in Microsoft Excel, and you will also be introduced to the problem solving framework that professional financial modellers employ when attempting to convert complex business concepts into simple financial models.
Revenue and expenditure
In this topic, you will learn how to build bottom-up forecasts of the key drivers of a business, including breaking out costs into fixed, variable and semi-variable components. You will learn how to apply growth factors to reflect indexation and escalation, how to generate a capital expenditure program, how to reflect depreciation dynamically, and how to model corporate tax.
Integrated financial statements
In this topic, you will be introduced to the three financial statements that underpin the essence of a financial model (the income statement, balance sheet and cash flow statement). You will understand the importance of integrating these three statements in your models, how to use control accounts for building up the balance sheet, and how to use waterfall methods for constructing the income statement and cash flow statement.
Valuation
In this topic, you will learn about the concept of the time value of money and how this underpins the techniques used to value a business. You will apply these concepts to calculate net present values, internal rates of return and other financial ratios that are pertinent to understanding the financial state of a business. You will also learn the pitfalls underpinning the inbuilt Excel functions for NPV and IRR, and how to best address them.
Quality control
This final topic addresses some of the key quality control techniques that separate the good financial modellers from the great ones. You will learn the importance of embedding checks and alerts into your financial models, the best way to handle errors, the value of visual communication, the black list of techniques to avoid, and the various risks that you must manage as a professional financial modeller.
The course is designed to be suitable for those interested in going to, or already at, University; already working and using Excel, career pivots, or anyone using Microsoft Excel to build models or solve problems. Typical roles that require these skills include:
- Anyone studying or intending to study accounting, commerce, engineering, actuarial studies
- Investment bankers
- Financial analysts
- Commercial analysts
- Management consultants
This course builds skills you can apply straight away in a real-world business setting. Both your productivity and workplace confidence will be enhanced.
Please note it is a non-award course and does not contribute to a qualification under the AQF Qualifications.
There are no prerequisites for attending this course. It will be assumed that you have at least opened Microsoft Excel and performed some basic tasks with it. We find that those participants who need to use Excel for their work, but have never been properly “shown the ropes”, get the most value out of this course as they have many light bulb moments.
You will have 180 days to complete the course (from the date of enrolment) at your own pace. It takes approximately 60 hours to complete, and learning is self-managed through an online Learning Management System (Canvas).
You will work through course materials at your own pace online. Delivery involves a mixture of:
- videos introducing each concept
- activities to reinforce the concepts learned
- open discussion of the concepts on the classroom forums
- practical problem solving through designing logic and converting it into Excel formulas, predominantly via the case study (videos provide step-by-step guidance on the construction of the case study model).
At all stages, you will have access to the facilitators who can answer any questions and help troubleshoot with any elements of the content they may be struggling with.
You will gain access to all exercises and teaching materials covered in the sessions. In addition to the videos, the activities and case study will provide a reference that you can look back on when embarking on solving your own problems with financial models (be it at work or elsewhere).
Additional information
You will need your own device with Microsoft Excel installed (Windows or Mac). A strong internet connection is also advised as the vast majority of the content is streamed as videos.
This course is managed through a Learning Management System (Canvas). Once enrolled, you will be provided with login details. All work and emails submitted through Canvas will receive a reply within 24 business hours.
This course is non-award and does not provide any official certification. Once all modules are completed, you will be issued a Statement of Completion.
View Financial Modelling Course Online: The Complete Guide detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis two-day study methods course for Years 10 – 12 students focuses on time management, learning and memory, critical thinking and the examination period.
Students develop strategies for independent study and time management for all subjects. We begin with how to confront and overcome distraction and procrastination – the most common difficulty for students in Years 11 and 12. The course then defines the higher order thinking that underpins HSC syllabuses and marking guidelines. Time management is explored – a major need for success in study, with specific reference to time management techniques such as Pomodoro and certain note taking systems, eg Cornell. Recent theories of learning and memory are explained and applied.
Throughout the course, you will put your learning into practice in self-chosen areas of study. Other topics include revision throughout the year, final revision and the exam period; examination papers and practice for exam conditions. The range is wide and the course is varied, including a focus on using online resources and databases such as those available through the State Library of NSW.
By the end of this course, you should be able to:
- confront and overcome procrastination
- plan and maintain time management, including timetables for the session, the week, the school term and the year
- apply key theories of learning and cognition, including how these apply to NESA syllabuses and examinations
- plan for study and revision throughout the year
- prepare for the examination period
- improve use of research resources including online resources and library resources such as those available through the State Library of NSW
- read and analyse sample HSC examination material provided by NESA.
- Recognising and overcoming procrastination
- Discussion and application of theories of cognition and critical thinking, including the range from knowledge to analysis and synthesis
- Discussion and application of recent theories of memory and learning, including learning over time, depth learning, and analytic elaboration of knowledge and ideas
- Student application of memory and learning methods to self-chosen material
- Discussion and analysis of research resources including the State Library of NSW HSC resources and other online resources
- Discussion and planning for revision throughout the year and in the period before examinations
- Discussion about the examination room experience and how to deal with examination papers
- Study of examination papers, exam essays and other examination material provided by NESA
Students in Years 10-12
Delivery includes presentation by the teacher and interactive group discussion. Sharing issues and solutions is a major part of this course. You will apply the study methods to self-chosen topics and texts. You will need access to texts and other school material during the course.
You will be provided with a course booklet (electronic copy) using Dropbox which includes previous examination papers and essays.
Bring your own device
You are required to bring your own device (Windows or Mac) and a power cord. Please ensure your device is fully charged as access to power is limited.
Please note that the University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
References
NESA Syllabus agreement: (1) The 2017 Introduction provided at the beginning of to the Stage 6 Curriculum for Higher School Certificate courses in English, Mathematics and Science; (2) Learning Across the Curriculum in the 2017 NESA Stage 6 Curriculum.
View Years 10-12 Course: Study Methods detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis one-day HSC English preparation course focuses on George Orwell’s Nineteen Eighty-Four (1949) for the Common Module: Texts and Human Experiences.
The review of the novel begins with context: Orwell’s response to the Cold War period led to a dark, dystopian, science fiction satire that is both a puzzle about the history of Communist Russia and a warning against totalitarianism. Analysis and discussion of selected passages focuses the representation of totalitarianism and raises questions about the relevance of propaganda, socialism and capitalism to the present.
Analysis of Winston’s story and its range from realism to fable and dream focuses conformity, dissent, and surveillance and technology. Detailed analysis of selected passages focuses exploration of doublethink, Room 101, O’Brien’s vision of a future of propaganda and torture, whether the proles offer any hope, and pessimism versus optimism.
Comparison to other texts further encourages personal responses about individual and collective human experience. For example, the White Rabbit exhibition Republic of Jing Bang - influenced by Nineteen Eighty-Four - raises the issue of the construction of identity in relation to the present world of television, news and social media.
This course is only suitable for students who will be in Year 12 in 2026. An updated HSC syllabus will be introduced in 2026, so the content is not suitable for students who will be in Year 11 in 2026.
By the end of this course, you should be able to:
- analyse and discuss Nineteen Eighty Four in relation to the concept of ‘textual integrity’ including context, narrative, structure, themes, literary style, key words and motifs
- analyse and discuss Nineteen Eighty Four as a special case of literature as a representation of individual and collective human experience, with a focus on twentieth-century history, totalitarianism and propaganda
- make informed and personal connections between key experiences and themes in Nineteen Eighty Four and the present, including O’Brien and the proles.
- Critical study of Nineteen Eighty-Four as a complex text in relation to the concept of ‘textual integrity, including narrative and genre, with attention to the hybrid form - dystopian science fiction, realistic fable, satire, dream, variation on propaganda.
- Critical study of Nineteen Eighty Four in relation to context and meaning in order to explore its particular interest as a representation of individual and collective human experience, including the focus on twentieth-century history and politics, totalitarianism and propaganda.
- An overview and analysis of selected passages of Nineteen Eighty-Four in order to encourage students to challenge assumptions and explore new ideas about individual and collective human experience in confrontation with the pessimism of the novel. The selected passages include doublethink, Room 101, O’Brien’s vision the future, and the proles.
Year 12 HSC English Standard and Advanced students studying George Orwell’s Nineteen Eighty-Four for the Common Module: Texts and Human Experiences.
A combination of lecture and group discussion with selected passages and selected literary criticism and related texts used as a basis for interactive exploration of the text to provide informed personal student responses.
A course booklet is provided electronically. Please bring along your own copy of the text.
Bring your own device
You are required to bring your own device (Windows or Mac) along with a power cord. Please ensure your device is fully charged, as access to power outlets is limited.
Please note that University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
References
NESA English Advanced Stage 6 Syllabus (2017)
View HSC English Standard & Advanced Preparation Course - Common Module: 'Nineteen Eighty-Four' details
EA 12-1, EA 12-2, EA 12-3, EA 12-4, EA 12-5, EA 12-6, EA 12-7, EA 12-8, EA 12-9WaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listIn this Microsoft Copilot: Your AI Virtual Assistant course, you'll learn how to effectively communicate with Microsoft Copilot to maximise its output and master its use to simplify complex tasks, create your own AI agent, and share work and data efficiently using AI. Through hands-on lessons, you will develop your digital research, collaboration, and content creation skills using Copilot.
We will explore the different versions of Copilot, highlighting their capabilities, advantages, and limitations. Utilising Copilot on the Web, you will gain insights to improve writing and communication by instructing the AI to be creative, balanced, or precise. The accuracy of Copilot’s responses improves when you apply recommendations imparted from our expert instructors.
Increased productivity is achieved using Copilot 365 to analyse emails, PowerPoints, and files. The greatest benefits of Copilot 365 are realised when it is used to compose, analyse and summarise content within your applications such as: Word, Excel, Outlook, PowerPoint, Teams, and more.
Finally, we will teach you how to use Copilot to clean data, create functions, and leverage the innovative capabilities of the AI-driven app, Copilot Loop. You'll also learn to create and deploy your own AI specialist, known as a Copilot Agent.
This course aims to introduce you to Microsoft Copilot, an innovative AI tool that assists in creating and managing files, sites and content with ease and efficiency. You will learn how to use Copilot effectively in various situations and contexts, such as writing emails, creating reports, designing presentations, analysing spreadsheets, cleaning data and collaborating with colleagues. Additionally, we will show you how to use Copilot to create functions in Excel, leverage the capabilities of the new AI-driven app—Copilot Loop, and develop your own AI specialist, the Copilot Agent.
By the end of this course, you should be able to:
- understand the concept, features, benefits, and limitations of Microsoft Copilot
- communicate with Copilot on the Web to request tone and format, seek comparisons and summaries, and perform sentiment analysis, keyword prominence, and topic clustering
- harness the power of Copilot Loop for seamless collaboration and dynamic content updates
- use Copilot Notebook for advanced, tailored, and detailed prompts, ask questions, get help, and revise answers
- use Copilot 365 to compose and analyse content within Microsoft applications, such as Word, Excel, and PowerPoint
- collaborate with Copilot 365 alongside Microsoft tools, such as Teams, Outlook, and SharePoint libraries
- streamline the production of various types of files, such as forms, quizzes, reports, plans, lists, ideas, presentations, and agendas.
What is Microsoft Copilot
- An introduction of what is GenAI, Large Language Model (LLM) and Natural language processing (NLP)
- A brief discussion defining Microsoft Copilot, ChatGPT, and AI tools in general
- When, where, and why to use Copilot
- Comparison of the benefits and limitations of each version of Microsoft Copilot and ChatGPT
- A discussion regarding commercial and data protection
- Available addons
Working with your everyday AI companion – Copilot on the Web
- Effective communication to obtain the best results:
- Improving the accuracy of answers
- Providing context and background to improve accuracy and relevance
- Utilising follow-up questions
- Revising with additional information
- Summarising websites, intranet pages, and PDFs:
- Sentiment analysis: highlighting positive, negative, or neutral language
- Keyword prominence: identify keyword importance
- Topic clustering grouping related ideas into distinct topics
- An introduction to Loop pages and Copilot Page:
- What are Loop pages?
- Draft and add content with Microsoft 365 Copilot in Loop
- Recap changes in Loop with Copilot
- Summarise a page with Copilot in Loop
- How Loop is integrated with Copilot Chat
Working with your AI assistant at work – Copilot 365
- Word
- Use ‘prompts’ to reference, retrieve, and gain insights
- Draft new content: forms and quizzes
- Reference and analyse related documents to create new reports
- Summarise, ask questions, and instruct Copilot with commands
- Excel
- Use ‘prompts’ to reference, retrieve, and gain insights
- Get suggestions for formulas and charts
- Use Copilot to clean, format and transform data
- Create complex formulas using copilot
- PowerPoint
- Use ‘prompts’ to reference, retrieve, and gain insights
- Create new presentations from scratch, or from Word documents and PDFs
- Format with your organisation’s branding, themes, and templates
Using Copilot to collaborate
- Teams
- Meeting assistance
- Post-meeting recap
- Document integration
- Outlook
- Use ‘prompts’ to reference, retrieve, and gain insights
- Get coaching tips and suggestions on clarity, sentiment, and tone
- Summarise an email thread
- OneDrive
- Generate content summaries for files
- Compare files
- SharePoint
- Create a Copilot agent in SharePoint
- Write with Copilot in SharePoint rich text editor
Anyone interested in using Copilot to improve their productivity and communication would benefit from this course.
This course assumes little or no knowledge of Copilot. However, you should have an understanding of Microsoft Office 365, personal computers and the Windows operating system environment. If you do not have these skills, we recommend attending Microsoft Office with 365: Essentials before attempting this course.
Delivery modes
- Face-to-face, presenter-taught training in a computer lab
- Online training via the platform Zoom
Face-to-face classes
These classes run in a computer lab.
Online classes
You will need your own device. During class, you will be given temporary login details to access the paid version of Microsoft Copilot.
Course materials are shared electronically using Dropbox.
Additional information
Please note, this course covers features included in the paid version of Microsoft Copilot, which is different to the free version that comes with an Office 365 subscription.
View Microsoft Copilot Course: Your AI Virtual Assistant detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis course is the first in a series of four Mathematics Advanced courses and provides consolidation of the key content and skills from specific topics in the Mathematics Advanced HSC course. The program covers graphing techniques, trigonometric functions and graphs, differential calculus, and descriptive statistics and bivariate data analysis. Prerequisite skills from the Mathematics Advanced Preliminary course will be reviewed. Study skills and examination techniques will also be emphasised.
Other courses in this series include HSC Mathematics Preparation - Advanced (Part 2) (April) and HSC Mathematics Preparation - Advanced (Part 3) (July). You do not need to attend all three parts in order to benefit.
This course is suitable for students who will be in Year 12 in 2026. An updated HSC syllabus will be introduced in 2026, so the content is not suitable for students who will be in Year 11 in 2026.
By the end of this course, you should be able to:
- apply transformations to sketch polynomial, reciprocal, absolute value, trigonometric, exponential or logarithmic functions
- use graphical methods and supporting algebraic techniques to solve a variety of practical problems, including those involving periodic phenomena
- solve trigonometric equations
- differentiate trigonometric, exponential and logarithmic functions
- apply the product, quotient and chain rules to differentiate functions
- organise, interpret and display grouped and ungrouped data
- calculate and interpret summary statistics and identify outliers
- construct bivariate scatterplots and use them to describe patterns, features and associations of bivariate data sets
- analyse bivariate data sets using Pearson’s correlation coefficient and lines of best fit
- answer a range of questions based on the topics covered
- critically evaluate your own and others’ solutions to improve the quality of responses in assessment tasks
- interpret mathematical language of examination questions to better understand the steps required in a quality solution.
The following topics from the Mathematics Advanced HSC syllabus will be covered:
- MA-F2 Graphing Techniques
- MA-F3 Trigonometric Functions and Graphs
- MA-C2 Differential Calculus
- MA-S2 Descriptive Statistics and Bivariate Data Analysis
This course is suitable for students who will be in Year 12 in 2026. An updated HSC syllabus will be introduced in 2026, so the content is not suitable for students who will be in Year 11 in 2026.
Delivered as a two-day activity-based workshop where we will explore and apply mathematical knowledge and skills in a combination of lectures, tutorials and problem-solving sessions. Practice exercises are carefully graded and you will receive immediate feedback.
You will receive electronic copies of the following:
- a course booklet including theory and worked examples, covering all syllabus dot points from the relevant topics
- solutions to all questions in the course booklet
- relevant past examination questions from the previous mathematics course, as well as from other educational jurisdictions, with sample answers provided.
Bring your own device
You are required to bring your own device (Windows or Mac) along with a power cord. Please ensure your device is fully charged, as access to power outlets is limited.
Please note that University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
Course evaluation
This course will be evaluated through an online student questionnaire, which will be sent via email during class.
View HSC Mathematics Preparation Course - Advanced (Part 1) (January) detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis HSC English preparation course focuses on English Advanced Module C: The Craft of Writing.
This one-day course provides:
- a comprehensive overview of the course requirements
- a review of the mandated general features of writing (allusion, imagery, narrative voice, characterisation and tone)
- an explanation of key vocabulary
- an analysis of relevant HSC questions, plus other NESA specimen questions
- explicit teaching of how language evokes emotion, in a selected group of texts from the prescribed list
- close analysis, individual activities, and group discussion on prescribed texts
- activities based upon the five required styles of writing (imaginative, discursive, persuasive, reflective, and informative).
This course is only suitable for students who will be in Year 12 in 2026. An updated HSC syllabus will be introduced in 2026, so the content is not suitable for students who will be in Year 11 in 2026.
By the end of this course, you should be able to:
- analyse and respond to the syllabus and prescriptions for the HSC Advanced English Module C: The Craft of Writing
- differentiate and respond in mandated styles of writing: discursive, persuasive, imaginative, reflective
- replicate and redeploy devices used in the prescribed texts within their own writing
- understand that key literary features (eg characterisation, voice, tone) include a sub-set of other elements
- make appropriate semantic choices to describe literary devices, stylistic choices or aesthetic features in their own or others' texts.
- Critical analysis of important language devices of significant, selected prescribed texts.
- Evaluation of the suitability of language forms, features and structure for different purposes, audiences, contexts and meanings.
- Experimentation with the strategic application of language devices in different contexts.
- Examination strategies for: question/stimulus analysis; anticipating and preparing for different types of question (eg ideas-focused, text-specific, or a specified literary device or stylistic feature); integrating the provided stimulus in the response; and scaffolding/structuring the response.
Year 12 HSC English Advanced students.
Small classes. Lecture and workshop style. Group discussion for interactive exploration of the texts and informed personal student responses. Students will also read and discuss sample HSC examination material provided by NESA.
A course booklet is provided electronically. Please bring along your own copy of the text.
Bring your own device
You are required to bring your own device (Windows or Mac) along with a power cord. Please ensure your device is fully charged, as access to power outlets is limited.
Please note that University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
References
NESA English Advanced Syllabus 2017
View HSC English Advanced Preparation Course - Module C: Craft of Writing details
EA 12-1, EA 12-2, EA 12-3, EA 12-4, EA 12-5, EA 12-6, EA 12-7, EA 12-8WaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis short course will extend your knowledge of Excel beyond Microsoft Excel: Level 1 and provide you with the skills and knowledge to produce more effective and productive workbooks. Learn essential functions as well as how to manage list data, cover formulas and function techniques, PivotTables, intricate formatting, setting complex printing options and using intricate charting features. Completion of this course provides sufficient knowledge to progress onto Microsoft Excel: Level 3.
We encourage you to use the CCE Excel level self-assessment tool if you are unsure which course level to enrol in.
This course aims to provide more experienced users with proficient skills in Excel’s three major strands: formulas, list management and charts, as well as providing tips to assist with best practice and efficiency.
By the end of this course, you should be able to:
- use the Autofill, Flash Fill and Text to Columns tools to fill a data series and separate data
- use a range of techniques to work with worksheets
- protect data in worksheets and workbooks
- use popular worksheet functions
- create more complex formulas and functions
- understand and use Formula Auditing tools
- create and work with Tables and Slicers
- understand and create simple Pivot Tables with a Slicer
- create and apply custom number formatting techniques to worksheet cells
- apply conditional formatting to cells
- understand and use Sparklines
- understand and use Excel's Quick Analysis tool
- use Goal Seek to determine the values required to reach a desired result
- use a range of Chart Elements to enhance charts.
Filling Data
- Create and modify a custom fill list
- Use a custom fill list
- Delete a custom fill list
- Extract data with Flash Fill
- More complex Flash Fill extractions
- Extract dates and numbers with Flash Fill
Worksheet Techniques
- Hide and unhide rows and columns
- Hide and unhide a worksheet
- Copy a sheet to another workbook
- Change worksheet tab colours
- Group worksheets for bulk changes
- Freeze rows and columns
Managing Lists with Tables
- Insert a table
- Rename a table
- Table styles
- Remove duplicate rows
- Sort and filter in tables
- Formulas in tables
- Add a total row
- Inserting or deleting in tables
- Table autoexpansion
- Slicers in tables
- Convert a table to a range
Essential Functions
- TEXT functions - UPPER, PROPER, CONCAT, TRIM
- COUNT functions - COUNT, COUNTA, COUNTIF
- IF functions – IF, IFS, SUMIF
- LOOKUP functions – VLOOKUP, XLOOKUP
- ROUND function – ROUND, ROUNDUP, ROUNDDOWN
- INT function
- Array functions – UNIQUE and SORT
- SUMIF
Complex Formulas
- Create Complex Formulas Using Nesting
- Line Breaks in Formulas
- Paste Link
- Store Formula as Text
- Formula Auditing Tools
Manage Columns and Rows
- Hiding Rows and Columns
- Unhiding Rows and Columns
- Hiding & Unhide sheets
- Grouping Worksheets
Understand Data Protection
- About Protection
- Preparing Cells for Data Entry
- Protect Sheet
- Unprotect Sheet
- Protect Workbook Structure
- Unprotect Workbook Structure
- Protect File
- Unprotect File
PivotTables
- Insert Pivot Table
- Switch Fields
- Change Calculation
- Apply a Style
- Filter
- Clear Filter
- Refresh
Number Formatting
- Date Formats
- Custom Formats
- Time Formats
- Calculated Time
Conditional Formatting
- Conditional Formatting
- Greater Than
- Top and Bottom Percentage
- Specific Text
- Data Bars
- Icon Sets
- Edit and Manage Conditional Formatting
- Clear Conditional Formatting
Sparklines
- About Sparklines
- Insert a Sparkline
- Copy Sparkline
- Editing Sparklines
- Deleting Sparklines
Quick Analysis
- Display Quick Analysis button
- Create Totals
- Create a Chart
Goal Seek
- About Goal Seek
- Use Goal Seek
Charts
- Add Chart Elements
- Edit Chart Elements
- Data Labels and Data Tables
- Trendlines
- Error Bars
- Format Pane
Designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.
Assumes prior skill and knowledge required to create, edit, print and chart simple worksheets, as well as understand ranges and the copying process.
You should be also familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and saving files, familiarity with accessing the Internet and web browsers.
Delivery modes
- Face-to-face, presenter-taught training
- Online training via the platform Zoom
Face-to-face classes (CCE, Newtown)
These classes run in a computer lab and you do not need to bring your own device.
Face-to-face classes (external venues including PARKROYAL, Cliftons and CBD)
These classes run in a classroom and you need to bring your own device.
Online classes
You will need your own device.
Course materials are provided electronically using Dropbox. Teaching instructions and materials are specifically tailored to Windows PC users.
Additional information
Recommended operating system: Windows or Mac
Recommended software for PC: MS Excel 2013, 2016, 2019, 2021, 2024 or 365
Recommended software for Mac OS: MS Excel 2016, 2019, 2021, 2024 or 365
Recommended browser: Chrome<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/d5c5c52f-fa7e-4184-a51d-2bce8c04740a" class="js-course-brochure u-display-none">Course Brochure</a>
View Microsoft Excel Course: Level 2 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis course provides consolidation of the key content and skills from Module 5: Advanced Mechanics. There is a focus on those cognitive skills needed to access and apply chemical knowledge in an HSC assessment context and the higher order thinking needed to push student achievement into Band 6. The workshops are activity based whereby students explore and apply physics knowledge and skills using a combination of lectures, tutorials and problem-solving sessions with immediate feedback from teachers. In short, this course is designed to review key concepts and skills with a view to maximising results in a variety of physics assessment tasks.
This course is part of a four-part series covering key areas from within this subject’s syllabus. Other courses include HSC Physics Preparation (Part 2) (April), HSC Physics Preparation (Part 3) (July) and HSC Physics Preparation (Part 4) (September). Students do not need to attend all four parts in order to benefit. The series is supplemented by the HSC Physics Exam Preparation Course to prepare for end of year exams.
By the end of this course, you should be able to:
- answer a range of questions covering the content, concepts and skills in the module
- critically evaluate your own and others’ answers to improve the quality of responses to assessment tasks
- identify the relationships between key concepts in the module
- apply strategies for problem solving to improve the quality and accuracy of responses to assessment tasks
- critically analyse experimental methods and comment meaningfully on validity, reliability and accuracy
- analyse, process and apply quantitative chemical data to solve problems.
All three subtopics within Module 5: Advanced Mechanics will be covered:
- Projectile Motion
- Circular Motion
- Motion in Gravitational Fields
Relevant Skills will also be covered.
Suitable for Year 12 students wishing to undertake additional study for Module 5 of the HSC Physics Syllabus (2017), and accelerated Year 11 students who have already completed Modules 1-4.
Delivered as a two-day activity-based workshop where you will explore and apply physics knowledge and skills in a combination of lectures, tutorials and problem-solving sessions while receiving immediate feedback.
Course notes covering all syllabus dot points for each module, including examples, practical methods and results, are shared electronically.
Bring your own device
You are required to bring your own device. Please ensure it is fully charged as access to power is limited.
View HSC Physics Preparation Course (Part 1) (January) detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis Power BI beginner course will provide you with the skills to tackle data modelling with confidence and improve your decision-making ability with this self-service business intelligence tool. You will learn how to link and model data and create visual reports that reveal data insights. We will show you how to create dashboards for reporting, create a data visualisation, connect to data sources, use the query editor, model data and manage relationships.
The Power BI desktop client will be the primary focus but an introduction to the Power BI web app is also covered. For anyone interested in business intelligence and wanting to improve their reporting and analytical abilities, this Power BI training course is ideal.
We want to empower you to confidently use the Power BI tool. We aim to give you the ability to create useful data visualisations that improve your business intelligence and your ability to make data-driven decisions.
By the end of this Microsoft Power BI training course, you should be able to:
- navigate between different Power BI tools and their functionality
- build informative reports and dashboards
- work confidently with and create a variety of data visualisations
- work with measures
- create, edit and format interactive visuals
- create multiple levels of filters
- create and use custom slicers
- feature and favourite dashboards.
This Microsoft Power BI course will cover the following topics:
Introducing Power BI
- An Introduction to Microsoft Power BI
- Working with Power BI desktop file
- Connecting to data sources with Power BI Desktop
- Creating a report with visualisations
- Doing more with visualisations
Working with data
- Transforming and sanitising data
- Using the Query Editor
- Data modelling
- Managing relationships
Working with reports and visualisations
- Managing report pages
- Changing report view options
- Working with visualisations
- Adding static objects to a report
- Page navigation
A closer look at visualisations
- Matrices, tables, and charts
- Maps
- Cards, gauges, and KPIs
- Slicers
- Sparklines
Introduction to the Power BI web app
- Getting started with the Power BI web app
- Connecting to data sources with the Power BI web app
- Using workspaces, dashboards, and reports
- Creating custom dashboards
- Power BI web app features
This Microsoft Power BI training course is suitable for:
- Anyone who wants to get the most out of their data and reporting
- Excel users wanting to upgrade their reporting capabilities
- Data Analysts and those performing data analysis, data modelling or data visualisation
- Database Administrators
- Project Managers and those working in project management
- Financial Analysts
- Marketers
No prior knowledge of programming languages is required for this Power BI course. It is recommended that you be comfortable with the learning outcomes equivalent to our Microsoft Excel Course: Level 1.
Delivery modes
- Face-to-face, presenter-taught training
- Online training via the platform Zoom
Face-to-face classes (CCE, Newtown)
These Microsoft Power BI courses run in a computer lab and you do not need to bring your own device.
Face-to-face classes (external venues including PARKROYAL, Cliftons and CBD)
These Microsoft Power BI courses run in a classroom and you need to bring your own device with a Windows operating system.
Online classes
You will need your own device with a Windows operating system. Power BI Desktop only runs on a Windows operating system.
A course workbook and exercise files are distributed electronically using Dropbox.
Before the course
Please ensure Power BI Desktop is installed on your device before class. It can be downloaded from the Microsoft Website. Recommended minimum version – July 2022.
You will be provided with a login to Power BI pro – the cloud application. However, you can choose to use your own Power BI pro license if you have one.
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/8426d8ef-9a66-4561-ab7a-0c8c991e7fe0" class="js-course-brochure u-display-none">Course Brochure</a>
View Power BI Course: Introduction detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listAre you excited, curious or concerned about the impact AI might have on your job? Whether you're new to AI or have been experimenting for a while, this course will teach you practical ways to apply ChatGPT, Perplexity and Gemini to your writing, marketing and related business processes.
If writing is part of your job in any industry, AI tools can make your work easier. When you understand how to use them properly, you’ll be able to work and communicate faster, better and more effectively by:
- automating time-consuming tasks and processes
- overcoming writer's block and blank page paralysis
- saving hours of research, analysis and writing time
- creating high-quality short and long content in seconds
- producing personalised messages to customers and colleagues.
This one-day introductory course provides a practical introduction to AI writing tools, with a focus on ChatGPT, Perplexity and Gemini, and how to use them to improve your business and marketing communications.
The aims of this course are to give you the knowledge and skills to use ChatGPT, Gemini, and other AI tools to achieve your business communications goals, and help you become a better, faster, and more confident business and marketing writer.
By the end of this course, you should be able to:
- understand the basics of ChatGPT and other AI tools
- describe the benefits and limitations of ChatGPT/AI
- use ChatGPT/AI to create powerful and effective written communications
- use ChatGPT/AI to effectively to save time and improve the quality of your writing
- discuss various helpful and powerful AI communications tools.
Topics:
Introduction to AI writing tools
- Overview of AI writing tools and their impact on business communications
- Benefits of using AI writing tools for professionals and admin staff
Understanding ChatGPT and LLMs
- Overview and features
- How it works and its applications in business communications
- Limitations and considerations
Getting started with ChatGPT and Gemini
- Setup and use
- Understanding the basics of the interface
- Fun and practical exercises
Best practices for using ChatGPT/AI in business communications
- Powerful and effective prompts
- Writing styles and tone in business communications
- Improving the accuracy and relevance of outputs
- Common use cases in business communications
Advanced techniques for using ChatGPT/AI
- Customisation for specific use cases
- Fine-tuning for improved accuracy and relevance
- Best practices for maintaining and updating
Other AI communications tools
- Best AI Writers for different needs
- Amazing AI tools for video, images, productivity and more
Content types:
Emails
- Writing effective and professional emails with ChatGPT
- Automatic responses, follow-ups, and personalised email templates
- Tips for crafting engaging subject lines and email content
Articles, reports and presentations
- Outlining long form content with ChatGPT
- Writing unique, interesting and valuable articles
- How to use ChatGPT/AI to help write and summarise reports, presentations and other content
Letters
- Writing formal and informal letters with ChatGPT/AI
- Sales letters, cover letters, job application letters, and customer service letters
- Best practices for formatting and structuring letters with ChatGPT/AI
Marketing
- Common uses for ChatGPT/AI - product descriptions, web and print copy, blogs, social media posts, email marketing campaigns
- Overview of creating effective marketing content and copy
- Creating headlines, body copy and calls-to-action
This course is suitable for:
- Business professionals and admin staff
- Copywriters and content writers
- Small business owners
- anyone who wants to write better, faster and more effectively in business.
None
Delivery modes
- Face-to-face, presenter taught workshop using your own device
- Online workshop via the platform Zoom
The course is practical and hands-on, with exercises and real-world examples to help you develop an understanding of ChatGPT and how it can be used in your work.
Course materials are distributed electronically using Dropbox.
Additional information
Please bring a laptop to class in order to access the course learning materials, and join ChatGPT prior to class (choose the free version or the more reliable paid version).
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/ad774fa5-47ec-4023-9acf-cbb397d54321" class="js-course-brochure u-display-none">Course Brochure</a>
View Beginner AI Course: Using ChatGPT, Perplexity and Gemini for Business and Marketing Writing detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis Microsoft Excel short course will help you improve the way you manage and present information, and take the legwork out of calculations and data manipulation. It provides the skills and knowledge necessary to create and manage workbooks, and covers topics including adding data, editing data, working with formulas, managing list data, printing and charting. It is an ideal introductory course before progressing to Microsoft Excel Course: Level 2.
We encourage you to use the CCE Excel level self-assessment tool if you're unsure which course level to enrol in.
This course aims to provide new Excel users with a foundation knowledge of Excel’s core features such as formulas, formatting, navigation, printing and creating charts.
By the end of this course, you should be able to:
- navigate your way around Excel
- create and work with a new workbook
- open and navigate within workbooks and worksheets
- understand and work with ranges in a worksheet
- understand, create and work with formulas and functions used to perform calculations
- copy and paste data
- understand and use formula cell referencing
- use font formatting techniques
- align the contents of cells
- format rows and columns in a worksheet
- understand and use the number formatting features
- sort and fliter list data
- print workbook data
- create effective charts.
Getting to know Excel – The Excel screen, Ribbon and Toolbars
- Start Excel
- Understand the Start Screen
- Understand Excel terminology
- Understand and Navigate the Excel Workbook Screen
- Use and Customise the Quick Access Toolbar
- Understand and use the Ribbon
- Understand and use Contextual tabs
- Dialogue Box Launchers
- Live Preview
- Undo and Redo Changes
- Customise the Quick Access toolbar to store favourite buttons
- Use Shortcut menus
- Recognise mouse shapes and their functionality
Your first Workbook
- Create Your First Workbook
- Types of Data
- Enter Data
- Move Data
- Selecting Cells
- Editing Data
- Autocalculate
- Delete versus Clear
- Spellcheck
- Save Your Workbook
Working with workbooks
- Open a Workbook
- Move Between Worksheets
- Save a Workbook
- Close a Workbook
Formulas
- Create Simple Formulas
- View Formulas
- Problems with Formulas
- Delete Formulas
- SUM function
- Copying Formulas
- AVERAGE, COUNT, MIN, MAX Functions
- BODMAS
- Edit Formulas
Absolute References
- Understanding Absolute References
- Types of Absolute References
- Applying Absolute References
Filling Data
- Autofill
- Flash Fill
Formatting
- Formatting Numbers
- Formatting Dates
- Formatting Text
- Cell Alignment
- Borders
- Format Painter
Manage Worksheets
- Adjust Columns and Row Sizes
- Insert and Delete Columns and Rows
- Insert Cells
- Insert Sheets
- Move and Copy Sheets
- Delete Sheets
Manage Lists, Sort and Filter
- List Guidelines
- Sort Lists
- Filter Lists
- Freeze Titles
Printing
- Print Preview
- Page Setup
- Partial Printing
- Orientation, Margins and Scaling
- Manage Larger Printouts
- Page Numbering
Charts
- Understand Charting
- Create Charts
- Resize and Move charts
- Chart Styles
- Add and Edit Chart Elements
- Keyboard shorts for Instant Charts
Help
- Accessing Help
- Search the Menus
Best Practice – 5 Golden Rules
- Create sheets with the future in mind
- Choose clarity over looks
- Label columns and rows
- Keep styling and formatting consistent
- Never merge cells in lists
Quick reference guide
Top 25 keyboard shortcuts
Formula Error Messages
Suitable for beginners. Assumes little or no knowledge of Microsoft Excel.
You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers.
Delivery modes
- Face-to-face, presenter-taught training
- Online training via the platform Zoom
Face-to-face classes (CCE, Newtown)
These classes run in a computer lab and you do not need to bring your own device.
Face-to-face classes (external venues including PARKROYAL and CBD)
These classes run in a classroom and you need to bring your own device.
Online classes
You will need your own device.
Course materials are provided electronically using Dropbox. Teaching instructions and materials are specifically tailored to Windows PC users.
Additional information
Recommended operating system: Windows or Mac
Recommended software for PC: MS Excel 2013, 2016, 2019, 2021, 2024 or 365
Recommended software for Mac OS: MS Excel 2016, 2019, 2021, 2024 or 365
Recommended browser: Chrome<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/03464206-4946-41b1-b769-7b6802af71d0" class="js-course-brochure u-display-none">Course Brochure</a>
View Microsoft Excel Course: Level 1 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listGlobalisation and Australia’s Place in the Global Economy including Balance of Payments
This course will revise the key components of HSC Economics Topic 1 – The Global Economy, introduce the key themes of HSC Economics Topic 2 – Australia’s Place in the Global Economy, and investigate some of the pitfalls associated with answering examination questions in Economics. Specific attention will be given to the characteristics of globalisation and the economic implications for economies around the world of this continual process of globalisation and change. This course will also cover the role played by Australia in the globalised economy, with particular reference made to the Balance of Payments.
This course is part of a three-part series covering key areas from within this subject’s syllabus. Other courses include HSC Economics Preparation (Part 2) and HSC Economics Preparation (Part 3). Students do not need to attend all three parts in order to benefit. The series is supplemented by the HSC Economics Exam Preparation Course to prepare students' for end of year exams.
By the end of this course, you should be able to:
- examine the impact of the globalisation process on economic growth and the quality of life, levels of unemployment, rates of inflation and external stability
- assess the potential impact on the environment of continuing world economic development
- investigate the global distribution of wealth and investigate the consequences of an unequal distribution of global wealth
- discuss the effects of protectionist policies on the global economy
- analyse statistics on trade and financial flows to determine the nature and extent of global interdependence
- assess the impact on the global economy of international organisations and contemporary trading bloc agreements
- assess the impact of development strategies used in a range of contemporary and hypothetical situations
- synthesise information from a variety of sources to evaluate the impact of the global economy on the Australian economy
- examine the impact of changes in the global economy on Australia’s economic performance
- analyse the relationship between international competitiveness and structural change in the Australian economy
- explain the relationship between the current account balance, net foreign debt and net foreign liabilities
- calculate and interpret the effects of changes in Australia’s terms of trade index.
- H1 Understanding of economic terms, concepts and relationships with respect to: economic growth and the quality of life, levels of unemployment, rates of inflation and external stability; global distribution of wealth; protectionist policies on the global economy; international organisations and contemporary trading bloc agreements.
- H2 Economic role of individuals, firms, institutions and governments with respect to: impact on environment of continuing world economic development; consequences of an unequal distribution of global wealth; protectionist policies on the global economy; changes in the global economy on Australia’s economic performance.
- H3 Role of markets within the global economy with regards to: distribution of global wealth; protectionist policies; international competitiveness and structural change in the Australian economy.
- H4 The impact of global markets on the Australian and global economies with respect to: economic growth and the quality of life, levels of unemployment, rates of inflation and external stability.
- H5 Policy options for dealing with problems and issues in contemporary and hypothetical contexts with regards to: Environment; distribution of wealth; protectionist policies.
- H6 The impact of economic policies in theoretical and contemporary Australian contexts with regards to: protectionist policies on the global economy; international organisations and contemporary trading bloc agreements; development strategies used in a range of contemporary and hypothetical situations.
- H7 Consequences of contemporary economic problems and issues on individuals, firms and governments with regards to Environment; global distribution of wealth; protectionist policies.
- H8 Appropriate terminology, concepts and theories in contemporary and hypothetical economic contexts with regards to: the impact of development strategies used in a range of contemporary and hypothetical situations.
- H9 Information from a variety of sources for relevance and reliability with regards to: analysing statistics on trade and financial flows to determine the nature and extent of global interdependence.
- H10 Economic information, ideas and issues in appropriate forms with regards to: examining the impact of changes in the global economy on Australia’s economic performance.
- H11 Mathematical concepts in economic contexts with regards to: calculating and interpreting the effects of changes in Australia’s terms of trade index.
(Aligned to NESA Syllabus Reference Points)
HSC Economics students
In order to cater for students’ different learning styles, this course will have a blend of lecturer instruction via PowerPoint, short answer practice, multiple choice analysis, essay planning, sample HSC question practice and feedback, extended discussion of issues and implications, and analysis of past student responses. Lessons will incorporate both group and individual student participation.
A course booklet covering syllabus content plus a Q&A booklet (provided electronically using Dropbox).
Bring your own device
You are required to bring your own device. Please ensure it is fully charged as access to power is limited. Please note that the University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
View HSC Economics Preparation Course (Part 1) (January) detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting list
