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:20250313
DTEND;VALUE=DATE:20250320
DTSTAMP:20261020T130618
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004857-1741824000-1742428799@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-03-13/
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:20250318
DTEND;VALUE=DATE:20250320
DTSTAMP:20261020T130618
CREATED:20250220T101125Z
LAST-MODIFIED:20250305T144040Z
UID:10004707-1742256000-1742428799@pitmantrainingscotland.co.uk
SUMMARY:Supervisory Skills – 2-day Workshop
DESCRIPTION:CONTACT US TO ARRANGE DATES SUITABLE TO YOU.  \nAvailable on our open schedule timetables in Edinburgh and Glasgow \nSupervisory Skills 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 \nv  The Project Planning Process: \nØ  Scheduling – PERT Charts \nØ  Identifying the critical path \nØ  Assigning Resources \nØ  Calculating the Budget \nØ  Gantt Chart Overview \n  \nv  Case Study Part 2 \nv  Risk 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: \nv  Course Introduction & Overview \nv  Project 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  \nv  Project Teams: \nØ  Matrix Management \nØ  The role of the Project Management \n  \nv  Project Manager – Skills & Attributes \nv  Team Selection & Team Building \nv  Project 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
URL:https://pitmantrainingscotland.co.uk/event/project-management-principles-2-day-workshop-3/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Seminar Courses,Supervisory Skills
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:20250319
DTEND;VALUE=DATE:20250320
DTSTAMP:20261020T130618
CREATED:20241029T131405Z
LAST-MODIFIED:20250819T122408Z
UID:10004491-1742342400-1742428799@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Power BI Intermediate-Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nLearn how you can leverage Power BI to easily build reports and dashboards with interactive visualisations. Connect to and visualise any data using the unified\, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deep data insight. \n  \nAttending this workshop will help you to: \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\nVisualise data in Power BI\nData analysis in Power BI\nManage workspace and datasets in Power BI\nOptimise a model for performance\n\nPlease note: \n\nIn this course\, participants will perform practical use-case learning exercises to prepare them to be able to confidently develop and style their own Power BI dashboards and manage\, analyse and modify data\nAttending this course will require learners to have a basic understanding of Microsoft Power BI and a basic understanding of Microsoft Office365 is recommended. Microsoft Power BI requires a separate licence in addition to Microsoft Office. Learners will require this additional licence to preform the exercises on their own computers.\nA stable Internet connection is required. Having a second display is beneficial but not required\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-intermediate-tutor-led-2/2025-03-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
END:VCALENDAR