6. Excel Adv (Level 2)
Description
Excel Advanced (Level 2)
Duration: 1 Day (9:00 am - 1:00 pm)
Location: Welwyn Garden City or Borehamwood
Includes: Refreshments 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
