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;VALUE=DATE:20251127
DTEND;VALUE=DATE:20251128
DTSTAMP:20261018T122409
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004790-1764230400-1764262800@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/2025-11-27/
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
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251127
DTEND;VALUE=DATE:20251128
DTSTAMP:20261018T122409
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004441-1764234000-1764262800@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-2/2025-11-27/
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
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251127T093000
DTEND;TZID=Europe/London:20251128T120000
DTSTAMP:20261018T122409
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004467-1764235800-1764331200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-3/2025-11-27/
LOCATION:Virtual Classroom
CATEGORIES:Excel Advanced,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:20251127T093000
DTEND;TZID=Europe/London:20251128T163000
DTSTAMP:20261018T122409
CREATED:20241030T160446Z
LAST-MODIFIED:20250819T133028Z
UID:10004634-1764235800-1764347400@pitmantrainingscotland.co.uk
SUMMARY:Executive PA/ Secretary- 2-day Workshop
DESCRIPTION:Duration: 2 days \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nOverview: \nThe role of the Exec PA is constantly evolving. Many managers and their colleagues see PA’s and Executive Assistants as an essential functional part of their organisation\, they don’t always realise or acknowledge what they do or realise the critical role they play towards the success and profitability of a company. \nWhether your role involves organising events\, managing your manager’s diary\, providing administration support or managing the office; it is essential tat you can priorities\, manage your time well and effectively communicate. \nThis course will help you to excel in whatever PA role you find yourself in. \nIt will facilitate real change in the way you communicate\, by helping you develop your role and understand how it relates to the pressures on a manager and the business. \nThis workshop is perfect for PA’s\, Secretaries and Executive Assistants and you will find plenty of opportunities to share experiences and explore skills in a motivating and non-threatening environment\, with lots of hints and tips thrown in along the way. \n  \nObjectives – At the end of the course you will be able to: \n\nTo properly understand the role of the Executive Secretary/ Personal Assistant\nTo learn to communicate effectively at all levels\nTo organize your time and your boss’s time more efficiently\nTo understand how to set priorities and stick to them\nTo acquire basic management skills\n\nWhat you will learn: \n\nTo identify the key areas for your development in this job role.\nTo manage your boss successfully: making relationships work\, developing your network\, communication\, and the importance of feedback.\nTo communicate effectively: questioning and listening techniques\, learn how to be assertive and stay in control.\nTo deal with difficult people.\nTo manage your time effectively: setting objectives\, planning and prioritising tasks.\nTo develop personal management skills: delegating successfully\, problem solving and decision making.\n\n  \nWho should attend? \nPA’s who wish to increase the contribution they make to their organisation. It is also aimed at Secretaries who wish to develop and move up to the role of a PA. \n  \nDuration: 2 days \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/executive-pa-secretary-2-day-workshop/2025-11-27/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Executive PA,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
END:VCALENDAR