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:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20241216T093000
DTEND;TZID=UTC:20241216T163000
DTSTAMP:20261022T072248
CREATED:20231127T171857Z
LAST-MODIFIED:20231127T171949Z
UID:10004121-1734341400-1734366600@pitmantrainingscotland.co.uk
SUMMARY:Pivot Tables Deep Dive
DESCRIPTION:In this ‘Deep Dive’ topic\, we will devote the full day to exploring Pitvot Tables and how they can be used for Data Analysis. We recommend that you have a basic to intermediate understanding of Microsoft Excel but no prior knowledge of Pivot Tables is required. \n\n\n\n\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\n\nThis seminar is also available on demand by virtual classroom. Contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/pivot-tables-deep-dive/2024-12-16/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Pivot Tables Deep Dive Workshop,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