Location
(171)
(1)
(10)
Delivery mode
    • (121)
    • (143)
    • (3)
Course length
(132)
(37)
(2)
(44)
Date

Microsoft Excel Course: Level 2

Course Information

Microsoft Excel. Unlock insights and tell the story in your data.

This 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.

Aims

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.

Outcomes

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.

Content

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

Protecting Your Work

  • About Protection
  • Preparing Cells for Data Entry
  • Protect Sheet
  • Unprotect Sheet
  • Protect Workbook Structure
  • Unprotect Workbook Structure
  • Protect File
  • Unprotect File

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

Intended audience

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.

Prerequisites

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

Delivery style

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.

Materials

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, 365
Recommended software for Mac OS: MS Excel 2016, 2019, 365
Recommended browser: Chrome

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.

Schedule

Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Fri 2 May 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Mon 26 May 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Thu 26 Jun 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Mon 7 Jul 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Tue 5 Aug 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 27 Aug 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 24 Sep 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Thu 2 Oct 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 22 Oct 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Tue 18 Nov 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Tue 16 Dec 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 2 Apr 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
2025-04-15 Tue 15 Apr 2025 2025-04-15 9:30am - 4:30pm 9:30am - 4:30pm (UTC+10:00)
1 session, 7 hours total
$465 Limited GST free / $50
Online via Zoom
Tue 15 Apr 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 14 May 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 11 Jun 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Thu 17 Jul 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Mon 18 Aug 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Tue 9 Sep 2025
9:30am - 4:30pm (UTC+10:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Fri 10 Oct 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Mon 3 Nov 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Wed 3 Dec 2025
9:30am - 4:30pm (UTC+11:00)
Microsoft Excel Course: Level 2

<p>{block name:"Course Tagline - Microsoft Excel"}</p>

<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft Excel: Level 1</a> and provide you with the

...
Course added to cart. Checkout now.
Close this message
Fri 21 Mar 2025
9:30am - 4:30pm (UTC+11:00)
Waitlist
Join the waiting list to be notified when a new class becomes available.
Join the waiting list

Meet the facilitators

Cathy is a dedicated professional with over 30 years of experience in delivering training in Microsoft applications. Her extensive background includes working with clients from various sectors,...

Danish is an experienced professional with 20 years of experience in training, consulting, finance, project management and engineering. He has worked in organisations including Siemens, Shell,...

Denise Tsagaris is a highly experienced trainer and consultant with over 25 years of expertise in instructing Microsoft applications, spanning from fundamental to advanced levels. Throughout her...

Mandy is an IT professional with over 30 years of experience in delivering transformational technology training services across a broad range of industries. Her expertise lies in curriculum...

What others say

Blog

Frequently asked questions
Find answers to questions about applications, payment, short courses and more.
See FAQs
Contact us
Our student support team can answer your questions about our short courses.
Get in touch
We use cookies to improve your experience on our site and to show you personalised content. For more information about how we use cookies, please read our Privacy Statement.