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:20260707
DTEND;VALUE=DATE:20260708
DTSTAMP:20260802T113459
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004877-1783416600-1783443600@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-07-07/
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:20260707
DTEND;VALUE=DATE:20260709
DTSTAMP:20260802T113459
CREATED:20241030T163909Z
LAST-MODIFIED:20250819T140003Z
UID:10005100-1783416600-1783528200@pitmantrainingscotland.co.uk
SUMMARY:Presentation skills – 2-day Workshop
DESCRIPTION:Talk and present with confidence and impact.\nDo you find yourself avoiding situations where you will be asked to talk or present an idea? You know your stuff but the thought of having to stand up in front of an audience fills you with worry and panic? \nOR \nYou may be “stuck in a rut” with your presentations or public speaking engagements and need to add impact to inspire and motivate your audience. \nThis training experience is suitable for both inexperienced and experienced presenters who feel they need to refresh and improve their delivery and motivate their audience. It has been developed for people who are required to give effective and stimulating presentations and talks. \nALL speakers have nerves! Most of us fear standing up in front of an audience and presenting\, however\, you can learn to overcome this natural fear by learning techniques that will allow you to deliver a memorable presentation. \nThis 2 day course will help you hone your skills and give you the tools and space to practice delivering you message in a creative and confident manner. Classes are small and mainly experimental\, allowing the trainer to focus and coach whilst reflecting on your particular challenges and requirements. \nObjectives: \n\nTo overcome the natural fear of speaking to an audience and use nervousness to your advantage\nTo design a presentation that people remember\nTo understand and gain the non-verbal skills all good speakers need\nTo develop presence and confidence when speaking to a group\nTo connect with your audience and make them listen\nTo use pace to influence and impact listeners\nTo deliver engaging and memorable presentations\n\n  \nDuration: 2 Days\nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/presentation-skills-2-day-workshop-4/2026-07-07/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Edinburgh,Personal Development Workshops,Presentation Skills,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR