Recording Macros with Microsoft Excel

Who is this course for?

This course is for you if you have never recorded a Macro and would like to understand what a Macro is, what it does and how it might be useful to you. (If you are already familiar with the topics here you may benefit from our VBA course)

What are the benefits

This session will help you save time on routine tasks. At the end of this session you will understand absolute cell referencing in Macros be able to record Macros, assign them to current workbooks, or a personal Macro workbook and assign Macros to icons and shapes.

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

3 hours

Course Content

Getting Started with Macros

  • What is a Macro?
  • Why should I use Macros?
  • What is a recorded Macro?

Excel Macro Basics

  • Add the Developer Ribbon
  • Where do Macros go?
  • Assign a Macro to the current workbook
  • Create a Personal Macro Workbooks

Recording Macros

  • Use the Macro Recorder to create a Macro
  • Run the Macro
  • Simple troubleshooting
  • Absolute and relative references
  • Assign the Macro to a shortcut key

Sharing Macros

  • Assign Macros to buttons
  • Assign Macros to shapes
  • Create a customised Macro ribbon

The Visual Basic Editor

  • Use the Editor to make minor changes
  • Test a Macro in Step mode
  • Join two Macros
  • Simple Macro editing

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us