BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Pitman Training Courses Scotland - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://pitmantrainingscotland.co.uk
X-WR-CALDESC:Events for Pitman Training Courses Scotland
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20241024T093000
DTEND;TZID=UTC:20241024T163000
DTSTAMP:20261019T155422
CREATED:20231127T170133Z
LAST-MODIFIED:20231127T170133Z
UID:10004098-1729762200-1729787400@pitmantrainingscotland.co.uk
SUMMARY:Macros Deep Dive
DESCRIPTION: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. \nThis seminar is also available on demand by virtual classroom.  \nWhat you will learn: \n\nIntroduction to Macros\nHow to use the macro recorder\nSave your file support with macros\nUsing absolute versus relative cell referencing when recording\nRun a macro from a button you create\nUse keyboard shortcuts to navigate during recording to get the correct result\nApply macros to different sized data sets\nAdd macro to Excel menu tabs\nIntroduction to VBA Editior\nAdd IF condition to macro VBA code\nAdd Loop to macto VBA code\nIntroduction to debugging VBA code\nCopy macros between workbooks
URL:https://pitmantrainingscotland.co.uk/event/macros-deep-dive/2024-10-24/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Macros Deep Dive Workshop,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
END:VCALENDAR