Advanced Excel Training

by STL Claim Listing

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

STL Logo

img Duration

Enquire Now

Course Details

Who Is This Course For?

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

 

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

 

Benefits

 

  • At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.

  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

 

Course Syllabus

Using logical functions

  • The IF function (recap)

  • Creating nested IF functions

  • The IFS function

  • AND and OR functions

  • Combining logical functions

Working with Lookups

  • The VLOOKUP function

  • The HLOOKUP function

  • The XLOOKUP function (365)

  • INDEX & MATCH

Data Validation

  • Using data validation

  • Setting criteria for entry of text, values and dates

  • Creating a dropdown list

PivotTables and PivotCharts

  • Creating and rearranging PivotTables

  • Using the PivotTable toolbar

  • Creating PivotCharts

  • Using Slicers to manipulate PivotTables

Using analytical options

  • Using Goal Seek

  • Creating, saving and viewing scenarios

  • Creating single input data tables

  • Creating double input data tables

  • Projecting with data tables

Macros

  • Creating macros

  • Using the macro recorder

  • Viewing and editing macro VBA code

  • Kent Branch

    Hoo Marina, Vicarage Lane, Kent

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy