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.

“Exceptionally well-run training session. Thank you for enhancing my Excel knowledge in such a fun and engaging way. That was fantastic. So easy to follow along and have learned so many things I didn’t know previously.” – Ashlee from BHP

“Excellent course with very valuable tips and tools for use in my role. Great set up with the 2 screens for each person.” – Marisa from Rottnest Island Authority

“Teacher was wonderful. Super friendly and engaging with a great approach to explaining and teaching. Super satisfied.” – Dakotah from Rio Tinto

“Learning nifty tricks. Understanding how to use formulae. How to better use Excel and the breadth of knowledge that it has imparted to me. It will help me to understand how to use/change formulae. The training will also help me to create better reporting.” – Nina from Main Roads

“Very Useful to understand further aspects of Excel, that will enhance a lot of work that I’m currently doing. All questions have been answered to date.” – Jeff from Rio Tinto

“Overall very informative and great exercises to help explain. Cannot fault the course.” – Antonia from Fortescue

“A very good training material and useful, well presented and good explanation to each subject, thank you.” – Andra from Rio Tinto

“Learned many new items / features which are useful for work in terms of efficiency.” – Geordin from BHP

“Very good class, lots of information and helpful teacher.” – Amiee from Multiplant

“The facilitator was friendly, highly knowledgeable and clearly an expert. This made such a difference. She explained everything clearly and I couldn’t imagine a better facilitator to get across the more complicated features of Excel. This course will make an enormous difference to my capability to analyse data and organise it meaningfully and accurately.” – Sophie from DTWD

“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 Rio Tinto

“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