Microsoft Excel Advanced

This course exposes many advanced features of Excel including protecting your workbooks and restricting data entry, building calculations using advanced functions and how to import, clean up, and analyse data sets. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

1 day course
4.61  (1792 reviews)
What you will learn:
  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry and build complex models with Lookup functions
  • Analyse data with simple Tables, PivotTables and PivotCharts.
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Looking for Online training?

Discover our Microsoft Excel Advanced Online training course. Can’t find what you are looking for?  Enquire for online training today!

What's covered?
  • Workbook protection
  • Protecting cells
  • Protecting structure
  • AND and OR
  • Nested IF
  • IFS function
  • VLOOKUP and HLOOKUP
  • Transposing data
  • Concatenating
  • Defining range names
  • Using names in formulas
  • Navigating with names
  • Using named constants
  • Documenting range names
  • Limiting cell values
  • Creating drop-down cell lists
  • Validation error messages
  • Get Data
  • Transform in Query Editor
  • Clean up data in Query Editor
  • Workbook linking
  • Dealing with broken links
  • Create a PivotTable
  • Rearranging data
  • Applying filters
  • Adding fields
  • Modify field settings
  • Refreshing data
  • Formatting a PivotTable
  • Creating a PivotChart
  • Filtering a PivotChart
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
4.61
4.61
from 1792 reviews
5/5
“I think it was all good.”
R, May 2020
4/5
“Good insight to Power BI”
Leigh, May 2020
4/5
“Learn't how to do many things I couldn't previously do”
Kevin, May 2020
4/5
“Little tricks and ways of using tools that I didn't know before”
Juanita, May 2020