Microsoft Excel Advanced Training

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: Please contact for booking options
  • We can host this training at your preferred location. Contact us!
Upcoming Training
07 June 2023
2 Days

  • Create, edit, and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

  • Use macros to automate repetitive tasks
  • Setup workbooks to collaborate with other users
  • Create and build PivotTables to analyse data
  • Write array and advanced lookup functions
  • Use ‘what-if’ analysis tools
  • Use data validation
  • Import external data into Excel workbooks

Module 1: Creating macros

  • Introducing macros
  • Creating macros
  • Relative and absolute macros
  • Running and editing a macro
  • Assigning shortcuts
  • Macro security

Module 2: Collaborating with others

  • Protecting data, workbook structure and files
  • Checking for collaboration issues
  • Marking workbooks as final

Module 3: PivotTables

  • What is a PivotTable?
  • Creating and modifying PivotTables
  • Calculations in PivotTables
  • Grouping fields
  • Slicers and Timelines
  • Creating PivotCharts
  • PivotTables and related sources

Module 4: Array formulas

  • What is an array?
  • Array formulas
  • Array functions
  • Single and multiple cell arrays

Module 5: Further lookup and reference functions

  • VLOOKUP and HLOOKUP
  • GETPIVOTDATA
  • MATCH and INDEX
  • XLOOKUP (Excel 365 only)

Module 6: Analysing data

  • Input data tables
  • Worksheet scenarios
  • Goal Seek
  • Consolidating data
  • Linking to external workbooks

Module 7: Data validation

  • Setting up data validation
  • Message prompts and alerts
  • Conditional data validation
  • Data validation errors

Module 8: Importing data

  • Importing delimited files
  • Importing data with a web query
  • Refreshing data



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

07 June 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
03 July 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
07 August 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
11 September 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
25 September 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
09 October 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
23 October 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
06 November 2023

Classroom / Virtual Classroom

Istanbul, Ankara, London
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.