Learn how to use macros to carry out repetitive automatically on this one day Excel course.

This is a hands-on course that will have you creating and editing macros in no time.

By the time you finish, you’ll be comfortable creating and editing your own Excel macros from scratch.

✔ A complete Excel macros course that covers the entire process from start to finish.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

On this macro training course you’ll cover:

  • What are macros? Why are they useful? How can they be made fully secure?
  • Creating simple and multi-step macros.
  • Navigating Excel’s developer tab to access the VBA that runs your macro.
  • Editing macros after you’ve created them to make them do exactly what you want.
  • The basics of VBA programming so that you take full control of your macros after you’ve created them.

Our Excel VBA course covers all of this material and goes further into VBA coding for people who have more time available.

 

The Training Day

Our Excel macros training course runs from 9.30am to roughly 4.30 pm with plenty of refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest Excel instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual to keep which covers everything in the course.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.

Am I Ready For This Course?

This macros course does not require any prior knowledge of VBA or Excel macros but it does assume that you are an advanced Excel user.

We would recommend that you have attended our advanced Excel course course or have an equivalent level of Excel knowledge through your day-to-day work before you attend this course.

  • Understanding Excel Macros
  • Setting Macro Security
  • Saving a Document as Macro Enabled
  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Cell References
  • Running a Macro With Relative References
  • Viewing a Macro
  • Editing a Macro
  • Assigning a Macro to the Toolbar
  • Running a Macro From the Toolbar
  • Assigning a Macro to the Ribbon
  • Assigning a Keyboard Shortcut to a Macro
  • Deleting a Macro
  • Copying a Macro
  • Preparing Data for an Application
  • Recording a Summation Macro
  • Recording Consolidations
  • Recording Divisional Macros
  • Testing Macros
  • Creating Objects to Run Macros
  • Assigning a Macro to an Object
  • Programming in Microsoft Excel
  • VBA Terminology
  • Displaying the DEVELOPER Tab
  • The VBA Editor Screen
  • Opening and Closing the Editor
  • Understanding Objects
  • Viewing the Excel Object Model
  • Using the Immediate Window
  • Working With Object Collections
  • Setting Property Values
  • Working With Worksheets
  • Using the Object Browser
  • Programming With the Object Browser
  • Accessing Help
  • Code Glossary
  • Using the Project Explorer
  • Working With the Properties Window
  • Using the Work Area
  • Viewing Other Panes
  • Working With Toolbars
  • Working With a Code Module
  • Running Code From the Editor
  • Setting Breakpoints in Code
  • Stepping Through Code
  • Understanding Functions
  • Creating User-Defined Functions
  • Using a User-Defined Function in a Worksheet
  • Setting Function Data Types
  • Using Multiple Arguments
  • Modifying a User-Defined Function
  • Creating a Function Library
  • Referencing a Function Library
  • Importing a VBA Module
  • Using a Function in VBA Code
  • Code Glossary
  • The MsgBox Function
  • Using MsgBox
  • InputBox Techniques
  • Using the InputBox Function
  • Using the InputBox Method
  • The IF Statement
  • Using IF for Single Conditions
  • Using IF for Multiple Conditions
  • The Select Case Statement
  • Using the Select Case Statement
  • For Loops
  • Looping With Specified Iterations
  • The Do Loop Statement
  • Looping With Unknown Iterations
  • Code Glossary
  • The Application Object
  • The Workbook Objects
  • Program Testing With the Editor
  • Using Workbook Objects
  • The Worksheets Object
  • Using the Worksheets Object
  • The Range Object
  • Using Range Objects
  • Using Objects in a Procedure
  • Code Glossary