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:20230515
DTEND;VALUE=DATE:20230516
DTSTAMP:20261024T202721
CREATED:20230511T072115Z
LAST-MODIFIED:20230701T183829Z
UID:10001021-1684108800-1684195199@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-05-15/1/
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:20230515
DTEND;VALUE=DATE:20230516
DTSTAMP:20261024T202721
CREATED:20230511T072343Z
LAST-MODIFIED:20230701T183829Z
UID:10000956-1684108800-1684195199@pitmantrainingscotland.co.uk
SUMMARY:Power BI Intermediate
DESCRIPTION:Learn how you can leverage Power BI to easily build reports and dashboards with \n\n\n\n\ninteractive visualisations. Connect to and visualise any data using the unified\, scalable \n\n\n\n\nplatform for self-service and enterprise business intelligence (BI) that’s easy to use and \n\n\n\n\nhelps you gain deeper data insight. \n\n\n\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 workspaces and datasets in Power BI\nOptimise a model for performance\nPlease note:\n\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 Office 365 is recommended. Microsoft Power BI requires a separate licence in addition to Microsoft Office. Learners will require this additional licence to perform the exercises on their own computers.\nA stable Internet connection is required. Having a second display is beneficial but not required.\nDuration: 1 Day \nPlease contact the Course Advisor to arrange training dates \nPitman Training Edinburgh Pitman Training Glasgow
URL:https://pitmantrainingscotland.co.uk/event/power-bi-intermediate-2-2/2023-05-15/1/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Power BI 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;VALUE=DATE:20230515
DTEND;VALUE=DATE:20230516
DTSTAMP:20261024T202721
CREATED:20230511T072115Z
LAST-MODIFIED:20230701T183829Z
UID:10002123-1684137600-1684170000@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-05-15/2/
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:20230515
DTEND;VALUE=DATE:20230516
DTSTAMP:20261024T202721
CREATED:20230511T072343Z
LAST-MODIFIED:20230701T183829Z
UID:10002125-1684137600-1684170000@pitmantrainingscotland.co.uk
SUMMARY:Power BI Intermediate
DESCRIPTION:Learn how you can leverage Power BI to easily build reports and dashboards with \n\n\n\n\ninteractive visualisations. Connect to and visualise any data using the unified\, scalable \n\n\n\n\nplatform for self-service and enterprise business intelligence (BI) that’s easy to use and \n\n\n\n\nhelps you gain deeper data insight. \n\n\n\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 workspaces and datasets in Power BI\nOptimise a model for performance\nPlease note:\n\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 Office 365 is recommended. Microsoft Power BI requires a separate licence in addition to Microsoft Office. Learners will require this additional licence to perform the exercises on their own computers.\nA stable Internet connection is required. Having a second display is beneficial but not required.\nDuration: 1 Day \nPlease contact the Course Advisor to arrange training dates \nPitman Training Edinburgh Pitman Training Glasgow
URL:https://pitmantrainingscotland.co.uk/event/power-bi-intermediate-2-2/2023-05-15/2/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Power BI 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
END:VCALENDAR