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:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20231029T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20231215
DTEND;VALUE=DATE:20231216
DTSTAMP:20261022T074401
CREATED:20230511T081541Z
LAST-MODIFIED:20230701T183818Z
UID:10000830-1702627200-1702659600@pitmantrainingscotland.co.uk
SUMMARY:Macros Deep Dive Workshop
DESCRIPTION:Using Excel Macros can speed up work and save you a lot of time\, increasing productivity!\nIn this ‘Deep Dive’ into the topic\, 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 Microsoft Excel.\nIn 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 (Visual Basic) coding for macros \nWhat you will learn: \n\nIntroduction to macros\nHow to use the macro recorder\nSave your file with support for macros\nUsing absolute versus relative cell referencing when recording\nUsing absolute AND 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 the VBA Editor\nAdd IF condition to macro VBA code\nAdd Loop to macro VBA code\nIntroduction to debugging VBA code\nCopy macros between workbooks\nDuration: 1 Day \nThis course is delivered on our open schedules in Edinburgh and Glasgow We can also deliver this workshop via a virtual classroom over two half sessions\, using Zoom or Teams.
URL:https://pitmantrainingscotland.co.uk/event/macros-deep-dive-workshop-3/2023-12-15/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Macros Deep Dive Workshop,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR