BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Queen's DigiHub - ECPv6.15.18//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Queen's DigiHub
X-ORIGINAL-URL:https://blogs.qub.ac.uk/digitallearning
X-WR-CALDESC:Events for Queen's DigiHub
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
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20270328T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20271031T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260210T093000
DTEND;TZID=Europe/London:20260210T103000
DTSTAMP:20260414T011909
CREATED:20240920T084832Z
LAST-MODIFIED:20260205T141702Z
UID:31596-1770715800-1770719400@blogs.qub.ac.uk
SUMMARY:Excel: Introduction to PivotTables
DESCRIPTION:This is a half day course that includes a presentation and a variety of practical exercises. This is an advanced course aimed at staff who are experienced at using Microsoft Excel 2010 and are interested in finding out more about PivotTables and PivotCharts. PivotTables are a popular Excel tool for dynamically exploring and analysing large datasets in order to summarise data and make informed decisions. PivotCharts are interactive charts that can be used to visualise PivotTable reports to convey information about patterns and trends within the data. PivotTables can take their source data from within Excel or from external sources like databases\, Online Analytical Processing (OLAP) cubes and text files\, and allow users to analyse data without altering the original data source. This course will provide participants with an introduction to PivotTables and will include topics such as adding and removing fields\, applying styles\, filtering data\, changing field settings and creating PivotCharts. \nAimed At: Staff who are experienced at using Microsoft Excel 2007/2010 and are interested in finding out more about PivotTables and PivotCharts. Also\, useful for those interested in taking the ECDL Advanced module in Spreadsheets. \nPrerequisites: Participants should have completed Excel 1: Essentials before attending this course or should have significant previous experience of using Excel 2007/2010. \n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/excel-introduction-to-pivottables/
LOCATION:Microsoft Teams
CATEGORIES:Data,Microsoft 365 Training
ATTACH;FMTTYPE=image/jpeg:https://blogs.qub.ac.uk/digitallearning/wp-content/uploads/sites/7/2022/10/Excel.jpg
END:VEVENT
END:VCALENDAR