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 efficiency.
Outcomes
By the end of this course, you should be able to:
- use the fill operations available to fill a data series
- use a range of techniques to work with worksheets
- protect data in worksheets and workbooks
- use common worksheet functions
- understand and create simple PivotTables
- create more complex formulas and functions
- apply a range of number formatting techniques to worksheet cells
- apply conditional formatting to ranges in a worksheet
- use goal seeking to determine the values required to reach a desired result
- understand and use Excel's Quick Analysis tools
- create and work with tables
- use a range of elements and features to enhance charts
- select and change the format of objects in a chart.
Content
Filling Data
- Creating a Custom Fill List
- Modifying a Custom Fill List
- Deleting a Custom Fill List
- Extracting With Flash Fill
- More Complex Flash Fill Extractions
- Extracting Dates and Numbers
Worksheet Techniques
- Hiding a Worksheet
- Unhiding a Worksheet
- Copying a Sheet to Another Workbook
- Changing Worksheet Tab Colours
- Grouping Worksheets
- Hiding Rows and Columns
- Unhiding Rows and Columns
- Freezing Rows and Columns
- Splitting Windows
Protecting Data
- Understanding Data Protection
- Providing Total Access to Cells
- Protecting a Worksheet
- Working With a Protected Worksheet
- Disabling Worksheet Protection
- Providing Restricted Access to Cells
- Password Protecting a Workbook
- Opening a Password Protected Workbook
- Removing a Password From a Workbook
Essential Functions
- Key Worksheet Functions
- Using IF With Text
- Using IF With Numbers
- Nesting IF Functions
- The LOOKUP Function
- Using Counting Functions
- The Round Function
- Rounding Up and Rounding Down
- Manipulative Functions
- The MOD Function
- The TODAY Function
- The NOW Function
- The DATE Function
- Using VLOOKUP
- Using VLOOKUP for Exact Matches
- Using HLOOKUP
PivotTables
- Understanding PivotTables
- Recommended PivotTables
- Creating Your Own PivotTable
- Defining the PivotTable Structure
- Filtering a PivotTable
- Clearing a Report Filter
- Switching PivotTable Fields
- Formatting a PivotTable
Complex Formulas
- Scoping a Formula
- Long-Hand Formulas
- Preparing for Complex Formulas
- Creating the Base Formula
- Adding More Operations
- Editing a Complex Formula
- Adding More Complexity
- Copying Nested Functions
- Switching to Manual Recalculation
- Pasting Values From Formulas
- Documenting Formulas
Number Formatting Techniques
- Applying Alternate Currencies
- Applying Alternate Date Formats
- Formatting Clock Time
- Formatting Calculated Time
- Understanding Number Formatting
- Understanding Format Codes
- Creating Descriptive Custom Formats
- Custom Formatting Large Numbers
- Custom Formatting for Fractions
- Padding Numbers Using Custom Formatting
- Aligning Numbers Using Custom Formats
- Customising the Display of Negative Values
Conditional Formatting
- Understanding Conditional Formatting
- Formatting Cells Containing Values
- Clearing Conditional Formatting
- More Cell Formatting Options
- Top Ten Items
- More Top and Bottom Formatting Options
- Working With Data Bars
- Working With Colour Scales
- Working With Icon Sets
- Understanding Sparklines
- Creating Sparklines
- Editing Sparklines
Goal Seeking
- Understanding Goal Seeking
- Using Goal Seek
The Quick Analysis Tools
- Understanding Quick Analysis
- Quick Formatting
- Quick Charting
- Quick Totals
- Quick Sparklines
- Quick Tables
Worksheet Tables
- Understanding Tables
- Creating a Table From Scratch
- Working With Table Styles
- Inserting Table Columns
- Removing Table Columns
- Converting a Table to a Range
- Creating a Table From Data
- Inserting or Deleting Table Records
- Removing Duplicates
- Sorting Tables
- Filtering Tables
- Renaming a Table
- Splitting a Table
- Deleting a Table
Chart Elements
- Understanding Chart Elements
- Adding a Chart Title
- Adding Axes Titles
- Repositioning the Legend
- Showing Data Labels
- Showing Gridlines
- Formatting the Chart Area
- Adding a Trendline
- Adding Error Bars
- Adding a Data Table
Chart Object Formatting
- Understanding Chart Formatting
- Selecting Chart Objects
- Using Shape Styles
- Changing Column Colour Schemes
- Changing the Colour of a Series
- Changing Line Chart Colours
- Using Shape Effects
- Colouring the Chart Background
- Understanding the Format Pane
- Using the Format Pane
- Exploding Pie Slices
- Changing Individual Bar Colours
- Formatting Text
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 the 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
You will be provided with a link to access and download your own personalised eBook prior to class.
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
What others say.
The course content was delivered at a good pace, the tutor was very observant and accommodating, making sure that everyone was able to follow.
A very knowledgeable and clearly very experienced instructor – despite the class members having different levels of skills and coming from different work backgrounds, the training accommodated all of our needs very well. I never thought I’d say that an Excel course could be enjoyable – but it was!
Very professional, enjoyable and with an excellent tutor... P.S. Definitely coming back to do some other courses there.
We had a fabulous tutor who ensured the course met each of our expectations by asking us all at the commencement of the day what we wanted to get out of the course. All of our requirements were met and I am looking forward to putting into practice everything I learnt on Saturday!
I attended the Excel Level 2 Course, and I was so impressed with the trainer. I’ve been in IT for 30 years and have attended many courses. This tutor so far has been the best trainer I have had and really knows the product, and cares that all participants understand the content.
The teacher was great and was highly informative, and able to speak in simple language. I personally felt this tutor was extremely competent.
I found the course extremely good. Not only did I learn new ways to do things in Excel I also learnt quicker and more efficient ways to create formulas, tables, pivot tables, charts, etc. The instructor was excellent and the course well paced. I have already recommended this course to colleagues and am booked into Excel Level 3.
The facilitator was great – very patient, and clear with instructions, particularly for a person like me who isn’t computer savvy. Plus really helpful.
This is honestly one of the best courses I have been to. Relevant, engaging, interesting and will really change vital tasks and increase efficiency at work. The teaching was straight forward, entertaining and perfectly suited to the level of the attendees. The best tutor, I couldn’t recommend highly enough. I learned more today than in years of using Excel.
The course challenged my thinking and helped ease my mind about a few Excel tasks that I have long felt daunted by. Not daunted any longer mainly due to the tutors intelligent and crisp presentation style, who seemed to gauge the level of our Excel skills and tailored the presentation accordingly. I walked away with a bagful of resources and a lot more confidence in my new found Excel abilities. Thank you from a 55 year old who is looking forward to my next course.
We had a very good and personable teacher who was able to cover a lot of content without leaving any student unsure or confused, assisting them along the way if need be. I feel this way of teaching was really understandable and I thoroughly enjoyed the class that day.
It was a great class. Easy for everyone to keep up with. Our teacher was very clear and made sure we all understood before moving onto something new, whilst still sticking to the schedule.
Great class. I learnt a lot, the tutor was very knowledgeable about Excel and made sure that everyone was on the same page and understood the content before moving on to the next topic.
The tutor was fantastic. Obviously very knowledgeable and has a great manner for teaching people with such a variation in Excel skills.
Course was pitched at exactly the right level so I personally got a lot out of it – looking forward to following up with Level 3 in a few weeks. Very happy with the training materials so I can refresh when required. Would highly recommend to colleagues.
Great course with fantastic and enthusiastic instructor. Would definitely recommend and take another course!
We had a very good tutor who had excellent knowledge of Excel and was able to explain all concepts clearly and in terms that were understandable to the class – and also seemed to be very kind and non-intimidating. Was very impressed with the tutor. The concepts covered in class and the facilities were also excellent – overall I was very happy with the course.
The course information booklets and USB are great resources and the practice sessions inside are valuable. The tutor was very clear with the explanation of things and was happy to assist individuals with their own queries.
The tutor was wonderful; experienced, educative, approachable and knowledgeable – and kept us working all day at a pace that worked for the whole class and covered more than just the course material.
Course was really good. Great pace and good amount of content that was reflective of the course overview.
The tutor was very good, teaching the content in the book and going beyond by giving us shortcut keys and skills learnt from work experiences. A very articulate presentation and taught at a good pace.
A fantastic tutor who remained both engaging and persistent with the teaching approach. This course should better allow me to practice and implement Excel techniques in a financial work environment.
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.
Our tutor was extremely knowledgeable and helpful. I would recommend the Excel Level 2 course to anyone wanting to improve their efficiency in working with Excel. As a previously self-taught Excel user, the course filled the gaps in my knowledge and provided practical information and skills which I can use every day.
I felt the tutor was an excellent presenter, was very informative and went out of their way to answer questions to ensure everyone had the correct understanding.
Overview
Sessions:
Location:
Price:
Class schedule
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Wed 27 Sep 2023
9:30am - 4:30pm (UTC+10:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Thu 19 Oct 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Mon 30 Oct 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Tue 14 Nov 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Wed 29 Nov 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Tue 19 Dec 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Fri 12 Jan 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Tue 6 Feb 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Tue 5 Mar 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Wed 20 Mar 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Fri 6 Oct 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Tue 5 Dec 2023
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Wed 24 Jan 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Mon 19 Feb 2024
9:30am - 4:30pm (UTC+11:00)
<p>{block name:"Course Tagline - Microsoft Excel"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">Microsoft
...Thu 14 Mar 2024
9:30am - 4:30pm (UTC+11:00)
If there isn't a class to suit your preferred time or delivery format, please JOIN the waiting list.
Featured facilitators
Cathy Jackson
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,...
Denise Tsagaris
Denise Tsagaris is a highly experienced trainer and consultant with more than 25 years' experience in teaching Microsoft applications from basic to advanced levels. Denise has delivered training...
Mandy Vyner
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
The course content was delivered at a good pace, the tutor was very observant and accommodating, making sure that everyone was able to follow.
- Heike Obermayr
An amazing teacher. I feel exponentially more confident in my Excel skills after that learning experience.
- Sean McGrath
I was engaged all day. The trainer moved at a smooth and efficient pace, and all the content was covered. This was my refresher and I came away with a greater understanding and even more tips and tricks to use.
- Heather Abrahams
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