Home > Microsoft Excel

Excel Adv (Level 2)

Dates

Our Price: £180.00
Excel Adv (Level 2)
Description
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

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