Excel – Working with Macros

Duration: delivered virtually over two half days (or 1 day face to face)

Cost: £285 +VAT per person (prices vary for bespoke courses – please enquire)

Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes.

This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.

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
  • Accessing the Developer Tab
  • Naming conventions and storage locations
  • Recording macros
  • Absolute and relative cell addressing
  • Assigning macros to the Quick Access Toolbar
  • Assigning macros to objects
  • Creating new tabs
  • Recording macros in a specific workbook
  • Saving the workbook as an Excel Macro-Enabled Workbook
  • Creating quick access items specific to workbooks
  • Importing Delimited Text Files
  • Importing Fixed Width Text Files
  • Project explorer
  • Code window
  • Properties window
  • Renaming modules
  • Deleting modules
  • Code structure
  • Adding comments
  • Navigating within your code
  • Editing macro code
  • Getting help with syntax
  • Errors
  • Using debug
  • Creating function macros

Cost: £285 +VAT per person

Click here to view next available dates and complete booking request.

Please email training@underscore-group.com if you would like to discuss the course before booking or to discuss bespoke programme options.

Great introductory course to Macros. Susan is a very good teacher and made it very easy to follow. Class size was ideal so we could all ask questions to help us fully understand what we were doing. I’d definitely recommend the course to my colleagues. The Beehive is a stunning building! Class room space was perfect for our group. The reception lady was very friendly too.

Vaiga, Willis Towers Watson

I would recommend the course, it was very well structured. Brief demonstration by Susan on Excel followed by practice exercises straight after was definitely a good approach to better understanding and applying the freshly learned skill. Susan is very friendly and knowledgeable. Susan is very energetic, communicative and involved. She made the course easy to digest and time passed quickly. The structure, the size of the group so the teacher was very engaged with us and could answer all the questions.

Daria, Willis Towers Watson

I would recommend the course, easy to follow at a good pace.

Jessica, Gatwick Airport Ltd

Very good overview and insight into macros. Ron was fantastic. He broke it down to easy to understand sections, Ron showed examples of how it can work day to day.

James, Tokyo Electron

I would recommend it, very experienced trainer and good curriculum of the training. Breaking the course into sessions of three hours per day was really excellent as this allows to do the daily work and also not to overload with information on one day. The combination of lecture and exercises was really good. Yes I would recommend virtual training especially for software trainings it was good to see the other students’ screens.

Markus, Tokyo Electron

Back to all courses
talk to us about training dates for your team