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!

In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, and importing and cleaning data.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

  • 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!
Blog posts related to Microsoft Excel Advanced Training

2020 PROJECT MANAGEMENT TRENDS

Are you aware of 2020's Project Management trends? If not, you are in the right place! Read our article "2020 Project Management Trends" to find out

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.

Classroom
10 April 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
10 March 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
25 March 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
03 April 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
14 April 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
06 May 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
19 May 2025
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
12 June 2025
Istanbul, Ankara, London
2 Days

Bilginç IT Academy All Rights Reserved

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