• Call Us: +61 409551614

Microsoft Excel Advanced

Microsoft Excel Advanced

The topics listed under this level of Excel training are a snapshot only of the skills which fall under the Microsoft Excel Advanced category. If you are interested in this level of training, please contact us to register your interest using the form on this page. Since we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your current skills to determine exactly which topics your team requires training in. If this level of training is too complex for you, you may want to consider the Microsoft Excel Intermediate course.

This level includes:

Importing & Exporting Data

  • Working with multiple worksheets
  • Linking worksheets in Excel (summary)
  • Copying data from Word
  • Copying data from Access
  • Linking data between programs
  • Embedding a Word document
  • Importing delimited data
  • Importing a Access table

Advanced Functions

  • ROUND
  • INT
  • IF
  • AND
  • OR
  • XLOOKUP
  • COUNT/COUNTA/COUNTIF/COUNTIFS
  • SUMIF/SUMIFS
  • SWITCH
  • INDEX/MATCH
  • SEQUENCE
  • AGGREGATE
  • UNIQUE
  • FILTER/SORT
  • NOW & DATE
  • Nesting Microsoft Excel Advanced Functions

Advanced Level Features of Excel

  • Format Painter
  • Conditional Formatting Advanced
  • Apply multiple conditions to Filtering
  • Linking data page to page
  • Create & use templates
  • Pivot Tables – Options/Multi-Table Pivots
  • Troubleshooting Common Problems with Pivot Tables
  • Pivot Table Tips
  • Consolidate
  • Data Forms
  • Performing Search & Replace using Wildcards
  • Justify data

Subtotalling Grouping & Outlining

  • Prepare spreadsheets for Subtotalling
  • Subtotalling
  • Collapsing and expanding data
  • Understanding Outlining and Grouping

Lists and Data Validation

  • Creating Data Validation
  • Validation breach Alerts
  • Editing/removing data Restriction & Messages
  • Copy Validation & Restrictions from cell to cell
  • Creating a Custom List

Macros

  • What is a macro?
  • Record a new macro
  • Assign macro to toolbar
  • Apply macro to shortcut key
  • Edit macros
  • Edit macro button icons
  • Reset the Excel toolbar
  • Delete macros

Advanced Excel Tools

  • What If – Scenarios
  • Data Tables
  • Goal Seek
  • Sparklines

Power Query

  • An Introduction to Power Query

Request for Training

    Your Name (required)

    Your Email (required)

    Your Contact Number (required)

    Any prior experience with Excel?

    Motivation for Training? (upskilling / applying for a job...)

    How soon do you need this Excel Advanced training?

    How many people require this training?