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:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260806
DTEND;VALUE=DATE:20260807
DTSTAMP:20260802T022409
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004878-1786008600-1786035600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor 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/2026-08-06/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,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:20260806
DTEND;VALUE=DATE:20260807
DTSTAMP:20260802T022409
CREATED:20241030T153310Z
LAST-MODIFIED:20250819T131236Z
UID:10005003-1786010400-1786035600@pitmantrainingscotland.co.uk
SUMMARY:Assertiveness – 1-day Workshop
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nOverview: \nHave you ever been in a situation\, perhaps at a business meeting\, where you wanted to say something\, but you didn’t or couldn’t? Or perhaps you have lost your temper or got upset and regretted it afterwards? These are a couple of examples of where assertive communication would have helped. \nAssertion involves standing up for personal rights and expressing thoughts\, feelings and beliefs in direct\, honest\, and appropriate way that do not violate another person’s rights. The basic message in assertion is: ‘This is what I think. This is what I feel. This is how I see the situation.’ This message is said without domination\, humiliating or degrading the other person. \nAssertion involves respect\, not deference. Two types of respect are involved in assertion: respect for oneself (expressing one’s needs and defining one’s rights) as well as respect for the other person’s needs and rights. \nThis workshop is about helping you recognise your own type of behaviour and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. \nThis training course will show you how to overcome your natural\, instinctive behaviour in situations and learn more effective responses. \n  \nWho should attend? \nThis course is designed for people who wish to develop their skills in communicating more assertively and confidently. \n  \nObjectives: \n\nIdentify assertive\, aggressive\, and passive behaviour in others\nIdentify your own behaviour\nIdentify and use a variety of assertive techniques\n\n  \n  \nWhat you will learn: \n\nWhat are assertive\, aggressive and passive behaviours?\nWhat affect these behaviours have on you and others?\nUnderstanding our rights and responsibilities\nRecognising an assertive response\nThree steps to assertive behaviour\nSaying ‘no’ without feeling guilty\nComparing constructive criticism and destructive criticism\nDealing with criticism assertively\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/assertiveness-1-day-workshop-2/2026-08-06/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Assertiveness,Glasgow,Personal Development Workshops,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR