Click here to send this to a colleague or friend.

Master Excel Macros

Microsoft Office version 2010, 2013 and 2016

Save time and increase productivity with Excel Macros for Microsoft Excel

Simple, powerful, and easy to use, Excel macros can save you time and increase your productivity. These nifty tools are used to automate a complicated series of actions or record commonly used commands - so you can run a process at the touch of button.

What are macros?
Where are they kept?
What do they do?

Macros in Excel are bits of code stored in the workbook that can automate repetitive tasks and quickly get your data in order.

Simply put - using macros will make your life easier.

Excel macros can be used to automate a complicated series of actions or record commonly used commands, and can be especially useful for working with ranges of data.

shadow

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists.

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

shadow
shadow
Register now for this workshop
WHAT WILL BE COVERED ON THIS ONE-DAY WORKSHOP?

Introduction to Macros

  • What are Macros?
  • Why do we use Macros?
Recording Macros
  • What is recorded?
  • Prepare for the recording
  • Decide where to store the Macro
  • Perform the recording
  • Stop the recording
Deleting and managing Macros
  • Editing shortcut keys and descriptions
Assigning Macros
  • Buttons
  • The Quick Access toolbar
  • Shapes
An introduction to the VB Editor (Where Macros are stored)
  • Opening VBE
  • Understanding the VBE Explorer
  • Working with Modules
shadow

A quick introduction to VBA
(Editing what the Macro does)

  • Combining Macros
  • Editing Ranges
Recording Relative references for selections
  • Determine where macros run
  • Macros that make intelligent selections
Macro Security
  • Why are Macros dangerous?
  • Setting Security Options
  • Understanding and using Digital Certificates
Copying Macros
  • Copying Macros from and to other workbooks
  • Localising the Macros
Examples of handy Macros to have around
shadow shadow

Who should attend?

  • Any decision maker who would like to get the most out of their software
  • Financial managers, bookkeepers, analysts and researchers

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

shadow
Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 28th January 2019 at Benvenuto Conference Centre in Randburg

22nd February 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

14th March 2019 at Benvenuto Conference Centre in Randburg

Map: View map
Duration: 1 Day
Cost: R2 350.00 excl VAT
R2 705.50 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional R200 surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow
Discount:

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates

In-house at your offices

25% discount for 5 or more delegates
30% discount for 8 or more delegates
35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions

shadow

Bookings:

Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Screenshot: http://images.frontfoot.com
shadow
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time
Workbooks and workshops are aligned to the prevailing Unit Standard

Front Foot provide business training to business people;
Training is held at premium training venues