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:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251104T090000
DTEND;TZID=Europe/London:20251105T120000
DTSTAMP:20260904T175640
CREATED:20241029T134139Z
LAST-MODIFIED:20241029T134222Z
UID:10004519-1762246800-1762344000@pitmantrainingscotland.co.uk
SUMMARY:PowerPoint Advanced – Tutor Led
DESCRIPTION:For individuals who are already using PowerPoint to an introductory level. This course will streamline and perfect their PowerPoint skills by teaching the more advanced features available in the package. \n  \nWhat you will learn: \n\n\n\nMaster Slides\nInsert Data\n\n\n·      Creating Master Slides\n·      Insert Sound Files\n\n\n·      Formatting Masters\n·      Insert Video Clips\n\n\n·      Hand-Out Masters\n·      Working with Sound & Video\n\n\n·      Headers & Footers\n·      Creating Hyperlinks\n\n\n·      Page Numbers\n·      Embed Objects\n\n\n\n\n\n\nCustom & Auto Timings\nOther\n\n\n·      Creating Custom Shows\n·      Add multiple Effects\n\n\n·      Ink Annotations when running slides\n·      Motion Paths\n\n\n·      Set Options for Custom Shows\n·      Re-Using Slides\n\n\n·      Running Custom Shows\n·      Screenshots\n\n\n·      Create an Agenda Slide\n·      Insert Objects\n\n\n·      Rehearse Timings\n·      New Animation\n\n\n·      Loop Continuously\n·      New Transition\n\n\n·      Setting up Presenters View\n·      Reading View\n\n\n·      Using Online Video\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/powerpoint-advanced-tutor-led-3/2025-11-04/
LOCATION:Virtual Classroom
CATEGORIES:Powerpoint 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:20251106T090000
DTEND;TZID=Europe/London:20251107T000000
DTSTAMP:20260904T175641
CREATED:20241028T170300Z
LAST-MODIFIED:20241029T134937Z
UID:10004447-1762419600-1762473600@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-11-06/
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:20251111T090000
DTEND;TZID=Europe/London:20251112T120000
DTSTAMP:20260904T175641
CREATED:20241029T141942Z
LAST-MODIFIED:20241029T141942Z
UID:10004565-1762851600-1762948800@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Word Introduction – Tutor Led
DESCRIPTION:For individuals who have never used a Word processing package before or have only used Word for limited tasks. At the end of the day you will be able to create professional looking Word documents. \n  \nWhat you will learn: \n\n\n\nIntroduction\nParagraph Formatting\n\n\n·      Screen Layout – Ribbon Bar\n·      Setting Tabs\n\n\n·      Entering/ Edit Text\n·      Using Bullets & Numbers\n\n\n·      Spell & Grammar Checking\n·      Paragraph Spacing\n\n\n·      Change Case\n·      Borders & Shading\n\n\n·      Saving Documents\n·      Watermarks\n\n\n·      Creating New Documents\n \n\n\n·      Saving as Different Versions\nPrinting\n\n\n \n·      Print Preview\n\n\nFormatting\n·      Applying page settings\n\n\n·      Selecting Text\n·      Page Layouts\n\n\n·      Moving Text – Copy\, Cut & Paste\n·      Page Numbering\n\n\n·      Navigating a Document\n·      Basic Headers & Footers\n\n\n·      Full Formatting Text Options\n·      Page Breaks\n\n\n·      Aligning Text\n \n\n\n·      Applying Text Styles\n \n\n\n \n \n\n\nOther\n \n\n\n·      Basic Tables\n \n\n\n·      Pictures\n \n\n\n·      Word Art\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/microsoft-word-introduction-tutor-led-3/2025-11-11/
LOCATION:Virtual Classroom
CATEGORIES:Seminar Courses,Virtual Class,Word Introduction
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251120T093000
DTEND;TZID=Europe/London:20251121T120000
DTSTAMP:20260904T175641
CREATED:20241029T142724Z
LAST-MODIFIED:20241029T142724Z
UID:10004580-1763631000-1763726400@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Word Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Word to an Intermediate level. This course will streamline and perfect your Word skills by teaching the advanced features available in the Word package. \nWhat you will learn: \n\n\n\nTables\nParagraph\n\n\n·      Creating Tables\n·      Page & Section Breaks\n\n\n·      Altering Table Rows & Columns\n·      Linking Headers\n\n\n·      Deleting Tables\n·      Applying Text Styles\n\n\n·      Entering Dates\n·      Using Styles\n\n\n·      Table Layouts\n·      Modifying & Create Styles\n\n\n·      Formatting Tables\n·      Create Table of Contents\n\n\n·      Sorting Data\n \n\n\n·      Drawing Tables\nQuick Parts\n\n\n \n·      Creating Quick Parts\n\n\nCharts & Pictures\n·      Modify & Edit\n\n\n·      Creating Charts\n·      Deleting Quick Parts\n\n\n·      Editing Charts\n \n\n\n·      Formatting Charts\nOther\n\n\n·      Moving & Re-Sizing Charts\n·      Creating Columns\n\n\n·      Changing Chart Type\n·      Using Templates\n\n\n·      Insert Clip Art\n·      Introduction to Mail Merge\n\n\n·      Insert Pictures\n·      Protecting Documents\n\n\n·      Working with Pictures\n·      Working with Comments\n\n\n·      Text Wrap Pictures\n·      Drawing Diagrams\n\n\n \n·      Screenshots\n\n\n \n·      Front Covers\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/microsoft-word-intermediate-tutor-led-3/2025-11-20/
LOCATION:Virtual Classroom
CATEGORIES:Seminar Courses,Virtual Class,Word Intermediate
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:20260904T175641
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
END:VCALENDAR