Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2019 Powerful New Features

Course Outline

Excel is one of the most widely used and powerful tools for manipulating and analysing data, but traditional Excel has some real limitations: it can be very time-consuming importing and cleaning data; Excel can only fit a million rows; and while pivot tables are a great analysis tool they can only get data from a single flattened table and the calculations they perform are very limited. With the new power tools that has all changed! In this advanced course we introduce Power Query for automating the process of getting and transforming data, Power Pivot for building related data models able to contain millions of rows and DAX functions which allow us to perform sophisticated analyses in our Pivots. Prerequisites: This course is suitable for confident excel users (ideally work comfortably with VLOOKUPS and Pivot tables) and will require a Windows machine (not Mac) running Excel 2016 or later. Power Query for Getting Data • Get data from Excel • Get data from other sources • Get data from a folder Power Query for Combining Data Sets • Append queries • Understand merge query options • Perform a range of merge queries Power Query and M for Transforming Data • Fill in the blanks • Remove unwanted columns and rows • Remove duplicates • Merge, Split and add columns • Pivot and Unpivot data Power Pivot • What is Power Pivot and how to enable it • Add data to the Data Model • Create a Calendar table • Add Relationships DAX • Introduction to DAX (Data Analysis Expressions) • Create calculated columns using DAX • Create simple measures using DAX • Create Pivot tables using the data model and DAX measures Data Visualisation • Add Conditional Formatting to Pivot tables • Create Pivot Charts • Add slicers and link to multiple pivot charts • Convert Pivot Tables to OLAP cubes for more visualisation options • Use visualisations to create a dashboard

Confident keyboarding skills and Excel Intermediate course or equivalent skills and knowledge. For the Powerful new Features course students will need 2016 or later (not the free online version).


This course will be delivered using virtual classroom via Zoom in Term 3 2021.

Zoom is easy to use video conferencing software with a simple set up. You will be able to see your trainer and classmates and interact as though you were in the same room, all from the comfort of your own home!

This is what you need to join a Zoom classroom:

. Understanding the basics of using Zoom – see our free Zoom tutorial by clicking here. . Access to a computer, iPad/tablet or smartphone; and . A webcam* so that you can be seen by the trainer; and . A microphone* so that you can participate in the class and be heard by the trainer; and . A good Internet connection.

*Please note if you have a laptop computer a webcam and microphone are usually built into the top of the screen frame. Smartphones and iPad/tablets also contain cameras and microphones.

Once you have watched our free tutorial and experimented with Zoom, if you still have questions, we are offering free Q & A Zoom sessions with one of our experienced trainers. Please contact the office on 9970 1000 or email enquiries for further details.

Using Zoom for Computer Classes

Please paste this link into your browser for further information on how to use Zoom for computer students.

This video demonstrates how you can use two screens or split your computer screen if you are attending one of our computer / software application courses.

How to enrol

You can enrol online and over the phone using a credit card


If you have been impacted by the COVID-19 lockdown OR meet other eligibility criteria, this course may be fully funded under the NSW Government's Adult & Community Education funding. "See ACE Community Service Obligation Funding page":/cso_funding for details or contact Susan Wilkinson on 9970 1000 or email to check eligibility or for further information.

$136 Limited GST free / $122.40
Excel 2019 Powerful New Features

<h2>Course Outline</h2>

<p>Excel is one of the most widely used and powerful tools for manipulating and analysing data, but traditional Excel has some real limitations: it can be very time-consuming

If you have been impacted by the COVID-19 lockdown and wish to apply for a funded position in this course, please email Susan Wilkinson at or phone her on 9970 1000.

If there isn't a class to suit you, please the waiting list.

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113