BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Pitman Training Courses Scotland - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Pitman Training Courses Scotland
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:20261021T074457
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
BEGIN:VEVENT
DTSTART;TZID=UTC:20241024T093000
DTEND;TZID=UTC:20241025T123000
DTSTAMP:20261021T074457
CREATED:20231128T130218Z
LAST-MODIFIED:20231128T130218Z
UID:10004378-1729762200-1729859400@pitmantrainingscotland.co.uk
SUMMARY:Time Management
DESCRIPTION:This workshop is ideal for anyone who wishes to improve their self-managing techniques\, achieve more in their working day and gain more balance in their lives. Spending 1-day learning how to manage your time – will save you hours! \nWhat you will learn: \n\nTo take an objective look at how you spend your time at work.\nTo prioritize effectively\nHow to establish short- and long-term goals and to achieve results.\nTo be aware of your own style in dealing with work and how this helps to manage yourself more effectively.“Well – arranged time is the surest mark of a well-arranged mind” – Sir Isaac Pitman
URL:https://pitmantrainingscotland.co.uk/event/time-management-13/2024-10-24/
LOCATION:Virtual Classroom
CATEGORIES:Seminar Courses,Time Management,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR