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
- 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

Reviews

I took this course because I had most of the knowledge but wanted a formal certificate, however, having attended I realized there was a great deal I didn’t know so it was really worthwhile, 5 stars. A Patel

Nicely structured training event. We were kept up to date at all times with timely communications during the booking process so we have already booked more sessions with go courses. T Eversham