Loading Events

« All Events

Event Series Event Series: Macros Deep Dive

Macros Deep Dive

April 19 @ 9:30 am - 4:30 pm

In this ‘Deep Dive’ we will devote the full day to exploring Macros and how they are used in Excel. We recommend that you have a basic to intermediate understanding of Excel already.

This seminar is also available on demand by virtual classroom. 

What you will learn:

  • Introduction to Macros
  • How to use the macro recorder
  • Save your file support with macros
  • Using absolute versus 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 VBA Editior
  • Add IF condition to macro VBA code
  • Add Loop to macto VBA code
  • Introduction to debugging VBA code
  • Copy macros between workbooks

Details

Date:
April 19
Time:
9:30 am - 4:30 pm
Series:
Event Categories:
, ,

Organiser

Pitman Training Centre – Glasgow
Phone
0141 223 0090
Email
glasgow@pitman-training.net

Venue

Glasgow
First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
+ Google Map
Phone
0141 223 0090