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:20230719
DTEND;VALUE=DATE:20230720
DTSTAMP:20261024T142112
CREATED:20230511T080010Z
LAST-MODIFIED:20230701T183821Z
UID:10000869-1689724800-1689811199@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-2-2/2023-07-19/1/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Macros Deep Dive Workshop,Seminar Courses
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;VALUE=DATE:20230719
DTEND;VALUE=DATE:20230721
DTSTAMP:20261024T142112
CREATED:20230511T080101Z
LAST-MODIFIED:20230701T183821Z
UID:10002138-1689724800-1689897599@pitmantrainingscotland.co.uk
SUMMARY:Supervisory Skills
DESCRIPTION:Supervisory Skills – Tutor Led \n\n\n\nGet better results from your team. \nWould enhanced supervisory skills be of benefit to you or any other of your employees? \nAre you a supervisor or team leader who would like to get better results from your team? \nAre you interested in working with an experienced provider of innovative\, effective and enjoyable training solutions? \nCompetent and confident supervisors are critical to the success of all organisations – in terms of how they manage their teams\, tasks and change. \nThis course develops core supervisory competencies and provides a range of techniques that supervisors can immediately use to enhance the results they get. \nThe course has been designed for new supervisors/team leaders/managers or those in these roles who have not received any formal supervisory skills training. \nIt is delivered in a format to engage all learning styles and to stimulate changes in behaviour after the course. Typically this involves a mix of trainer led insight\, delegate participation\, team activity\, practical exercises and learning views. \nOur trainers are experienced in creating positive learning environments where participants feel comfortable in sharing experiences and practicing skills. \nDuration: 2 Days \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \n\n\n\nAim: \nThe aim of the course is to provide participants with a range of skills\, methodologies and techniques to enhance their ability to supervise people\, tasks and change effectively. \nWhat you will learn: \n\nHow to become a credible supervisor\nHow to communicate successfully\, using verbal and non-verbal modes ofcommunication: asking specific questions and active listening\nHow to prioritise tasks and manage their time more effectively\nHow to delegate appropriate tasks productively\nHow to make well informed decisions\nHow to motivate team members to deliver desired results\nHow to build a positive working environment\nHow to deal with challenging team members and work situationsDuration: 2 Days\nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \nAvailable on our open schedule timetables in Edinburgh and Glasgow
URL:https://pitmantrainingscotland.co.uk/event/supervisory-skills-5-2/2023-07-19/1/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Supervisory Skills
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230719
DTEND;VALUE=DATE:20230720
DTSTAMP:20261024T142112
CREATED:20230511T080010Z
LAST-MODIFIED:20230701T183821Z
UID:10002137-1689753600-1689786000@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-2-2/2023-07-19/2/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Macros Deep Dive Workshop,Seminar Courses
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;VALUE=DATE:20230719
DTEND;VALUE=DATE:20230721
DTSTAMP:20261024T142112
CREATED:20230511T080101Z
LAST-MODIFIED:20230701T183821Z
UID:10001083-1689759000-1689872400@pitmantrainingscotland.co.uk
SUMMARY:Supervisory Skills
DESCRIPTION:Supervisory Skills – Tutor Led \n\n\n\nGet better results from your team. \nWould enhanced supervisory skills be of benefit to you or any other of your employees? \nAre you a supervisor or team leader who would like to get better results from your team? \nAre you interested in working with an experienced provider of innovative\, effective and enjoyable training solutions? \nCompetent and confident supervisors are critical to the success of all organisations – in terms of how they manage their teams\, tasks and change. \nThis course develops core supervisory competencies and provides a range of techniques that supervisors can immediately use to enhance the results they get. \nThe course has been designed for new supervisors/team leaders/managers or those in these roles who have not received any formal supervisory skills training. \nIt is delivered in a format to engage all learning styles and to stimulate changes in behaviour after the course. Typically this involves a mix of trainer led insight\, delegate participation\, team activity\, practical exercises and learning views. \nOur trainers are experienced in creating positive learning environments where participants feel comfortable in sharing experiences and practicing skills. \nDuration: 2 Days \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \n\n\n\nAim: \nThe aim of the course is to provide participants with a range of skills\, methodologies and techniques to enhance their ability to supervise people\, tasks and change effectively. \nWhat you will learn: \n\nHow to become a credible supervisor\nHow to communicate successfully\, using verbal and non-verbal modes ofcommunication: asking specific questions and active listening\nHow to prioritise tasks and manage their time more effectively\nHow to delegate appropriate tasks productively\nHow to make well informed decisions\nHow to motivate team members to deliver desired results\nHow to build a positive working environment\nHow to deal with challenging team members and work situationsDuration: 2 Days\nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \nAvailable on our open schedule timetables in Edinburgh and Glasgow
URL:https://pitmantrainingscotland.co.uk/event/supervisory-skills-5-2/2023-07-19/2/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Supervisory Skills
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR