Microsoft Excel Course: Level 2
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
- Split windows
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
- Logical functions – AND, OR
- 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
- Copying a Sheet to Another Workbook
- Grouping Worksheets Protecting Your Work
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 Tools
- Display Quick Analysis button
- Create Totals
- Create a Chart
Goal Seeking
- About Goal Seek
- Use Goal Seek
Chart Elements
- Add Chart Elements
- Edit Chart Elements
- Data Labels and Data Tables
- Trendlines
- Error Bars
- Chart Style and Colour
- Pie Chart – Explode Slice
- 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. 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.
Features
- $50 repeat class - Conditions apply
- Expert trainer
- Small class size
- CCE Statement of Completion
- There's no block with the name: Course Meta Content - Microsoft Excel Course - Level 2 - MSE2
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Tue 2 Apr 2024 | 9:30am - 4:30pm (UTC+11:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 15 Apr 2024 | 9:30am - 4:30pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 29 Apr 2024 | 9:30am - 4:30pm (UTC+10:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 13 May 2024 | 9:30am - 4:30pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 27 May 2024 | 9:30am - 4:30pm (UTC+10:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Tue 11 Jun 2024 | 9:30am - 4:30pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 24 Jun 2024 | 9:30am - 4:30pm (UTC+10:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<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
...When | Time | Where | Session Notes |
---|---|---|---|
Wed 20 Mar 2024 | 9:30am - 4:30pm (UTC+11:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
If there isn't a class to suit you, please join the waiting list.
Related content. Further your learning.
- Related Courses
- Microsoft Excel Course: Level 1
- Microsoft Excel Course: Level 3
- Microsoft Excel VBA Course: Introduction
- Microsoft Excel VBA Course: Masterclass
- Microsoft PowerPoint Course: Level 2
- Microsoft Word Course: Level 2
- Power BI Business Analytics Course
- Power BI Course: Level 1
- Power BI Course: Level 2B
- Power BI Essentials Course for End Users
What others say.
- The facilitator was great - very patient, and clear with instructions, particularly for a person like me who isn't computer savvy. Plus really helpful.
- Our tutor was brilliant and even helped me figure out a question after the course, which will help me so much at work. I was very pleased with the way the course was conducted with everything explained thoroughly and then reconfirmed what we had learnt. It was wonderful to be in a class taught so well and I will definitely come back to another course.
- The tutor was entertaining and knowledgeable. I learned so much in this course. I have also realised how many HOURS of my life I have wasted in not knowing so many of the efficiencies and tools available within Excel. Mind blown! Thankyou!!!