Loading Events

« All Events

Event Series Event Series: Macros Deep Dive

Macros Deep Dive

March 20 @ 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:
March 20
Time:
9:30 am - 4:30 pm
Series:
Event Categories:
, , ,

Organiser

Pitman Training Centre – Edinburgh
Phone
0131 556 5650
Email
edinburgh@pitman-training.net

Venue

Edinburgh
4 Queen Street
Edinburgh, EH2 1JE United Kingdom
+ Google Map
Phone
0131 556 5650