Information technology courses
Information technology courses. Boost your career and future-proof your employability.
Practical IT skills for a changing workplace
A wide range of topics
Apply what you learn
For professionals at any level
Led by IT professionals
Flexible study options
All courses
In 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 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 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 listThis two-day Adobe InDesign training course will have you designing a variety of layouts for both print and digital publishing. You will be guided step-by-step through the basics of the software, in order to create your own print and digital material.
Your own Adobe Creative Cloud account is required for this course. You will also need your own device. For further details, see 'Before the course'.
By the end of this course, you should be able to:
- discuss how the application can be used and start working with it
- set up and create a new document
- work with and modify elements of a workspace
- use basic navigation
- understand the frame tools
- work with text
- work with layers
- understand colour and how to use it
- work with linked graphics and images
- work with pages
- ensure documents are ready to print
- package and export options
- use the Help menu and access online help resources.
InDesign Interface
- Introduction
- Workflow at a Glance
- Start Workspace
- Workspaces
- Reset Workspaces
- Navigation - Zooming
- Screen Modes [ W ]
- Display Performance
New Document
- New Document
- Templates
- Document Settings
- Preference Settings
- Adjust Document Size
- Adjust Document Layout
- Layout Margins and Columns
- Custom Document Preset
- Different Page Sizes within a Single Document
InDesign Frame Types
- Text Frame (Type Tool)
- Rectangle Frame Tool (Placeholder)
- Rectangle Tool (Shape)
Typography
- Character Formatting
- Select Text
- Placing Text (Import Microsoft Word file)
- Find and Replace Fonts
- Properties Panel
- Paragraph Formatting
- Overset Text
- Hyphenate
- Paragraph Settings Overview
- Text Frame Options - Centre Text within a Frame
- Character and Paragraph Spacing
- Text Threading
- Automatic Text Threading
- Text on a Path
- QR Code
- Glyphs & Special Characters
- Number of Columns
Graphics & Images
- Placing Images & Graphics
- Fitting options
- Content Grabber
- Transform Images
- Align and Distribute
- The Gap Tool
- Paste Into
- Text Wrap
- Clipping Path
- Links
- Layers
- Group Layers
Shapes and Objects Shapes
- Pathfinder Tool
- Rounded Corners
- Stroke
- Stroke Type Example
Colour & Transparency
- Apply Fill and Stroke Colour
- Swatches Panel
- Custom Colours
- Colour Picker
- Tint Swatch
- Gradient Tool
- Gradient Feather
- Colour Theme Tool
- Transparency & Effects
- CC Libraries
Pages
- Pages Panel Overview
- Insert New Pages
- Parent Pages vs Document pages
- Create Parent Page Items
- Apply Parent to Pages
- Delete Pages
- Override a Parent Page Item
- Parent Item on Top
- Restore Parent Page Items
- Automatic Page Numbering
- Rearrange Pages
Save and Export
- Save InDesign Document
- Save a InDesign Template
- Preflight
- Package Files
- Export to a PDF for Printing
- Export JPG and PNG File Formats for the Web
- Keyboard Shortcuts Keyboard Shortcut list
Suitable for anyone wanting to learn the basics of graphic production to create layouts for print media.
This introductory course assumes little or no knowledge of the software.
Delivery modes
- Face-to-face, presenter-taught training using your own device
- Online training via the platform Zoom
Face-to-face classes
These classes run in a classroom and you will need to bring your own device with Adobe InDesign installed. You should 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.
Online classes
You will need your own device with Adobe InDesign installed. We also recommend using a computer with a larger screen, or two screens/devices. A small laptop screen provides limited space, and it can be difficult to manage following the facilitator’s screen and using your own software.
Course materials are provided electronically using Dropbox
Before the course
You will need an Adobe Creative Cloud account to participate. If you don't have an existing account, you can purchase an Adobe Creative Cloud account here. Please bring your account login details with you to class.
- Recommended operating system: Windows or Mac
- Recommended software for PC: latest version of Adobe InDesign
- Recommended software for Mac OS: latest version of Adobe InDesign
- Download the BETA version through your Creative Cloud to access the AI features
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/2b2ecc37-a2c0-43e3-8d3f-34cc07acbc37" class="js-course-brochure u-display-none">Course Brochure</a>
View Adobe InDesign Course: Level 1 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis short course focuses on the more advanced features beyond the Microsoft Excel Course: Level 2. You’ll learn how to use Power Query to transform and link to external data, and data consolidation to combine data. The course also includes list analysis tools, summarising and subtotalling, PivotTables, using Power Pivot to create PivotTables based on multiple sources, and how to create a report dashboard with PivotTables, charts and slicers to filter reports.
Additionally, we’ll cover Lookup Functions XLOOKUP, INDEX, XMATCH and FILTER and their differences, key automation features like macros and controls (scrollbars and buttons) for easier data entry, and planning and budgeting tools from the What If analysis group. Finally, validating data to prompt and check for correct data is covered; and hints and tips chapter.
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 experienced Excel users with proficient skills in developing more complex formulas, list analysis using a variety of tools and creating simple macros as well as features and tips to assist efficiency.
By the end of this course, you should be able to:
- modify Excel options
- import data into Excel using Power Query
- use Power Query to transform and link to data
- use data linking to create more efficient workbooks
- create summaries in your workbooks using subtotals
- use a range of lookup functions
- use the Data Consolidation feature to combine data from several workbooks into one
- create, use and modify data tables
- create and work with scenarios and the Scenario Manager
- construct and operate Pivot Tables using some of the more advanced techniques
- create and edit a Pivot Chart
- use Power Pivot to create summary reports from separate lists with a Pivot Chart and Slicer
- use PowerPivot to summarise data from multiple sources
- use a variety of Data validation techniques
- create and use a range of controls in a worksheet
- create recorded macros in Excel.
Set Excel options
- Understand and personalise Excel options
- Understand and set save options
- Default local file location
- Set number of recent workbooks
- Set number of pinned workbooks
Import & Link to External Data
- Understand Data Importing
- Understand Text File Formats
- Import Data from a Picture
- Import Data from a Text File using Power Query
- Edit a Query
- Refresh Data
- Unlink Connections
- Transform Data using Power Query
Data Consolidation – Combining Data
- Understanding data consolidation
- Combining data from multiple sources
Summarise & Subtotal Lists
- Creating Subtotals
- Using a Subtotalled Worksheet
- Creating Nested Subtotals
- Copying Subtotals
- Using Subtotals with AutoFilter
PivotTable features
- Create a PivotTable (refresher)
- Display Percentage of Total
- Changing the Calculation in a PivotTable
- Creating and deleting Calculated Fields
- Creating and deleting Calculated Items
- Rename PivotTable Fields
- PivotTable Options
- Instant PivotTable Reports
- Refreshing PivotTables
PivotTable Dashboard
- What is a Dashboard?
- Dashboard Elements
- Understanding Slicers
- Inserting a Slicer
- Formatting a Slicer
- Inserting a Timeline
- Connecting a Slicer to Multiple PivotTable Reports
- Connecting a Timeline to Multiple PivotTable Reports
- Create a PivotChart
Power Pivot
- Power Pivot – Overview
- Understanding the Data Model
- Enabling Power Pivot
- Insert a Power Pivot report from multiple tables
- Insert a Pivot Table using the Data Model
Lookup Functions
- XLOOKUP
- INDEX
- XMATCH
- FILTER
Validating Data
- Understanding Data Validation
- Creating a Number Range Validation
- Creating an Input Message
- Creating an Error Alert
- Creating a Drop Down List
- Using Formulas as Validation Criteria
- Circling Invalid Data
- Removing Invalid Circles
- Copying Validation Setting
Data Tables – A What If Analysis Tool
- Understanding Data Tables and What-If Models
- Using a Simple What-If Model
- Creating a One-Variable Data Table
- Using One-Variable Data Tables
- Creating a Two-Variable Data Table
Controls
- Understanding Types of Controls
- Preparing for Simple Checkboxes
- Inserting a Simple Checkbox
- Count Checkboxes
- Adding a Scrollbar Control
- Changing Control Properties
- Using the Cell Link to Display the Selection
- Protecting a Worksheet with Controls
Recorded Macros – Automate Repetitive Actions
- Understanding Excel Macros
- Setting Macro Security
- Saving a Macro Enabled Workbook
- Displaying the Developer tab
- Relative Cell References
- Recording a Simple Macro
- Running a Recorded Macro
- Viewing a macro
- Editing a Macro
- Assigning a Macro to a Control Button
- Assigning a Keyboard Shortcut to a Macro
- Deleting a Macro
Scenarios – A What If Analysis Tool (optional topic)
- Understanding Scenarios
- Preparing for Scenarios – Creating Range Names
- Creating a Default Scenario
- Creating Scenarios
- Displaying Scenarios
- Creating a Scenario Summary Report
- Managing Scenarios – edit, merge and delete
Hints and tips (optional topic)
- Focus Cell
- Navigation Pane
- Check Performance
- Picture in cell
- Copying pictures in cell
- Using lookup formulas with pictures
Assumes an intermediate level understanding of the software and experience in the construction and modification of workbooks. It is designed for those who are ready to explore more of the advanced analysis and automation tools.
Participants should have already completed the Excel Level 1 and Excel Level 2 courses or have Excel skills up to the Level 2 (intermediate) course.
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 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/9b970651-0d5d-41cb-aa0b-ea8fae2abf20" class="js-course-brochure u-display-none">Course Brochure</a>
View Microsoft Excel Course: Level 3 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis two-day Adobe After Effects training course is designed to help those new to motion graphics get the most out of this immensely powerful software. Whether you're a graphic designer, web designer, rich media artist or broadcast video editor, Adobe After Effects will help you create stunning broadcast quality motion graphics and visual effects.
Your own Adobe Creative Cloud account is required for this course. You will also need your own device. For further details, see 'Before the course'.
After Effects Interface
- Workspace
- Panels
- Tools panel
New Project
- Start a New Project
- Importing Footage and Organising Media
- Importing Adobe Photoshop and Illustrator files
- Layer Import Options
- Replace Footage with a Layered Composition
- Preparing Illustrator files
Building Compositions
- Create a New Composition
- New Composition from an existing file
- Composition Settings
- Layer Properties in the Timeline Panel
- Trim or Extend a Layer
- Split Layers
Creating Animations
- Keyframe Animation
- Anchor Point
- Aligning
- Auto Orientate
- Roving keyframes
- Adjustment Layers
- Parenting
- Precompose
- Nesting
Create Text
- Creating Titles
- Character and Paragraph Settings
- Text Animation Presets
- Adjust Text Animator Properties
- Source Text Animation
- Text on a Path
Create Shapes
- Create a Shape
- Shape Layer Properties
- Animating Shapes
- Trim Paths
- Repeater
Motion Tracking
- Motion Tracking Overview
- Track Motion
- Null Object
- Motion Tracker Settings
Effects and Presets
- Browse Effects & Presets
- Warp Stabilizer
- Motion Tile Effect
- Radio Waves Effect
- Puppet Tool
- Motion Sketch
- Content-Aware Fill
- Speed Change
Colour Correction and Grading
- Basic Correction
- Creative
- RGB Curves
- Hue Saturation Curves
- Colour Wheels
- Secondary Colour Corrector
Masking, Transparency and Keying
- Masking
- Tracking a Mask
- Keying
- Opacity and Blending Modes
- Track Matte
- Roto Brush & Refine Edge Tools
Introduction to 3D
- Working with 3D Layers
- Cameras
- Move the Camera through a Scene
- Lights & Shadows
Save and Export
- Save and Export
- Adobe Media Encoder
Suitable for anyone wanting to fast track themselves with motion graphics techniques.
This introductory course assumes little or no prior knowledge of the software. While previous experience with Adobe Photoshop and Adobe Illustrator is not mandatory, it can be beneficial since some functions and concepts overlap between these programs and After Effects.
Delivery mode
- Face-to-face, presenter-taught training using your own device
- Online training via the platform Zoom
Face-to-face classes
These classes run in a classroom and you will need to bring your own device with Adobe After Effects installed. You should 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.
Online classes
You will need your own device with Adobe After Effects installed. We also recommend using a computer with a larger screen, or two screens/devices. A small laptop screen provides limited space, and it can be difficult to manage following the facilitator’s screen and using your own software.
Course materials are provided electronically using Dropbox.
Before the course
You will need an Adobe Creative Cloud account to participate. If you don't have an existing account, you can purchase an Adobe Creative Cloud account here. Please bring your account login details with you to class.
- Recommended operating system: Windows or Mac
- Recommended software for PC: latest version of Adobe After Effect
- Recommended software for Mac OS: latest version of Adobe After Effects
- Download the BETA version through your Creative Cloud to access the AI features
- Please also download Adobe Illustrator and Adobe Photoshop from your Adobe Creative Cloud Installer, so you can open the course file types.
Additional information
Adobe product box shot(s) reprinted with permission from Adobe Systems Incorporated. Adobe After Effects® are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/81742099-b4fd-41ea-9f19-684e25d03223" class="js-course-brochure u-display-none">Course Brochure</a>
View Adobe After Effects Course: Level 1 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis introductory course is suitable for those with little or no prior understanding of relational databases (Microsoft Access, Oracle Database, Microsoft SQL Server, MySQL etc), those who would like to get more value from attending SQL Course Level 2a training, or who want to demystify relational database management systems.
There is a developing trend in business for non-IT people to understand and use SQL (Structured Query Language) to query relational database management systems. For many years CCE has offered several courses that teach SQL. The content and pace of these SQL courses were tuned to the historical participants, principally IT professionals, who came into the course with a particular skill level that was understandably not present in most business people. Business people new to databases (how they actually work and why they are designed in particular ways) need to grasp some basic database concepts before tackling the intricacies of SQL.
The principles taught are common to all relational database management systems. For the purposes of this training course, Microsoft SQL Server and Microsoft SQL Server Management Studio will be used to illustrate the content of the course.
We encourage you to use the CCE SQL level self-assessment tool if you are unsure which course level to enrol in.
By the end of this course, you should be able to:
- recognise elements of good and bad database design relevant to SQL and apply those elements when designing a database
- interpret database structures to determine the SQL required to reslove queries
- choose appropriate clauses to write an SQL query
- write SQL queries to answer specific questions
- read SQL queries to determine the result sets produced.
- Rationalise the purpose of Relational Database Management Systems and their role in information systems
- Interpret the narratives that define business rules that form the basis of a databases design
- Simplify business rules to enable database design and the interpretation of database design when answering questions with SQL
- Resolve the metaphor used in relational database management systems and thus SQL
- Discuss the principles of a normalised database that store facts in a single place and the method used to relate facts
- Name and discover the natural cardinalities in a given business narrative
- The create an ERD (Entity Relationship Diagram) for the design of a database using its symbols and their meaning that express those cardinalities to capture business rules using primary keys and foreign keys, constraints and datatypes to enforce cardinalities
- Implement a database design in SQL from an ERD creating tables, columns and relationships
- Use Structured Query Language (SQL) to:
- build a result set from one table
- alias columns in the result set
- derive columns in the result set with arithmetic, intrinsic functions and concatenation
- cull records from a result set with WHERE clause boolean predicates
- involve multiple boolean predicates in the WHERE clause with the logical operators AND and OR using their operator precedence and brackets
- sort result sets with the ORDER BY clause and nested sort orders
- state the purpose of statements and clauses, specifically a SELECT statement, SELECT clause, FROM clause, WHERE clause and ORDER BY clause
- read a statement using the SQL elements above stating what each clause consumes and produces, and the order in which the clauses execute.
Suitable for those with little to no prior understanding of relational database management.
If you are a business person or an IT professional who is not completely comfortable with relational database concepts, you should complete this course prior to attending SQL Course: Level 2a training.
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 and you do not need to bring your own device.
Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.
Online classes
You will need your own device. If you are using a Mac, you will need Windows installed alongside MacOS so that you can run the SQL Server on your computer. CCE staff will not be able to assist you with setting up a Windows environment.
An SQL Server Installation Guide (Pdf) will be emailed to you before class.
Course materials are distributed electronically using Dropbox.
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/e0819044-debe-45df-bbbf-fe9862615936" class="js-course-brochure u-display-none">Course Brochure</a>
View SQL Course: Level 1 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listPython is one of the most in-demand technical skills and one of the easiest programming languages to learn. With a syntax similar to the English language, Python is perfect for beginners. It has numerous applications, from website development to big data analytics and visualisation.
This course covers the fundamentals of Python syntax and general computer programming. It does not cover data analytics and visualisation with Python. After familiarity with topics in this 1A course, participants will be prepared for the Python Programming Course: Level 1B, which dives deep into data programming with Python. We recommend enrolling in both courses to gain entry-level skills. Enrolment in both courses is not compulsory.
Please use the CCE Python self-assessment tool if you are unsure which course level to enrol in.
Please ensure Anaconda Python is installed on your device before class. For further details, see 'Before the course'.
This course aims to teach basic programming skills using Python, including variable types, operations, user input/output, logic, loops and functions.
By the end of this course, you should be able to:
- install Python and additional packages (via Anaconda)
- understand the difference between Python and Anaconda
- find and read documentation for Python libraries and functions
- use Jupyter Notebook to write and run Python code
- work with basic Python data types (string, float, integer, etc)
- work with basic Python collections (list, dictionary, tuple, etc)
- write Python expressions that involve variables, variable assignment, operators, functions
- understand the basics of object oriented programming
- use conditionals and loops
- fix coding errors
- read csv data files into Python using the Pandas package.
- Introduction to programming
- Introduction to Python, Anaconda and Jupyter Notebook
- Finding, installing and loading Python libraries/packages
- Variables and data types
- Writing expressions
- Collections (lists, tuples, and dictionaries)
- Debugging
- Using logic, conditionals and loops
- Creating functions
- Finding and reading documentation
- Basic exposure to object oriented programming
- Reading csv files using pandas package
Suitable for professionals, students, academics and members of the public who want to learn programming foundations.
It is assumed you have computer and data literacy knowledge to the level of performing basic data analysis tasks in Excel, i.e. basic (high school) algebra, percentages, probability, averages. No prior programming experience is required.
Delivery modes
- Face-to-face, presenter-taught training using your own device
- Online training via the platform Zoom
Face-to-face classes
These classes run in a classroom, and you need to bring your own device with Anaconda Python installed. You should 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.
Online classes
You will need your own device with Anaconda Python installed.
Training materials, including a mixture of step-by-step instructions, examples and exercises are provided electronically using Dropbox. These materials will serve as a useful reference when working with Python in future.
Before the course
Anaconda Python Version 3.x is required and should be downloaded free of charge from Anaconda before class. A detailed download guide is provided after course registration.
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/53b1ffa0-ffa7-4acc-b13b-0c88a0b46bf9" class="js-course-brochure u-display-none">Course Brochure</a>
View Python Programming Course: Level 1A detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis two-day Adobe Premiere Pro training course covers all of the fundamental and comprehensive methods, tools and techniques needed to enable you to get your video message across.
Your own Adobe Creative Cloud account is required for this course. You will also need your own device. For further details, see 'Before the course'.
Premiere Pro Interface
- Introduction
- Workflow at a glance
- Home Screen
- Workspace
- Panels
- Tools
New Project
- Start a New Project
- Importing Media
- Organizing Media
- Prepare your Footage
- Timeline
- Create a Sequence
- Insert
- Overwrite
- Re-arrange Clips in the Timeline
- Program Panel Overlay
Video Editing Essentials
- Selection Tool
- Ripple Tool
- Roll Tool
- Razor Tool
- Slip Tool
- Slide Tool
Markers
- Working with Markers
- Automate to the Sequence
Effects and Transitions
- Video Transitions
- Video Effects
- Copy and Paste Attributes
- Adjustment Layers
Titles and Graphics
- Creating Titles
- Essential graphics panel:
- Create a Graphic:
- Animating graphics
Colour Correction and Grading
- Basic Correction
- Creative
- RGB Curves
- Hue Saturation Curves
- Colour Wheels
- Colour Match and Comparison View
- Vignette
Audio Essentials
- Adjusting Audio Clip Volume
- Normalize Loudness Level
- Essential Sound Panel
- Reduce Noise
- Audio Track Mixer
- Audio Clip Mixer
- Record Voice-over
Transparency, Masking and Keying
- Opacity and Blending Modes
- Masking
- Tracking a Mask
- Keying
Multi-Camera Editing
- Multi-camera Editing
- Create a Multi-Camera Sequence
- Edit the Multi-Camera Source Sequence
- Refine the edits using the Roll Tool
Motion and Speed
- Keyframe Animation
- Long Reef Beach Animation Exercise
- Speed Change
Save and Export
- Save and Share
- Adobe Media Encoder
Suitable for new or existing Adobe Premiere Pro users and anyone wanting to fast track themselves with video editing techniques and essential functions.
None
Delivery modes
- Face-to-face, presenter-taught training using your own device
- Online training via the platform Zoom
Face-to-face classes
These classes run in a classroom and you will need to bring your own device with Adobe Premiere Pro installed. You should 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.
Online classes
You will need your own device with Adobe Premiere Pro installed. We also recommend using a computer with a larger screen, or two screens/devices. A small laptop screen provides limited space, and it can be difficult to manage following the facilitator’s screen and using your own software.
Course materials are provided electronically using Dropbox.
Before the course
You will need an Adobe Creative Cloud account to participate. If you don't have an existing account, you can purchase an Adobe Creative Cloud account here. Please bring your account login details with you to class.
- Recommended operating system: Windows or Mac
- Recommended software for PC: latest version of Adobe Premiere Pro
- Recommended software for Mac OS: latest version of Adobe Premiere Pro
- Download the BETA version through your Creative Cloud to access the AI features
<a href="https://ish-oncourse-cce-main.s3.ap-southeast-2.amazonaws.com/362f0b57-f0df-4aeb-9e6a-eb187e9fcd2b" class="js-course-brochure u-display-none">Course Brochure</a>
View Adobe Premiere Pro Course: Level 1 detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting listThis intermediate Power BI course will expand on your knowledge and skills, showing you how to create more complex data models, which in turn will result in enhanced visuals and more interactive dashboards.
Using custom slicers, defined functions and calculated measures we'll move beyond the basics and build your confidence in connecting, cleansing, and presenting your data in a variety of enriched and valuable formats.
You'll also learn the language behind Power Query – allowing you to engineer more complex queries and extract results from a variety of data sources.
Finally – it's important that shared reports are both flexible and secure. We will show you options for sharing and collaborating on dashboards and reports with stakeholders securely via the Power BI cloud Service.
We want to elevate your dashboards and take your reports to the next level with custom visuals and data transformations from multiple sources; including files stored in SharePoint document libraries. You will also learn to protect and secure the business intelligence that you build, analyse and share with your colleagues.
By the end of this course, you should be able to:
- understand procedures and best practices related to data acquisition and transformations
- create and work with custom DAX hierarchies
- comprehend necessity and procedure for creating a date dimension table
- write and work with DAX lookup functions
- create more efficient DAX measures, including iterator functions
- work with aggregations
- work with Custom Visuals to gain BI insights
- work with the Power BI service to share datasets and reports
- embed reports in SharePoint
- embed reports in MS Teams
- publish and export reports in different formats including CSV, PDF & XLSX.
Getting Data and Key Transform Mechanisms
- Accessing Various Data Sources including individual files in SharePoint and entire SharePoint Folders
- Profiling and Error Checking Columns
- Key Transformations with Power Query Editor
- Normalising Flat Files
- Merge Queries
- Append Queries including combine PC and SharePoint Folder files
- Pivot and UnPivot Columns
Calculated Columns and Measures
- Create and work with Custom DAX Hierarchies, and compare drilldown, drill-through and sync slicers
- Default Summarisation compared to DAX Measures
- Create improved DAX Measures including iterator functions such as SUMX, COUNTX
Date Dimension Table
- Create a static and a dynamic Date Table using DAX CALENDAR
- Create a dynamic Date Table for fiscal year using DAX CALENDARAUTO
- Create calendar and fiscal year hierarchies
- Implement and work with Date table hierarchies within visuals, including sort month text by month number
Working with Custom Visuals
- Import Custom Visuals
- Work with Custom Slicers
- The Q & A Visual
- Key influencer visual
- Decomposition Tree Visual
- Pin a live report as a dashboard
Sharing Reports Securely using the Power BI Service
- What is a Workspace?
- Creating a Workspace
- Assign Workspace roles
- Creating and Sharing a Dashboard
- The Power BI Service Portal
- Creating and Sharing a Dashboard
- Sharing Our Report Internally
- Sharing Our Reports Externally
- Manage Permissions to a Report
- Sharing Dashboards
- Sharing Datasets
- Publish Shared Datasets as Apps
- Embed a Report in MS Teams
- Publish and Export Reports
- Embed Reports in SharePoint
Anyone interested in data visualisation.
It is recommended that you are comfortable with the learning outcomes equivalent to our Power BI Course: Introduction.
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 venue including PARKROYAL, Cliftons and CBD)
These classes 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 is 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.
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.
View Power BI Course: Intermediate detailsWaitlistJoin the waiting list to be notified when a new class becomes available.Join the waiting list
