Get To Grips With Microsoft Excel Macros Training

Enquire today we have face to face and live online training available

What you will learn

  • This 3 hour live online course 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.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Intermediate For those with working experience or likely to have completed foundation level training  

This course consists of 8 lessons

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.

Enquire today

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.