Microsoft Excel Macros Deep Dive - West College Scotland

Course Overview

Course Overview:

In this course, participants will be introduced to Excel macros and then develop a deeper understanding of advanced and custom macros including an introduction to VB coding for macros. Excel macros allow you to automate repetitive tasks and streamline your work processes.

Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

Target Audience:

Anyone who wants to take their Microsoft Excel skills to the next level, automate tasks and streamline their work processes.

Course Content:

Introduction to macros
How to use the macro recorder
Save your file with support for macros
Using absolute versus relative cell referencing when recording
Using absolute AND relative cell referencing when recording
Run a macro from a button you create
Use keyboard shortcuts to navigate during recording to get the correct result
Apply macros to different sized data sets
Add macro to Excel menu tabs
Introduction to the VBA Editor
Add IF condition to macro-VBA code
Add Loop to macro-VBA code
Introduction to debugging VBA code
Copy macros between workbooks

Pre-requisites for attending:

basic understanding of Microsoft Excel
Stable internet connection
No previous understanding of macros is required
Having a second display is beneficial but not required

Programme Information

Study Mode: Virtual (via Teams)

Duration: 6 hours

Times: 9.30 - 4.00pm

Price : £90

For further information on this course contact corporate@wcs.ac.uk or call 0141 581 2121 .