Excel – Working with Macros

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

Cost: £275 +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: £275 +VAT per person (prices vary for bespoke courses – please enquire)

Please click on ‘Book Your Place’ and fill out the form below to reserve a space on the course, or email training@underscore-group.com if you would like to discuss the course before booking.

Alternatively please get in touch to discuss bespoke programme options.

Date:

New dates to be confirmed

This course is being delivered virtually across two half day sessions.

Price: £275 +VAT includes:

  • Detailed reference materials
  • Experienced trainer for the day
  • Free access to our LinkedIn Group
  • Free 6 month post course support (IT courses only)


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.

Willis Towers Watson logoVaiga, 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.

Willis Towers Watson logoDaria, Willis Towers Watson

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

Gatwick airport logoJessica, Gatwick Airport Ltd


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