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:20251008T100000
DTEND;TZID=Europe/London:20251008T110000
DTSTAMP:20260415T152345
CREATED:20240917T092035Z
LAST-MODIFIED:20250923T142813Z
UID:31566-1759917600-1759921200@blogs.qub.ac.uk
SUMMARY:Excel 2: Managing Data
DESCRIPTION:Continuing from Excel 1: Essentials\, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a series of practical exercises\, participants will learn about a variety of techniques which can be employed to make spreadsheets more comprehensible\, such as sorting\, basic and advanced filtering\, conditional formatting and custom number and date formats. Excel Tables and the new data bars\, colour scales and icon sets\, which can be used for conditional formatting\, are among the features that will be explored in this course. \nAimed at: Staff who wish to learn how to use MS Excel to store and display data and those hoping to take the ICDL Advanced module in Spreadsheets. \nPrerequisites: Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel. \n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/excel-2-managing-data/
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
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251021T093000
DTEND;TZID=Europe/London:20251021T103000
DTSTAMP:20260415T152345
CREATED:20240917T093153Z
LAST-MODIFIED:20250923T142933Z
UID:31573-1761039000-1761042600@blogs.qub.ac.uk
SUMMARY:Excel: Creating Charts
DESCRIPTION:This specialised course looks at the improved charting feature in Excel 2007 and discusses some of the different types of charts that can be created\, in particular\, line\, scatter\, pie\, bar and column charts. It also covers how to edit scientific or statistical charts to include features such as secondary axes and error bars and how to format charts\, both manually and by using the new chart styles available in Excel 2010. Participants will be able to practise creating and formatting different types of charts by completing a series of exercises and will also learn how to set the default chart type and how to create a chart template. \nAimed at: Staff who wish to learn more about displaying data graphically and those interested in taking the ECDL Advanced module in Spreadsheets. \nPrerequisites: Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel 2010. \n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/excel-creating-charts/
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
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251030T093000
DTEND;TZID=Europe/London:20251030T103000
DTSTAMP:20260415T152345
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