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:20231024
DTEND;VALUE=DATE:20231025
DTSTAMP:20261024T060438
CREATED:20230511T075309Z
LAST-MODIFIED:20230701T183823Z
UID:10000824-1698134400-1698166800@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-10-24/
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
END:VCALENDAR