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:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260709T093000
DTEND;TZID=Europe/London:20260709T163000
DTSTAMP:20260802T070124
CREATED:20241030T155457Z
LAST-MODIFIED:20250819T132611Z
UID:10005030-1783589400-1783614600@pitmantrainingscotland.co.uk
SUMMARY:Communication Skills –1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver training onsite at your own workplace. We can also offer virtual classroom training via Zoom if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow \nOverview: \nEffective communication is key in every situation we find ourselves in\, whether it is work related or in personal life. We all know or work with people\, whom we respect as effective communicators\, but what is it about their behaviour that we aspire to and how do they do it? How is it that they are not only able to express themselves fully but can also get to the heart of what is important to the people around them? \nMost of us communicate well in many situations; however\, occasionally we need a little help. The first step is realising that you can learn new communication skills and that these are not solely in the domain of gifted communicators. \nIn which situations would you find it useful to convey yourself as a confident and articulate individual? Whether you want to communicate with more impact or build rapport with a colleague or client; improving your communication skills will help you meet these challenges. \nThis special workshop is ideal for those who need to build effective working relationships or depend on effective communication in critical situations. It will also benefit those who would like to develop their own skills and confidence in communication generally. \n  \n  \nObjectives: \n\nRevisit the foundation of effective communication\nFrame communications positively\nRemaining in control of time spent on conversations\nGiving positive feedback\nHaving difficult conversations\n\n  \nWhat you will learn: \n\nPractical verbal and non-verbal communication\nThe importance of rapport and how to build relationships\nMethods of organising your thinking to convey the message you really mean\nTo use precise questioning skills to control and move the conversation along\nHow to communicate carefully in difficult situations\nHow to resolve conflict and open up the communication\nHow to implement changes on return to office\n\n  \nDuration: 1 day \nWe can deliver training onsite at your own workplace. We can also offer virtual classroom training via Zoom if preferred. \n  \nAvailable on our open schedule timetables in Edinburgh and Glasgow
URL:https://pitmantrainingscotland.co.uk/event/communication-skills-1-day-workshop/2026-07-09/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Communication Skills,Edinburgh,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;VALUE=DATE:20260709
DTEND;VALUE=DATE:20260710
DTSTAMP:20260802T070124
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004864-1783589400-1783616400@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-2-2/2026-07-09/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR