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
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20250123T090000
DTEND;TZID=Europe/London:20250124T000000
DTSTAMP:20261008T140556
CREATED:20241028T170300Z
LAST-MODIFIED:20241029T134937Z
UID:10004443-1737622800-1737676800@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-01-23/
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;VALUE=DATE:20250122
DTEND;VALUE=DATE:20250123
DTSTAMP:20261008T140556
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004456-1737504000-1737590399@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor 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-2/2025-01-22/
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;TZID=Europe/London:20250121T093000
DTEND;TZID=Europe/London:20250123T163000
DTSTAMP:20261008T140556
CREATED:20241030T171328Z
LAST-MODIFIED:20250819T145436Z
UID:10004767-1737451800-1737649800@pitmantrainingscotland.co.uk
SUMMARY:Train the Trainer – 3-day Workshop
DESCRIPTION:Tutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace. \nCPD Accredited \nTutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace. \nAim: \nThis course will introduce participants to the issues\, methodologies and techniques of training design and delivery. \nObjectives: \nBy the end of this workshop\, participants will be able to: \n\nIdentify training needs.\nDefine and create aims and objectives that fit within an organisational perspective.\nDesign training sessions.\nDeliver training sessions that incorporate the trainer’s personality – metaphors\, stories. and humour.\nEvaluate training interventions.\nDealing with difficult delegates.\n\nThe training systematically points to everything you need to know about being a trainer. Each day consists of practical experience as well as hundreds of useful tips and techniques. \nWhile the first part of the course concentrates on the design and structure of training as a learning tool; it then moves on to presentation\, delivery and facilitation so each day builds up to complete a full training methodology. \n  \nDuration: 3 days \n  \nThe information shown below is the structure of the course – timings and emphasis will vary depending on participants’ needs. \nIntroduction: \n\nLogistics and participant introductions\nAims and objectives\n\nAiming for successful training: \n\nExploring the varying factors that can impact on successful training\nPersonal preferences in training experiences\nScope of training within organisations\nHow these fit together\n\nTraining needs: \n\nIssues in defining and managing training needs\nLevels of needs and methods of identifying them\n\nTraining as a ‘Change Intervention’: \n\nIdentifying thpes of learning and changes possible\nPlanning for and organizing change through training\n\nCreating and using training aims and objectives: \n\nDifferences and uses of ‘Aims and Objectives’\nCriteria of ‘Aims and Objectives’\nBenefits and limitations of ‘Aims and Objectives’\n\nTraining planning and design: \n\nStructuring the training\nPriorities for inclusion in the training\nThe set up for learning\nTesting the learning\nResponsibility of how you leave the participants\n\nTraining delivery: \n\nProcesses of communication\nDissolving nerves\, extending and working the presentation area\nDevleoping congruence\, charisma and presence of the trainer\nVerbal and non-verbal communication\nGetting the message across\nEvaluation successful communication\nAccelerating and embedding learning\n\nUsing language strategically: \n\nUsing metaphors and stories to communicate complex ideas\nOther language skills\n\nUsing the environment to support learning: \n\nRoom layout\nUsing equipment\nThe psychological impact of the training environment\n\nFacilitating learning: \n\nAdvance use of questioning\nDealing with challenges\nUtilising challenges as part of the learning\nFlexibility of training approach\n\nPresentation tips: \n\nTips for pulling the whole thing together\n\nSelf-management: \n\nDissolving common fears\nHow to do what experienced presenters do\n\nTraining evaluations: \n\nLevels of evaluation\nEvaluating within and beyond the training\n\n  \nTutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace.
URL:https://pitmantrainingscotland.co.uk/event/train-the-trainer-3-day-workshop-3/2025-01-21/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Personal Development Workshops,Seminar Courses,Train the Trainer
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;TZID=Europe/London:20250120T093000
DTEND;TZID=Europe/London:20250121T163000
DTSTAMP:20261008T140556
CREATED:20241030T160635Z
LAST-MODIFIED:20250819T132833Z
UID:10004635-1737365400-1737477000@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-2/2025-01-20/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Executive PA,Glasgow,Personal Development Workshops,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250120
DTEND;VALUE=DATE:20250121
DTSTAMP:20261008T140556
CREATED:20241030T152218Z
LAST-MODIFIED:20250819T131010Z
UID:10004581-1737331200-1737417599@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Word Advanced – 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 Word to an Intermediate level. This course will streamline and perfect your Word skills by teaching the advanced features available in the Word package. \n  \nWhat you will learn: \n\n\n\nMail Merge\nUtilities\n\n\n·      Creating Mail Merge\n·      Creating Foot & Endnotes\n\n\n·      Merge Envelopes & Lables\n·      Creating Front Cover Pages\n\n\n·      Creating Data Sources\n·      Create an Index\n\n\n·      Editing Data Sources\n·      Captions\n\n\n\n·      Collaborating with other Documents\n\n\nTracking\n·      Cross-reference\n\n\n·      Tracking Changes\n·      Recording Macros\n\n\n·      Accept/ Reject Options\n·      Edit and Remove Macros\n\n\n·      Viewing Tracking Changes\n·      Embedding Objects\n\n\n·      Compare Document Versions\n·      Online Video\n\n\n\n·      Design Themes\n\n\nForms\n·      Backstage Features\n\n\n·      Creating User Forms\n\n\n\n·      Save and Protect Forms\n\n\n\n·      Editing Forms\n\n\n\n·      Create Drop Lists\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-advanced-tutor-led/2025-01-20/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Seminar Courses,Word Advanced
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:20250117
DTEND;VALUE=DATE:20250118
DTSTAMP:20261008T140556
CREATED:20241028T165138Z
LAST-MODIFIED:20241029T135027Z
UID:10004414-1737104400-1737115200@pitmantrainingscotland.co.uk
SUMMARY:Excel Introduction – Tutor Led
DESCRIPTION:For individuals who have never used the Excel spreadsheet package before or have only used Excel for Limited tasks. At the end of the day you will be able to create professional looking spreadsheets. \n  \nWhat you will learn: \n\n\n\nExcel Introduction\nFormulas\n\n\n·       Viewing Screen Layout – Ribbon Bar\n·       Introduction\n\n\n·       Entre\, Move & Clear Data\n·       Order of Operations\n\n\n·       Selecting Excel Data Areas\n·       Add\, Subtract\, Multiply\, Divide\n\n\n·       Saving Excel\n·       Auto Sum & Auto Average\n\n\n·       Creating New Workbooks\n·       Percentages\n\n\n·       Cut\, Copy & Paste\n·       Absolute Call Referencing\n\n\n·       Naming\, Deleting & Working with Sheets\n\n\n\n\nPrinting\n\n\nData Manipulation\n·       Print Preview\n\n\n·       Widen Rows & Columns\n·       Page Layout\n\n\n·       Inserting Rows & Columns\n·       Headers & Footers & Print Areas\n\n\n·       Moving Data\n\n\n\n·       Deleting Information\nUtilities\n\n\n·       Sorting Options\n·       Introduction to Charts\n\n\n\n·       Freeze Panes\n\n\nFormatting\n·       Intro to Conditional Formatting\n\n\n·       Formatting Numbers\n·       Auto Fill Options\n\n\n·       Formatting Text\n\n\n\n·       Borders & Shading\n\n\n\n·       Align Data\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-introduction-tutor-led-3/2025-01-17/
LOCATION:Virtual Classroom
CATEGORIES:Excel Introduction,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250117
DTEND;VALUE=DATE:20250118
DTSTAMP:20261008T140556
CREATED:20241030T163326Z
LAST-MODIFIED:20250819T135248Z
UID:10004682-1737072000-1737158399@pitmantrainingscotland.co.uk
SUMMARY:Negotiation Skills – 1-day Workshop
DESCRIPTION:Duration: 1 day \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace. \nThis one-day course is designed to equip participants with essential negotiation skills. Participants will leave with a strong foundation in negotiation techniques. \nThe key aims and objectives of this Negotiation Skills course is to introduce you to the knowledge and skills required to negotiate business deals. \n  \nBy the end of this workshop\, you will learn to: \n\nUnderstand what negotiation is and how it is effectively used.\nClearly identify what you want to achieve from negotiation.\nIdentify innovative solutions for potential deal breakers.\nConsider negotiations from the other party’s perspective.\nIdentify potential factors for negotiation.\nRecognise the impact of language and behaviours in the negotiation process.\nSign off deals so that they are clear and binding.\n\n  \nParticipants will have the opportunity to work through practical case studies. If booking a closed event for your just your team\, we can use your own workplace relevant examples. \n  \nDuration: 1 day \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nCan be delivered via virtual classrooms or onsite at your workplace.
URL:https://pitmantrainingscotland.co.uk/event/negotiation-skills-1-day-workshop/2025-01-17/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Negotiation Skills,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:20250117
DTEND;VALUE=DATE:20250118
DTSTAMP:20261008T140556
CREATED:20241030T155228Z
LAST-MODIFIED:20250819T131955Z
UID:10004616-1737072000-1737158399@pitmantrainingscotland.co.uk
SUMMARY:Better Business Writing - 1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver training onsite at your workplace. We can also deliver this course virtually via Teams if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nOverview: \nMost people\, even if they are not involved in business\, have probably written some form of business communication at one time. This may have been a letter of complaint to a company\, or a letter to the bank manager asking for an overdraft. Whatever the reason\, or type of communication\, business writing is something that we are all involved in at some point in our lives. It is therefore important that we know what it is\, how to do it and how to do it well. \nFor some people\, it is a vital skill; according to a survey of employer’s world-wide\, writing correctly and persuasively comes top of the list of skills needed for professional success. \nAlthough business writing can seem a little overwhelming to begin with\, it can be relatively easy to learn – one you understand the basics of what is required. \n  \n  \nThere are several benefits to learning how to write good business documents: \n\nYou can make a good impression on others if your writing is well prepared and produced.\nYou will save time when writing documents\, if you know how to plan and prepare them.\nYoui will save other people time if your documents are clearly written and easy to read.\nYou will create a good impression of yourself to those around you.\nYou will create a good impression of your organization.\n\n  \nCourse program:  NB all timings are approximate. \n9:30am – 10:45am:       Introduction \nWhy it is important? \nThe benefits of good business writing \nGetting back to basics \nGrammar and punctuation \nSpelling \nBREAK \n11:00am – 12:45am:     Writing with impact \nBe clear \nWrite less \nActive verbs \nSetting the tone \nUsing positive v negative language \nCondescension \nCliches and jargon \nWriting with your reader in mind \nNon-sexist language \nLUNCH \n1:30pm – 2:45pm:         Structure ad style \nKnow your audience and know your purpose \nBREAK \n3:00pm – 4:15pm:        Practice \n4:15pm – 4:30pm:        Summary and close \n  \nDuration: 1 day \nWe can deliver training onsite at your workplace. We can also deliver this course virtually via Teams if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow.
URL:https://pitmantrainingscotland.co.uk/event/better-business-writing-1-day-workshop-2/2025-01-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Better Business Writing,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:20250116T090000
DTEND;TZID=Europe/London:20250117T170000
DTSTAMP:20261008T140556
CREATED:20241029T140441Z
LAST-MODIFIED:20250819T124747Z
UID:10004530-1737018000-1737133200@pitmantrainingscotland.co.uk
SUMMARY:MS Project Complete – Tutor Led
DESCRIPTION:Duration: 2 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who have never used Project or have only used Project for limited tasks. At the end of the 2-day session you will be able to create professional looking planning documentation. \nWhat you will learn: \n\n\n\nProject Introduction\nResources\n\n\n·      Ribbon Bar Overview\n·      Creating Resource Calendars\n\n\n·      Tasks Area\n·      Create Resources\n\n\n·      Gantt Chart Area\n·      Assign Resources to Tasks\n\n\n·      View Navigation\n·      Over Allocation\n\n\n·      Starting a Project Overview\n·      Team Planner View\n\n\n·      Project Calendars\n\n\n\n\nGantt Charts\n\n\nCreating Tasks\n·      Formatting Gantt Charts\n\n\n·      Insert Tasks\n·      Altering Gantt Chart Styles\n\n\n·      Delete and Move Tasks\n\n\n\n·      Promote/Demote Tasks\nCompleting Tasks\n\n\n·      Link tasks\n·      Set Baseline\n\n\n·      Manual & Auto Scheduling\n·      Tracking View\n\n\n·      Predecessors\n·      View Reports\n\n\n·      Task Types\n·      Filter Tasks\n\n\n·      Setting Restraints\n·      Percentage Complete\n\n\n·      Adding Task Summary & Outline Numbers\n\n\n\n\nPrinting & Views\n\n\nCosts\n·      Print Preview\n\n\n·      Creating Costs\n·      Page Setup\n\n\n·      Assign Costs to Tasks\n\n\n\n·      Add New Columns\n\n\n\n\n  \nDuration: 2 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/ms-project-complete-tutor-led/2025-01-16/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,MS Project Complete,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:20250116
DTEND;VALUE=DATE:20250117
DTSTAMP:20261008T140556
CREATED:20241028T165138Z
LAST-MODIFIED:20241029T135027Z
UID:10004413-1736985600-1737071999@pitmantrainingscotland.co.uk
SUMMARY:Excel Introduction – Tutor Led
DESCRIPTION:For individuals who have never used the Excel spreadsheet package before or have only used Excel for Limited tasks. At the end of the day you will be able to create professional looking spreadsheets. \n  \nWhat you will learn: \n\n\n\nExcel Introduction\nFormulas\n\n\n·       Viewing Screen Layout – Ribbon Bar\n·       Introduction\n\n\n·       Entre\, Move & Clear Data\n·       Order of Operations\n\n\n·       Selecting Excel Data Areas\n·       Add\, Subtract\, Multiply\, Divide\n\n\n·       Saving Excel\n·       Auto Sum & Auto Average\n\n\n·       Creating New Workbooks\n·       Percentages\n\n\n·       Cut\, Copy & Paste\n·       Absolute Call Referencing\n\n\n·       Naming\, Deleting & Working with Sheets\n\n\n\n\nPrinting\n\n\nData Manipulation\n·       Print Preview\n\n\n·       Widen Rows & Columns\n·       Page Layout\n\n\n·       Inserting Rows & Columns\n·       Headers & Footers & Print Areas\n\n\n·       Moving Data\n\n\n\n·       Deleting Information\nUtilities\n\n\n·       Sorting Options\n·       Introduction to Charts\n\n\n\n·       Freeze Panes\n\n\nFormatting\n·       Intro to Conditional Formatting\n\n\n·       Formatting Numbers\n·       Auto Fill Options\n\n\n·       Formatting Text\n\n\n\n·       Borders & Shading\n\n\n\n·       Align Data\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-introduction-tutor-led-3/2025-01-16/
LOCATION:Virtual Classroom
CATEGORIES:Excel Introduction,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250115
DTEND;VALUE=DATE:20250117
DTSTAMP:20261008T140556
CREATED:20241030T165818Z
LAST-MODIFIED:20250819T144235Z
UID:10004736-1736899200-1737071999@pitmantrainingscotland.co.uk
SUMMARY:Supervisory Skills – 2-day Workshop
DESCRIPTION:CPD Accredited \nTutor led training\, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred. \nOverview: \nGet better results from your team. \nWould enhanced supervisory skills be of benefit to you or any other of your employees? \nAre you a supervisor or team leader who would like to get better results from your team? \nAre you interested in working with an experienced provider of innovative\, effective\, and enjoyable training solutions? \nCompetent and confident supervisors are critical to the success of all organisations – in terms of how they manage their teams\, tasks\, and change. \nThis course develops core supervisory competencies and provides a range of techniques that supervisors can immediately use to enhance the results they get. \nThe course has been designed for new supervisors/ team leaders/ managers or those in these roles who have not received any formal supervisory skills training. \nIt is delivered in a format to engage all learning styles and to stimulate changes in behaviour after the course. Typically\, this involves a mix of trainer-led insight\, delegate participation\, team activity\, practical exercises and learning views. \nOur trainers are experienced in creating positive learning environments where participants feel comfortable in sharing experiences and practicing skills. \nAim: \nThe aim of the course is to provide participants with a range of skills\, methodologies\, and techniques to enhance their ability to supervise people\, tasks and change effectively. \n  \nWhat you will learn: \n\nHow to become a credible supervisor\nHow to communicate successfully\, using verbal and non-verbal modes of communication: asking specific questions and active listening\nHow to prioritise tasks and manage their time more effectively\nHow to delegate appropriate tasks productively\nHow to make well informed decisions\nHow to motivate team members to deliver desired results\nHow to build a positive working environment\nHow to deal with challenging team member and work solutions\n\n  \nDuration: 2 days \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/supervisory-skills-2-day-workshop-5/2025-01-15/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Personal Development Workshops,Seminar Courses,Supervisory Skills
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20250115
DTSTAMP:20261008T140556
CREATED:20241030T170745Z
LAST-MODIFIED:20250819T144958Z
UID:10004752-1736812800-1736899199@pitmantrainingscotland.co.uk
SUMMARY:Time Management – 1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred. \nAvailable on our open schedule timetables in Edinburgh and Glasgow. \nOverview: \nAre you frequently interrupted by your colleagues with questions about the job or requests for advice and decisions? \nDo you sometimes find yourself doing the job of one of your colleagues when they really ought to be doing it themselves? \nDo you work longer hours than those you work with or those you manage? \nDo you habitually take work home every night or at the weekend? \nDoes more of your time get spent working on details\, rather than strategic thinking or planning of management activities? \nDo you have unfinished jobs piling up on your desk or difficulty meeting deadlines? \nIf you answered yes to any of the above\, then spending a little time learning how to manage your time will save you hours! \nThis workshop is ideal for anyone who wishes to improve their self-managing techniques\, achieve more in their working day and gain more balance in their lives. \n  \n  \nDuration: 1 day \nWe can deliver this course 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/time-management-1-day-workshop/2025-01-14/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Personal Development Workshops,Seminar Courses,Time Management
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:20250114
DTEND;VALUE=DATE:20250115
DTSTAMP:20261008T140556
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004431-1736812800-1736899199@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-01-14/
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:20250114
DTEND;VALUE=DATE:20250115
DTSTAMP:20261008T140556
CREATED:20241028T164636Z
LAST-MODIFIED:20250819T120330Z
UID:10004400-1736812800-1736899199@pitmantrainingscotland.co.uk
SUMMARY:Excel Introduction – 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-introduction-tutor-led-2/2025-01-14/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Introduction,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250113
DTEND;VALUE=DATE:20250114
DTSTAMP:20261008T140556
CREATED:20241030T161319Z
LAST-MODIFIED:20250819T133716Z
UID:10004649-1736726400-1736812799@pitmantrainingscotland.co.uk
SUMMARY:Leadership Skills –1-day Workshop
DESCRIPTION:Duration: 1 Day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred. \nOverview: \nAs you develop as a senior manager you need to start to think and handle yourself very differently. You are even less involved in the day to day delivery of the work. Your success depends on your ability to manage your managers as well as mentor and inspire others. \n  \nObjectives: \nTo share methodologies and techniques that will enable you to: \n\nIdentify the main types of leadership\nIdentify the main characteristics of different theories of leadership – trait\, transactional etc.\nDemonstrate an ability to apply different leadership styles and characteristics to different business situations\nDemonstrate an understanding of the problems associated with leading change in an organisation\nDemonstrate an understanding of the advantages and disadvantages of different leadership approaches to a problem\nDevelop emotional intelligence skills\nDemonstrate mentoring techniques\nUnderstanding the importance of starting with your ‘why’\n\n  \n  \nCourse Programme \nReview of Actions from Management Skills Workshop \nLeadership Theories \n\nTrait theories\nBehavioural theories\nContingency theories\nPower and Influence theories\n\nEmotional Intelligence \n\nSelf-assessment\nThe 4 elements of emotional intelligence\nTurning into your semses\nImproving your emotional intelligence\n\nMentoring \n\nKey responsibilities\nMentor agreements\n4 domains of performance\n\nStarting with ‘why’ \n\nThe golden circle\nDiscovering your ‘why’\n\nBring it all together and action planning \nCourse Review \n  \nDuration: 1 Day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/leadership-skills-1-day-workshop/2025-01-13/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Leadership Skills,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:20250113
DTEND;VALUE=DATE:20250114
DTSTAMP:20261008T140556
CREATED:20241029T141624Z
LAST-MODIFIED:20250819T125520Z
UID:10004555-1736726400-1736812799@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Word Introduction – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred \nFor 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-2/2025-01-13/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Word Introduction
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250110
DTEND;VALUE=DATE:20250111
DTSTAMP:20261008T140556
CREATED:20241029T130850Z
LAST-MODIFIED:20250819T122206Z
UID:10004474-1736467200-1736553599@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Power BI Introduction -Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nLearn how to leverage Power BI to easily build reports and dashboards with interactive visualisations. Connect to and visualise multiple data sources and deliver scalable\, enterprise-level business intelligence (BI) that’s easy to use and helps promote deeper insights into corporate data. \n  \nAttending this workshop will provide: \n\nA history of Microsoft’s BI Development\nAn understanding of licensing and sharing implications\nA description of Microsoft’s Power Tools Ecosystem\nAn understanding of BI Terminology and Architecture\nAn introduction to data modelling\nDate and Time – based analysis using calendars\nA comparison between Excel and Power BI Desktop\nDetails on the importance of Power Query\nAn overview of Power Query\nA working knowledge of Power BI Desktop\nThe means to produce your first report and dashboard\nDetails on the various security mechanisms available\n\nPlease note: \n\nIn this course\, participants will perform practical use-case learning exercises to to confidently develop and style their own Power BI dashboards and manage\, analyse and transform data\nAttending this course will require learners to have a basic knowledge of Microsoft Power BI and an understanding of Microsoft Office 365 is recommended. Corporate use of Microsoft Power BI requires additional licences for Microsoft 365. Learners will require at least a Power BI Pro license to perform the exercises on their own computers\nA stable Internet connection is required and having a second display is beneficial but not essential\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-power-bi-introduction-tutor-led-2/2025-01-10/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Power BI Introduction,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250109
DTEND;VALUE=DATE:20250110
DTSTAMP:20261008T140556
CREATED:20241030T162308Z
LAST-MODIFIED:20250819T135018Z
UID:10004667-1736380800-1736467199@pitmantrainingscotland.co.uk
SUMMARY:Meetings and Minutes – 1-day Workshop
DESCRIPTION:Duration: 1 day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred. \nObjectives: \n\nTo understand what meetings are and why we have them\nTo understand the importance of an agenda\nTo identify the key elements of an agenda\nTo introduce different styles of note taking\nTo understand what minutes are and why we need them\nTo learn how to produce appropriate minutes of a meeting\n\n\nWhat you will learn: \n\nThe difference between formal and informal meetings\nHow to set out an agenda\nTips and techniques for note taking\nThe role of the minute taker\nWhat minutes are and the different styles of minutes\nHow to use appropriate language for minutes\n\n  \nWho should attend? \nAnyone who organises and takes minutes at meetings; those who would like to do this role to a professional standard. \n  \nDuration: 1 day \nWe can deliver this course onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/meetings-and-minutes-1-day-workshop/2025-01-09/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Meetings and Minutes,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:20250108
DTEND;VALUE=DATE:20250110
DTSTAMP:20261008T140556
CREATED:20241030T164704Z
LAST-MODIFIED:20250819T142752Z
UID:10004711-1736294400-1736467199@pitmantrainingscotland.co.uk
SUMMARY:Project Management Principles – 2-day Workshop
DESCRIPTION:Duration: 2 days \nAvailable on our open schedule timetables in Edinburgh and Glasgow \nProject Management is a discipline that has evolved in order to coordinate and control resources and activities to achieve specific goals and objectives. It involves decision making\, common sense\, organization\, time management and assertiveness to deliver these goals and objectives within constraints – the primary ones being cope\, time\, and budget. \nCourse Overview: \nThis 2 day course is aimed at individuals who manage small projects\, along with their other everyday tasks and need a broad understanding of the principles of project management. The course provides an overview of project management and introduces areas where other\, more specific training may be beneficial. \nCourse Objectives: \nBy the end of the course\, you will be able to: \n\nIdentify the various stages of the Project Lifecycle\nUnderstand how projects start – the Business Case\nSet objectives\nWrite a ‘Terms of Reference’ for a project\nRecognise the roles and responsibilities within a project\nUnderstand the role of the Project Manager when managing individuals and teams\nUnderstand the importance of a communication plan for a project\nPlan a project using project management techniques: Work Breakdown Structures\, Estimating\, Resource Loading\, Budgeting\nIdentify the critical path through a project\nUnderstand basic elements of risk analysis and management as well as change management\nUnderstand the importance of tracking project progress and project review.\n\n\n\n\nDay 2: \nv  Work Breakdown Structure \nv  Estimating Task Durations \nThe Project Planning Process: \nØ  Scheduling – PERT Charts \nØ  Identifying the critical path \nØ  Assigning Resources \nØ  Calculating the Budget \nØ  Gantt Chart Overview \n  \nCase Study Part 2 \n  \nRisk Analysis Management: \nØ  Identification\, Assessment\, Tolerance and Management \nØ  Tracking Progress \nØ  Change Management \nØ  Post Completion Review \nØ  Course Summary & Close\n\n\n\n\n\n\nCourse Program: \nDay 1: \n  \nCourse Introduction & Overview \nProject Management Overview: \nØ  Definition of Project Management \nØ  The Project Lifecycle \nØ  The Devil’s Triangle \nØ  How Project’s Start –\nThe Business Case \nØ  Terms of Reference and the PID \nØ  Setting SMART Objectives \n  \nProject Teams: \nØ  Matrix Management \nØ  The role of the Project Management \n  \nProject Manager – Skills & Attributes \nTeam Selection & Team Building \nProject Communication: \nØ  Oral & Verbal communication \nØ  Projects Meetings \nØ  Communication Plans and Projects \nØ  Case Study – Part 1 \n \n\n\n\n  \nDuration: 2 days \nAvailable on our open schedule timetables in Edinburgh and Glasgow \n  \n  \n 
URL:https://pitmantrainingscotland.co.uk/event/project-management-principles-2-day-workshop-2/2025-01-08/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Personal Development Workshops,Project Management Principles,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250108
DTEND;VALUE=DATE:20250109
DTSTAMP:20261008T140556
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004419-1736294400-1736380799@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/2025-01-08/
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;TZID=Europe/London:20250107T093000
DTEND;TZID=Europe/London:20250107T163000
DTSTAMP:20261008T140556
CREATED:20241030T155457Z
LAST-MODIFIED:20250819T132611Z
UID:10004621-1736242200-1736267400@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/2025-01-07/
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;TZID=UTC:20241220T133000
DTEND;TZID=UTC:20241220T163000
DTSTAMP:20261008T140556
CREATED:20231128T100740Z
LAST-MODIFIED:20231128T100741Z
UID:10004226-1734701400-1734712200@pitmantrainingscotland.co.uk
SUMMARY:Personal Development Workshops -Assertiveness
DESCRIPTION:Assertiveness \nThis workshop is about helping you recognize your own type of behavior and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. The course will show you how to overcome your natural\, instinctive behavior in situations and learn more effective responses. \n\n\n\n\nWhat you will learn: \n\nWhat is assertive\, aggressive\, and passive behavior?\nWhat effect does this behavior have on you and others?\nUnderstanding our rights and responsibilities.\nRecognizing an assertive response.\nThree steps to assertive behavior\nSaying ‘no’ without feeling guilty.\nComparing constructive criticism and destructive criticism.\nDealing with criticism assertively.
URL:https://pitmantrainingscotland.co.uk/event/personal-development-workshops-assertiveness-2/2024-12-20/
LOCATION:Virtual Classroom
CATEGORIES:Assertiveness,Personal Development Workshops,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241220T093000
DTEND;TZID=UTC:20241220T163000
DTSTAMP:20261008T140556
CREATED:20231128T095017Z
LAST-MODIFIED:20231128T095017Z
UID:10004186-1734687000-1734712200@pitmantrainingscotland.co.uk
SUMMARY:Word Intermediate
DESCRIPTION:For Individuals who are already using Word to an introductory level – this course will streamline and perfect your Word skills by teaching you intermediate features available within the Word application. \nWhat you will learn: \n\nTables – creating tables\, altering tables rows and columns\, deleting tables\, entering date\, table layouts\, formatting tables\, sorting data\, drawing tables.\nParagraph – page and section breaks\, linking headers\, applying text styles\, modifying and create styles\, using styles\, create table of contents.\nCharts and pictures – creating charts\, editing charts\, formatting charts\, moving\, resizing charts\, changing chart type\, insert images\, insert pictures\, working with pictures\, text wrap pictures.\nOther – creating columns\, using templates\, introduction to mail merge\, protecting documents\, working with comments\, drawing diagrams\, screenshots\, front covers.
URL:https://pitmantrainingscotland.co.uk/event/word-intermediate-10/2024-12-20/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Word Intermediate
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241219T133000
DTEND;TZID=UTC:20241219T163000
DTSTAMP:20261008T140556
CREATED:20231128T100740Z
LAST-MODIFIED:20231128T100741Z
UID:10004225-1734615000-1734625800@pitmantrainingscotland.co.uk
SUMMARY:Personal Development Workshops -Assertiveness
DESCRIPTION:Assertiveness \nThis workshop is about helping you recognize your own type of behavior and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. The course will show you how to overcome your natural\, instinctive behavior in situations and learn more effective responses. \n\n\n\n\nWhat you will learn: \n\nWhat is assertive\, aggressive\, and passive behavior?\nWhat effect does this behavior have on you and others?\nUnderstanding our rights and responsibilities.\nRecognizing an assertive response.\nThree steps to assertive behavior\nSaying ‘no’ without feeling guilty.\nComparing constructive criticism and destructive criticism.\nDealing with criticism assertively.
URL:https://pitmantrainingscotland.co.uk/event/personal-development-workshops-assertiveness-2/2024-12-19/
LOCATION:Virtual Classroom
CATEGORIES:Assertiveness,Personal Development Workshops,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241219T093000
DTEND;TZID=UTC:20241219T163000
DTSTAMP:20261008T140556
CREATED:20231128T095536Z
LAST-MODIFIED:20231128T095536Z
UID:10004200-1734600600-1734625800@pitmantrainingscotland.co.uk
SUMMARY:Word Advanced
DESCRIPTION:For individuals who are already using Word to an Intermediate level – this course will streamline and perfect your Word skills by teaching you the advanced features available in the Word application. \nWhat you will learn: \n\nMail Merge – Creating mail merge\, merge envelopes and labels\, creating data sources\, editing data sources.\nTracking – tracking changes\, accept and reject options\, viewing track changes\, compare document versions.\nForms – creating user forms\, save and protect forms\, editing forms\, create drop lists.\nUtilities – creating foot and endnotes\, creating front cover pages\, create an index\, captions\, collaborating with other documents\, cross-referencing\, recording macros\, edit and remover macros\, embedding objects\, online video\, design themes\, backstage features.
URL:https://pitmantrainingscotland.co.uk/event/word-advanced-9/2024-12-19/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Seminar Courses,Word Advanced
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;TZID=UTC:20241219T093000
DTEND;TZID=UTC:20241219T163000
DTSTAMP:20261008T140556
CREATED:20231127T173154Z
LAST-MODIFIED:20231127T173154Z
UID:10004140-1734600600-1734625800@pitmantrainingscotland.co.uk
SUMMARY:Power BI Intermediate
DESCRIPTION:Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified\, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. \nWhat you will learn: \n\nDesign a data model.\nIntroduction to developing with the Microsoft Power Platform.\nUse Dax in Power BI Desktop.\nPublish and share.\nHow to build a Power BI dashboard.\nModel data in Power BI\nData analysis in Power BI\nManage workspaces and datasets in Power BI\nOptimise a model for performance.\nIf attending our virtual classroom courses – you will need to have the Microsoft Power BI license in addition to Microsoft Office. Having a second display is beneficial but not required. \n\n\nThis seminar is available on demand by virtual classroom\, contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/power-bi-intermediate-5/2024-12-19/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Power BI Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241218T093000
DTEND;TZID=UTC:20241218T163000
DTSTAMP:20261008T140556
CREATED:20231128T130030Z
LAST-MODIFIED:20231128T130030Z
UID:10004375-1734514200-1734539400@pitmantrainingscotland.co.uk
SUMMARY:Time Management
DESCRIPTION:This workshop is ideal for anyone who wishes to improve their self-managing techniques\, achieve more in their working day and gain more balance in their lives. Spending 1-day learning how to manage your time – will save you hours! \nWhat you will learn: \n\nTo take an objective look at how you spend your time at work.\nTo prioritize effectively\nHow to establish short- and long-term goals and to achieve results.\nTo be aware of your own style in dealing with work and how this helps to manage yourself more effectively.“Well – arranged time is the surest mark of a well-arranged mind” – Sir Isaac Pitman
URL:https://pitmantrainingscotland.co.uk/event/time-management-12/2024-12-18/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Time Management
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241217
DTEND;VALUE=DATE:20241219
DTSTAMP:20261008T140556
CREATED:20231128T110453Z
LAST-MODIFIED:20231128T110453Z
UID:10004328-1734427800-1734539400@pitmantrainingscotland.co.uk
SUMMARY:Project Management Principles
DESCRIPTION:This 2-day course is aimed at individuals who manage small projects\, along with their other everyday tasks and need a broad understanding of the principles of project management. The course provides an overview of project management and introduces areas where other\, more specific training may be beneficial. \nWhat you will learn: \n\nIdentify the various stages of the Project Lifecycle\nUnderstand how projects start – the business case.\nSet objectives.\nWrite a ‘term of reference’ for a project.\nRecognize the roles and responsibilities within a project.\nUnderstand the role of the project manager when managing individuals and teams.\nUnderstand the importance of a communication plan for a project.\nPlan a project using project management techniques\, work breakdown\, structures\, estimating\, resource loading and budgeting.\nIdentify the critical path through a project.\nUnderstand basic elements of risk analysis and management as well as change management.\nUnderstand the importance of tracking project progress and project review.
URL:https://pitmantrainingscotland.co.uk/event/project-management-principles-9/2024-12-17/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Project Management Principles,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;TZID=UTC:20241217T093000
DTEND;TZID=UTC:20241217T163000
DTSTAMP:20261008T140556
CREATED:20231128T125627Z
LAST-MODIFIED:20231128T125628Z
UID:10004362-1734427800-1734453000@pitmantrainingscotland.co.uk
SUMMARY:Telephone Techniques
DESCRIPTION:This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important part of their job role. \n\n\n\n\nWhat you will learn: \n\nImproved communication skills\nThe importance of voice and attitude\nListening skills and questioning techniques.\nTo sound confident and helpful\nTo understand the caller’s needs\nTo handle awkward calls\nTo take messages\nTo hand over and re-route a call.\n\nThis course is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/telephone-techniques-13/2024-12-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Telephone Techniques
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241217
DTEND;VALUE=DATE:20241218
DTSTAMP:20261008T140556
CREATED:20231115T143810Z
LAST-MODIFIED:20231127T145226Z
UID:10002198-1734426000-1734454800@pitmantrainingscotland.co.uk
SUMMARY:Adobe Illustrator
DESCRIPTION:IT and Adobe Training Workshops \nAVAILABLE IN GLASGOW & EDINBURGH ON DEMAND – PLEASE CONTACT US FOR MORE DETAILS \nAdobe Illustrator \nFor Individuals who are new to illustrator or have only used Illustrator for limited tasks. During the course you will learn the fundamentals of Adobe Illustrator Creative Cloud from our certified Adobe Instructor. Classes are small group sessions guaranteeing time for practical training and questions and feedback from our tutor. \nWhat you will learn: \n\nDesign principles\, digital media theory (vector\, resolution\, raster)\nIllustrator interface\, workspace and navigation\, preferences and colour settings\, rulers\,guides and grids\, colour and colour swatches.\nShape and line tools\, transform and modify elements\, design alignment\, shape builder.\nCombining shapes with the pathfinder\, introduction to pen tool and Bezier curves\, applyingeffects\, drawing with brushes\, import\, link and embed elements.\nWorking with images\, clipping mask\, converting pixels to vector – image tracing\, styling\, andformatting text\, special characters\, Adobe fonts\, colour spaces (RGB\, CMYK)\, export settingsand file formats.\nOutput and optimize work for digital print use\, creative cloud libraries\, hidden gems and shortcuts\, efficiency workflow.
URL:https://pitmantrainingscotland.co.uk/event/adobe-illustrator-2/2024-12-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Adobe Illustrator,Edinburgh,Glasgow,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR