Excel Automate– Experience the Magic of Macros and VBA

REIM Training Solutions

Excel Automate– Experience the Magic of Macros and VBA

65 65 people viewed this event.

This workshop is ideal for those who are frequent users of Excel and want to learn how to use macros to automate repetitive tasks.  Everything you do within Excel can be automated when you know how to use Macros & VBA.  Learners will also gain an understanding of VBA programming for beginners so that they know not only how to automate tasks but also how to write simple code to get more functionality from Microsoft Excel.

 

Choice of Flexible Delivery Options:

 

~  1 Day of Training

~  2 Mornings  /  2 Afternoons  /   2 Evenings

 

Enquire Now

 

Date And Time

-
 

Location

Online event
 

Event Category

 
Download Events iCal

Share With Friends

Who Should Attend

This course is for those who already use Excel in their daily jobs and who want to learn how to use macros to automate repetitive tasks and gain an understanding of VBA programming.

Learning Objectives

  • Upon completion of this course learners will be able to competently:
  • Understand the benefits of Macros and suitable applications
  • Identify key elements of VBA and their appropriate use in solving data problems
  • Add the Developer tab to their ribbon
  • Record VBA macros to automate repetitive tasks
  • Write VBA code to create VBA subroutines and functions
  • Solve problems through code, including variables, objects, conditional  statements and loops
  • Remove, avoid, or manage errors in VBA code

Prerequisites

Learners should already be reasonably confident using Microsoft Excel and have access to Microsoft Excel on their computer for the duration of the course.

Course Outline

  • Introduction to VBA and Macros
  • Using Macros to Automate Tasks
  • Setting up your VBA environment in Excel
  • Recording a Macro
  • Writing VBA Code
  • Application of Code for Solving Problems and Automating Tasks
  • Optimising your VBA Code

Scroll to Top