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:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20250121T093000
DTEND;TZID=Europe/London:20250123T163000
DTSTAMP:20261021T004154
CREATED:20241030T171328Z
LAST-MODIFIED:20250819T145436Z
UID:10004767-1737451800-1737649800@pitmantrainingscotland.co.uk
SUMMARY:Train the Trainer – 3-day Workshop
DESCRIPTION:Tutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace. \nCPD Accredited \nTutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace. \nAim: \nThis course will introduce participants to the issues\, methodologies and techniques of training design and delivery. \nObjectives: \nBy the end of this workshop\, participants will be able to: \n\nIdentify training needs.\nDefine and create aims and objectives that fit within an organisational perspective.\nDesign training sessions.\nDeliver training sessions that incorporate the trainer’s personality – metaphors\, stories. and humour.\nEvaluate training interventions.\nDealing with difficult delegates.\n\nThe training systematically points to everything you need to know about being a trainer. Each day consists of practical experience as well as hundreds of useful tips and techniques. \nWhile the first part of the course concentrates on the design and structure of training as a learning tool; it then moves on to presentation\, delivery and facilitation so each day builds up to complete a full training methodology. \n  \nDuration: 3 days \n  \nThe information shown below is the structure of the course – timings and emphasis will vary depending on participants’ needs. \nIntroduction: \n\nLogistics and participant introductions\nAims and objectives\n\nAiming for successful training: \n\nExploring the varying factors that can impact on successful training\nPersonal preferences in training experiences\nScope of training within organisations\nHow these fit together\n\nTraining needs: \n\nIssues in defining and managing training needs\nLevels of needs and methods of identifying them\n\nTraining as a ‘Change Intervention’: \n\nIdentifying thpes of learning and changes possible\nPlanning for and organizing change through training\n\nCreating and using training aims and objectives: \n\nDifferences and uses of ‘Aims and Objectives’\nCriteria of ‘Aims and Objectives’\nBenefits and limitations of ‘Aims and Objectives’\n\nTraining planning and design: \n\nStructuring the training\nPriorities for inclusion in the training\nThe set up for learning\nTesting the learning\nResponsibility of how you leave the participants\n\nTraining delivery: \n\nProcesses of communication\nDissolving nerves\, extending and working the presentation area\nDevleoping congruence\, charisma and presence of the trainer\nVerbal and non-verbal communication\nGetting the message across\nEvaluation successful communication\nAccelerating and embedding learning\n\nUsing language strategically: \n\nUsing metaphors and stories to communicate complex ideas\nOther language skills\n\nUsing the environment to support learning: \n\nRoom layout\nUsing equipment\nThe psychological impact of the training environment\n\nFacilitating learning: \n\nAdvance use of questioning\nDealing with challenges\nUtilising challenges as part of the learning\nFlexibility of training approach\n\nPresentation tips: \n\nTips for pulling the whole thing together\n\nSelf-management: \n\nDissolving common fears\nHow to do what experienced presenters do\n\nTraining evaluations: \n\nLevels of evaluation\nEvaluating within and beyond the training\n\n  \nTutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace.
URL:https://pitmantrainingscotland.co.uk/event/train-the-trainer-3-day-workshop-3/2025-01-21/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Personal Development Workshops,Seminar Courses,Train the Trainer
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:20250123T090000
DTEND;TZID=Europe/London:20250124T000000
DTSTAMP:20261021T004154
CREATED:20241028T170300Z
LAST-MODIFIED:20241029T134937Z
UID:10004443-1737622800-1737676800@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-01-23/
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;TZID=Europe/London:20250123T093000
DTEND;TZID=Europe/London:20250123T163000
DTSTAMP:20261021T004154
CREATED:20241030T161059Z
LAST-MODIFIED:20250819T133501Z
UID:10004644-1737624600-1737649800@pitmantrainingscotland.co.uk
SUMMARY:Influencing Skills –1-day Workshop
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or virtually via teams. \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nOverview: \nThe aim of this course is to learn how to develop and apply the skills of influential communication. \n  \nObjectives: \n\nTo understand how we are influenced\nHow to tailor your communications for different people and situations\nTo communicate confidently and with purpose\nHow to put across complex ideas in simple\, understandable ways\nHow to use non-verbal behaviour to impact others\nInfluencing through feedback\nDealing with objections\n\nThe topics and timings will reflect the participant’s needs on the day and may cover all or some of the following: \nUnderstanding Influence \nExploring the nature and application of influential communication. Clarifying who you want to influence\, what kind of influencing you want to have and why. \nPrinciples and Skills of Influential Communication \nFundamentals of influential communication. Verbal and non-verbal communication. Congruence and leading behaviour. \nThe Language of Influence \nFind the most attractive language for your listener. Using questions to influence and bring about a certain point of view. Insuring you don’t influence by accident. \nInfluencing though Feedback \nManaging relationships through positive feedback. A gentle method of influencing others around you. \nPresenting Information \nMake persuasive\, memorable\, impactful and inspiring presentations. \nReframing the Meaning of Things \nWe all know a glass can be half empty or half full\, but can we systematically manage or change the meaning of things? \nDealing with Objections \nIntroducing the stages of objection handling. How to manage those who play “Hard Ball” and develop creative solutions. \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or virtually via teams. \nAvailable on our open schedule timetables in Edinburgh and Glasgow.
URL:https://pitmantrainingscotland.co.uk/event/influencing-skills-1-day-workshop-2/2025-01-23/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Influencing Skills,Personal Development Workshops,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR