Home > Microsoft Excel

Excel Adv (Level 2)


Our Price: £180.00
Excel Adv (Level 2)

Excel Advanced (Level 2)
Duration: 1 Day (10:00 am - 2:30 pm)
Location: Welwyn Garden City
Includes: Lunch and Documentation
Price: £180 per person


Our public scheduled courses are currently suspended due to the COVID-19 outbreak, we are still able to offer closed courses in very small groups and 1:1 tuition.  Please contact us for details.

Not sure if this course is suitable for you? Why not take a Quick Quiz or  a FREE - Training Needs Analysis

Advanced (Level 2):  This course is for users who want to automate their spreadsheets using recorded macros. In this course we explore the options for storing recorded macros. You will learn how to use Relative and Absolute referencing when recording. You will learn how to add buttons to run your macros. You will gain confidence in editing Visual Basic Code.  You will be able to create your own Excel Functions and distribute them to your colleagues.

  • Recording a Macro
  • The Personal Macro Workbook
  • Recording a Macro with Relative Referencing
  • Assigning Macros to Buttons
  • Customising the Ribbon
  • Adding Macro Buttons to the Ribbon
  • Editing Visual Basic Code
  • Creating User-Defined Functions