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:20240331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20241027T010000
END:STANDARD
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251030T093000
DTEND;TZID=Europe/London:20251030T103000
DTSTAMP:20260408T185459
CREATED:20240501T105728Z
LAST-MODIFIED:20250923T143053Z
UID:27748-1761816600-1761820200@blogs.qub.ac.uk
SUMMARY:Excel: Get and Transform
DESCRIPTION:“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen\, Excel MVP \nHow long would it take you to combine data from 15 workbooks into a single data set? A few minutes\, an hour? If you’re using Get & Transform (previously known as Power Query)\, you could combine the data from all the workbooks in a few clicks. With Get & Transform\, you can add data from almost any source e.g. files\, folders\, databases\, web pages\, organise and transform it and incorporate it in your reports. \nAimed at: As this is an advanced course previous attendance at Introduction to PivotTables or a working knowledge of creating pivot tables is recommended. \n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/excel-get-and-transform/
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