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 below. As 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 you require 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

  • PMT
  • INT
  • IF/SUMIF
  • AND
  • OR
  • VLOOKUP
  • COUNT/COUNTA/COUNTIF
  • NOW & DATE
  • Nesting 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
  • 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
  • What If – Data Tables
  • What If – Goal Seek
  • Sparklines

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?