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:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20231029T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20231107
DTEND;VALUE=DATE:20231108
DTSTAMP:20261023T190037
CREATED:20230511T072115Z
LAST-MODIFIED:20230701T183829Z
UID:10001023-1699344000-1699376400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
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\n\n\n\nWhat you will learn: \nMacros \n\nEditing & Deleting Macros\nRecord Macros\nCustomising Ribbon\n\nReview Data \n\nTrack Changes\nAuditing Tools\nWatch Window Review\nChanges Restricting\nData Area\n\nUtilities \n\nGoal Seek\nData Consolidation\nPower View Reports\nCreate Scenarios\nWhat – If Analysis\nDrawing Diagrams Recommended Pivot Tables\n\n\n\nAdditional Items \n\nIfAnd/IfOr FormulaIfNa Formula\nConvert to Table Screenshots\nRemoving Duplicates Filter Timeline\nIfError\, HLookups\, Sparklines\, Pivot Tables\, Flash Fill\n\n\n\n\n\nTel 0131 556 5650 \n\n\nTel 0141 223 0090 \n\n\n\n\nDuration: 1 Day \n\n\n\n\nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-8-2/2023-11-07/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20231107
DTEND;VALUE=DATE:20231108
DTSTAMP:20261023T190037
CREATED:20230512T090339Z
LAST-MODIFIED:20230701T183825Z
UID:10000983-1699344000-1699376400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate
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\n\n\n\nWhat you will learn: \nFormula \nVLookups\nIF Statements\nSumIf\nCountIf(s)\nText Formula – Concatenate Linking Spreadsheets Separating Text Data \nData Analysis \nAdvanced Sort Options Filters\nSubtotals\nUpdating Pivots \nIcons & Data Bars in Conditional Formatting Filter & Sort Using Colour \n\n\nUtilities \nProtecting Data\nHide & Unhide Data Named Ranges\nWorking With Dates Working With Comments Data Validation Headers & Footers \nLinking Data \nLinking Spreadsheets Identifying Links\nLinking Separate Workbooks \nPivot Tables \nCreating Pivot Tables Pivot Charts\nSlicers\nRefreshing Data Updating Ranges \n\n\n\n\nDuration: 1 Day \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-8-2/2023-11-07/
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:20231107
DTEND;VALUE=DATE:20231109
DTSTAMP:20261023T190037
CREATED:20230511T081345Z
LAST-MODIFIED:20230701T183818Z
UID:10000950-1699349400-1699462800@pitmantrainingscotland.co.uk
SUMMARY:Executive PA
DESCRIPTION:Executive PA/Secretary – Tutor Led \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 that you can prioritise\, 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 understanding 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. \nDuration: 2 Days \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \n\n\n\nObjectives: \n\nTo properly understand the role of the Executive Secretary/ Personal Assistant\nTo learn to communicate effectively at all levels\nTo organise your time and your boss’s time more efficiently\nTo understand how to set priorities and stick to them\nTo acquire basic management skills What you will learn:\n\n\nTo identify the key areas for your development in this job role.\nTo manage your boss successfully: making relationships work\, developing yournetwork\, communication and the importance of feedback.\nTo communicate effectively: questioning and listening techniques\, learn howto be assertive and stay in control.\nTo deal with difficult people.\nTo manage your time effectively: setting objectives\, planning and prioritisingtasks.\nTo develop personal management skills: delegating successfully\, problemsolving and decision making.\nWho should attend? \nPA’s who wish to increase the contribution they make to their organisation. It is also aimed as Secretaries who wish to develop and move up to the role of a PA. \nDuration: 2 Days \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 4 half day sessions. \nAvailable on our open schedule timetables in Edinburgh and Glasgow.
URL:https://pitmantrainingscotland.co.uk/event/executive-pa-6-2/2023-11-07/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Executive PA,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