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;VALUE=DATE:20250129
DTEND;VALUE=DATE:20250130
DTSTAMP:20261020T220648
CREATED:20241029T130519Z
LAST-MODIFIED:20250819T121953Z
UID:10004468-1738108800-1738195199@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Power BI Introduction -Tutor Led
DESCRIPTION:We 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/2025-01-29/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Power BI Introduction,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:20250129
DTEND;VALUE=DATE:20250131
DTSTAMP:20261020T220648
CREATED:20241029T140634Z
LAST-MODIFIED:20250819T124543Z
UID:10004534-1738108800-1738281599@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-2/2025-01-29/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,MS Project Complete,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20250129T093000
DTEND;TZID=Europe/London:20250130T120000
DTSTAMP:20261020T220648
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004463-1738143000-1738238400@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-01-29/
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