Get to grips with Microsoft Excel Macros

from £99

This 2-hour webinar offers a look at using macros to quickly automate time consuming, repetitive tasks. Understand the advantages of using Relative Referenced macros. Creating macros to run across all your workbooks. You will also look a macro's VBA coding (Visual Basic for Applications). You connect live with our trainer.

Check prices, dates and availability

Make an enquiry

Key features
- Live instructor led course
  with 2 hours of training
- Session runs from 9.30–5pm with normal breaks included
- Fully certified trainer
- Get key skills and practical knowledge
- This course is available for delivery at your office, 1-1 and groups – contact us
- Course materials included
- Recognised course certificate

What will I learn?

By the end of this webinar you will know how to:

• Plan your macro before the recording process, and understand the principles of recording.
• Recognise the versatility of a Relative Referenced macro.
• Name a macro, record and run macros in an Excel file.
• Run macros with keyboard shortcuts, Quick Access toolbar and Ribbon buttons.
• Save files containing macros as Excel Macro-Enabled Workbook file type.
• Produce macros that run across all your Excel files by saving to the Personal file.
• Unhide, hide and manage the Personal file.
• What is VBA? Coding without programming.

Certification

Have this course at your office

Complete the below form to enquire about having this course delivered at your office where discounts may apply

Your name Your phone number Your email address