Microsoft Excel Intermediate

Course Times

• 9am to 4pm

Course Content

Cell Referencing

• Working with relative, absolute, and mixed cell references 

Functions & Formulas

• Tools for working with formulas 
• Working with Excel functions: IF, IFS*, VLOOKUP, XLOOKUP* 
• Using error handling functions 

Working with List Data

• Using Flash Fill 
• Summarising data using the Subtotal feature 
• Creating and working with Excel Tables 

Getting Started with Pivot Tables and Pivot Charts

• Creating and working with Pivot Tables 
• Creating and working with Pivot Charts 
• Using slicers and the timeline to dynamically filter Pivot Tables and Pivot Charts 

Visualising Data

• Using Conditional Formatting to highlight and compare data 
• Adding Sparklines 

Restricting Entry and Protecting Data

• Using Data Validation to restrict cell entry 
• Applying cell and sheet protection 

On completion of this course, participants will have a good understanding of functions and formula and be able to sort data, filter database and create customised charts.

Completion of Excel Introduction or equivalent knowledge is required.

“Effectively covered all areas of Excel ranging from basic skills to more advanced formula” Chad from Office of the Auditor General

“Was interesting to get a further understanding of all the concepts of Excel”  Nambaree from Dept. of Finance

“I enjoyed being able to work through and apply the things we learnt into a spreadsheet. Was also helpful going through possible errors and how to solve them” Natalia from Dept. of Finance

“Highly enjoyed the course, confidence has grown a lot. Would recommend in a heartbeat.” Blake from RioTinto

“Very simple and easy to follow and used examples that were relevant to our work.” Kerryn from NM TAFE

“Exceeded expectations :)” Kim from Murdoch University

“Thank you, it was well worth doing the course. I enjoyed it immensely and learnt lots of new features and tips about excel that will help me in my day to day job.” Sarah from LotteryWest

“Great class, will definitely be willing to do the next course up if given the opportunity” Alison from BGC Corporate