Excel Automate– Experience the Magic of Macros and VBA
Excel Automate– Experience the Magic of Macros and VBA
19 19 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
Organiser
REIM Training Solutions
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
