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.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine