Explore Contact us

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
  • On Demand or Face to Face 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  
  • English Subtitles: English

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.

Show more

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.

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
London
United Kingdom
EC1V 2NX

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Delighted satisfaction rating