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:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20231029T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230706
DTEND;VALUE=DATE:20230707
DTSTAMP:20261024T013130
CREATED:20230511T075309Z
LAST-MODIFIED:20230701T183823Z
UID:10000823-1688601600-1688687999@pitmantrainingscotland.co.uk
SUMMARY:Pivot Tables Deep Dive Workshop
DESCRIPTION:Pivot Table in Excel is one of the most powerful features of the software. It allows you to analyse hundreds of rows with just a few clicks.\nIn this ‘Deep Dive’ into the topic\, we will devote the full day to exploring Pivot Tables and how they can be used for Data Analysis. \nWe recommend that you have a basic to intermediate understanding of Microsoft Excel. No prior knowledge of Pivot Tables is required.\nIn this course\, participants will be introduced to Excel pivot tables and then develop a deeper understanding of advanced pivot table features including a high-level introduction to Microsoft Power Pivot \nWhat you will learn: \n\nIntroduction to pivot tables\nConvert data to tables\nAdjust field list settings\nCreate multiple reports with one click\nAdd data bars to pivot tables\nMaster pivot table settings\nAdd and remove calculated fields to pivot tables\nCalculate the difference between columns\nAdd smart custom number formatting\nCreate custom groupings to pivot tables\nGroup dates as unique\nAdd slicers to easily filter data\nAdd dynamic charts\nAdd a timeline to pivot tables\nIntroduction to Microsoft Power Pivot\nDuration: 1 Day \nThis course is delivered on our open schedules in Edinburgh and Glasgow We can also deliver this workshop via a virtual classroom over two half sessions\, using Zoom or Teams.
URL:https://pitmantrainingscotland.co.uk/event/pivot-tables-deep-dive-workshop-2-2/2023-07-06/1/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Pivot Tables Deep Dive Workshop,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230706
DTEND;VALUE=DATE:20230707
DTSTAMP:20261024T013130
CREATED:20230512T101243Z
LAST-MODIFIED:20230701T183823Z
UID:10000838-1688601600-1688687999@pitmantrainingscotland.co.uk
SUMMARY:Influencing Skills
DESCRIPTION:The aim of this course is to learn how to develop and apply the skills of influential communication. \nObjectives: \n\nTo understand how we are influenced\nHow to tailor your communications for different people and situations\nTo communicate confidently and with purpose\nHow to put across complex ideas in simple\, understandable ways\nHow to use non-verbal behaviour to impact others\nInfluencing through feedback\nDealing with objections\nThe topics and timings will reflect the participant’s needs on the day and may cover all or some of the following: \nUnderstanding Influence \nExploring the nature and application of influential communication. Clarifying who you want to influence\, what kind of influence you want to have and why. \nEthics of Influencing \nDon’t move to the dark side! The ethics and responsibilities of influential communication. \nPrinciples and Skills of Influential Communication \nFundamentals of influential communication. Verbal and non-verbal communication. Congruence and leading behaviour. \nDuration: 1 Day \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions. \n\n\n\nThe Language of Influence \nFind the most attractive language for your listener. Using questions to influence and bring about a certain point of view. Insuring you don’t influence by accident. \nInfluencing through Feedback \nManaging relationships through positive feedback. A gentle method of influencing others around you. \nPresenting Information \nMake persuasive\, memorable\, impactful and inspiring presentations. \nReframing the Meaning of Things \nWe all know a glass can be half empty or half full\, but how can we systematically manage or change the meaning of things? \nDealing with Objections \nIntroducing the stages of objection handling. How to manage those who play “Hard Ball” and develop creative solutions. \n\n\n\n\nDuration: 1 Day \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.
URL:https://pitmantrainingscotland.co.uk/event/influencing-skills-7-2/2023-07-06/1/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Influencing Skills,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:20230706
DTEND;VALUE=DATE:20230707
DTSTAMP:20261024T013130
CREATED:20230511T075309Z
LAST-MODIFIED:20230701T183823Z
UID:10002136-1688630400-1688662800@pitmantrainingscotland.co.uk
SUMMARY:Pivot Tables Deep Dive Workshop
DESCRIPTION:Pivot Table in Excel is one of the most powerful features of the software. It allows you to analyse hundreds of rows with just a few clicks.\nIn this ‘Deep Dive’ into the topic\, we will devote the full day to exploring Pivot Tables and how they can be used for Data Analysis. \nWe recommend that you have a basic to intermediate understanding of Microsoft Excel. No prior knowledge of Pivot Tables is required.\nIn this course\, participants will be introduced to Excel pivot tables and then develop a deeper understanding of advanced pivot table features including a high-level introduction to Microsoft Power Pivot \nWhat you will learn: \n\nIntroduction to pivot tables\nConvert data to tables\nAdjust field list settings\nCreate multiple reports with one click\nAdd data bars to pivot tables\nMaster pivot table settings\nAdd and remove calculated fields to pivot tables\nCalculate the difference between columns\nAdd smart custom number formatting\nCreate custom groupings to pivot tables\nGroup dates as unique\nAdd slicers to easily filter data\nAdd dynamic charts\nAdd a timeline to pivot tables\nIntroduction to Microsoft Power Pivot\nDuration: 1 Day \nThis course is delivered on our open schedules in Edinburgh and Glasgow We can also deliver this workshop via a virtual classroom over two half sessions\, using Zoom or Teams.
URL:https://pitmantrainingscotland.co.uk/event/pivot-tables-deep-dive-workshop-2-2/2023-07-06/2/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Pivot Tables Deep Dive Workshop,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230706
DTEND;VALUE=DATE:20230707
DTSTAMP:20261024T013130
CREATED:20230512T101243Z
LAST-MODIFIED:20230701T183823Z
UID:10002174-1688630400-1688662800@pitmantrainingscotland.co.uk
SUMMARY:Influencing Skills
DESCRIPTION:The aim of this course is to learn how to develop and apply the skills of influential communication. \nObjectives: \n\nTo understand how we are influenced\nHow to tailor your communications for different people and situations\nTo communicate confidently and with purpose\nHow to put across complex ideas in simple\, understandable ways\nHow to use non-verbal behaviour to impact others\nInfluencing through feedback\nDealing with objections\nThe topics and timings will reflect the participant’s needs on the day and may cover all or some of the following: \nUnderstanding Influence \nExploring the nature and application of influential communication. Clarifying who you want to influence\, what kind of influence you want to have and why. \nEthics of Influencing \nDon’t move to the dark side! The ethics and responsibilities of influential communication. \nPrinciples and Skills of Influential Communication \nFundamentals of influential communication. Verbal and non-verbal communication. Congruence and leading behaviour. \nDuration: 1 Day \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions. \n\n\n\nThe Language of Influence \nFind the most attractive language for your listener. Using questions to influence and bring about a certain point of view. Insuring you don’t influence by accident. \nInfluencing through Feedback \nManaging relationships through positive feedback. A gentle method of influencing others around you. \nPresenting Information \nMake persuasive\, memorable\, impactful and inspiring presentations. \nReframing the Meaning of Things \nWe all know a glass can be half empty or half full\, but how can we systematically manage or change the meaning of things? \nDealing with Objections \nIntroducing the stages of objection handling. How to manage those who play “Hard Ball” and develop creative solutions. \n\n\n\n\nDuration: 1 Day \nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.
URL:https://pitmantrainingscotland.co.uk/event/influencing-skills-7-2/2023-07-06/2/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Influencing Skills,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