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:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251106T090000
DTEND;TZID=Europe/London:20251107T000000
DTSTAMP:20261019T133427
CREATED:20241028T170300Z
LAST-MODIFIED:20241029T134937Z
UID:10004447-1762419600-1762473600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-3/2025-11-06/
LOCATION:Virtual Classroom
CATEGORIES:Excel Intermediate,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251106
DTEND;VALUE=DATE:20251107
DTSTAMP:20261019T133427
CREATED:20241030T161822Z
LAST-MODIFIED:20250819T134502Z
UID:10004663-1762421400-1762446600@pitmantrainingscotland.co.uk
SUMMARY:Management Skills – 1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nAs you develop as a manager you are even less involved in the day-to-day delivery of the work. Your success depends on your ability to manage your team\, manage others who supervise and manage technical specialists. Your is less about your technical skills and will demand even higher levels of people skills. Your coaching skills will need more finesse as you may find yourself coaching supervisors and junior managers who act as coaches at their own level. \nThis workshop will help you develop the right people skills and keep you developing for future management roles. Ideal for those with some management experience\, this course will help you benchmark your skills\, trouble shoot pinch points and set the scene for middle levels of management. \n  \nObjectives: \nTo share methodologies and techniques that will enable you to: \n\nDevelop your team\nUse different management approaches\nPlan and attend productive meetings\nDeal with disciplinary situations with confidence\nManage absence\nDevelop and conduct competency based interviews\nStructure inspiring coaching sessions\n\n  \n  \n  \nCourse Programme: \n\nReview of Actions from Supervisory Skills Workshop\nTheory X and Y\n\nHow your approach impacts your team and organization\n\n\nInspired Meetings\n\n4 ways to ensure people look forward to your meetings\nSuggested meeting structure\n\n\nManaging Absence\n\nThe Bradford Factor\nGuidance for Handling Absenteeism and Illness\nBest practice for Return to Work Interviews\n\n\nInterview Skills\n\nTypes of Interview\nA Competency Based Report\nSTAR Structure\n\n\nCoaching\n\nThe GROW Model\nGreat Coaching Questions\n\n\nBring it all together and action planning\nCourse Review\n\n  \nDuration: 1 day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow.
URL:https://pitmantrainingscotland.co.uk/event/management-skills-1-day-workshop/2025-11-06/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Management Skills,Personal Development Workshops,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;TZID=Europe/London:20251106T093000
DTEND;TZID=Europe/London:20251106T163000
DTSTAMP:20261019T133427
CREATED:20241030T162829Z
LAST-MODIFIED:20250819T134732Z
UID:10004681-1762421400-1762446600@pitmantrainingscotland.co.uk
SUMMARY:Meetings and Minutes – 1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred. \nObjectives: \n\nTo understand what meetings are and why we have them\nTo understand the importance of an agenda\nTo identify the key elements of an agenda\nTo introduce different styles of note taking\nTo understand what minutes are and why we need them\nTo learn how to produce appropriate minutes of a meeting\n\n\nWhat you will learn: \n\nThe difference between formal and informal meetings\nHow to set out an agenda\nTips and techniques for note taking\nThe role of the minute taker\nWhat minutes are and the different styles of minutes\nHow to use appropriate language for minutes\n\n  \nWho should attend? \nAnyone who organises and takes minutes at meetings; those who would like to do this role to a professional standard. \n  \nDuration: 1 day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/meetings-and-minutes-1-day-workshop-2/2025-11-06/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Meetings and Minutes,Personal Development Workshops,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR