MS Excel Intermediate

Course Times

• 9am to 4pm

Course Content

Cell Referencing

• Absolute and relative & partial cell referencing
• Trace precedents
• Link workbooks & calculate across sheets

Functions & Formulas

• Work with named ranges
• Use the IF, AND and OR functions
• Use the VLookUp & HLookUp functions

Working with Data

• Import/export data
• Use tables for sorting & filtering
• Data validation
• Conditional formatting
• Summarise data by creating subtotal

Pivot Tables

• Create and format pivot tables

Charts

• Apply charting features

Protection

• Protect cells, sheets & workbooks

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