Excel Macros Specialist Training Course

Book this course

Course description

The macros function within Microsoft Excel is a powerful feature that allows you to automate commonly used commands and processes – streamlining the way you work and enabling you to be more efficient.

We show you all the essential techniques you need to be aware of in order to understand and use this function to its full potential – from recording and running macros to working with code.

Is it right for me?

If you’re already an experienced Excel user, confident in creating and manipulating spreadsheet and creating formulas, this advanced Excel training course will enhance your current skillset.

What will I get out of it?

By the end of the course you will be able to:

  • Record and run macros
  • Navigate within the Visual Basic environment
  • Edit pre-recorded macros
  • Create your own functions

The trainer was excellent in adapting the course to suit our requirements. 

Project Administrator, CAE

What does it cover?

  • Accessing the Developer Tab (2007 and 2010)
  • Naming conventions and storage locations
  • Recording macros
  • Absolute and relative cell addressing
  • Assigning macros to toolbars or menus (2003)
  • Assigning macros to the Quick Access Toolbar (2007 and 2010)
  • Assigning macros to objects
  • Creating new tabs (2010 only)
  • Recording macros in a specific workbook
  • Saving the workbook as an Excel Macro-Enabled Workbook (2007 and 2010 only)
  • Creating quick access items specific to workbooks (2007 and 2010 only)
  • Deleting macros
  • Setting macro options
  • Macro security
  • Project explorer
  • Code window
  • Properties window
  • Code structure
  • Adding comments
  • Navigating within your code
  • Editing macro code
  • Getting help with syntax
  • Workbook and worksheet commands
  • Excel selection methods
  • Errors
  • Using debug
  • Creating function macros

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article