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
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:20251007T093000
DTEND;TZID=Europe/London:20251007T103000
DTSTAMP:20260426T053944
CREATED:20240917T073520Z
LAST-MODIFIED:20250924T072039Z
UID:10000886-1759829400-1759833000@blogs.qub.ac.uk
SUMMARY:Introduction to Power BI
DESCRIPTION:Power BI is Microsoft’s business intelligence (BI) solution for visualising and sharing data. Power BI enables you to quickly develop interactive reports and dashboards and share impactful visualisations with others. \nCourse objectives: \n\nWhat is Power BI?\nPower BI Desktop\nPower BI service\nImporting Files\nCreating interactive visualisations\nReports and Dashboards\nRow-Level Security\nSharing reports and dashboards\n\n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/introduction-to-power-bi/
LOCATION:Microsoft Teams
CATEGORIES:Data,Microsoft 365 Training
ATTACH;FMTTYPE=image/jpeg:https://blogs.qub.ac.uk/digitallearning/wp-content/uploads/sites/7/2022/12/Power-BI.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251021T093000
DTEND;TZID=Europe/London:20251021T103000
DTSTAMP:20260426T053944
CREATED:20240917T093153Z
LAST-MODIFIED:20250923T142933Z
UID:10000898-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:20260426T053944
CREATED:20240501T105728Z
LAST-MODIFIED:20250923T143053Z
UID:10000857-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
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251205T093000
DTEND;TZID=Europe/London:20251205T103000
DTSTAMP:20260426T053944
CREATED:20250924T072101Z
LAST-MODIFIED:20250924T072101Z
UID:10000942-1764927000-1764930600@blogs.qub.ac.uk
SUMMARY:Introduction to Power BI
DESCRIPTION:Power BI is Microsoft’s business intelligence (BI) solution for visualising and sharing data. Power BI enables you to quickly develop interactive reports and dashboards and share impactful visualisations with others. \nCourse objectives: \n\nWhat is Power BI?\nPower BI Desktop\nPower BI service\nImporting Files\nCreating interactive visualisations\nReports and Dashboards\nRow-Level Security\nSharing reports and dashboards\n\n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/introduction-to-power-bi-2/
LOCATION:Microsoft Teams
CATEGORIES:Data,Microsoft 365 Training
ATTACH;FMTTYPE=image/jpeg:https://blogs.qub.ac.uk/digitallearning/wp-content/uploads/sites/7/2022/12/Power-BI.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260210T093000
DTEND;TZID=Europe/London:20260210T103000
DTSTAMP:20260426T053944
CREATED:20240920T084832Z
LAST-MODIFIED:20260205T141702Z
UID:10000902-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
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260217T093000
DTEND;TZID=Europe/London:20260217T103000
DTSTAMP:20260426T053944
CREATED:20240920T090238Z
LAST-MODIFIED:20260205T141740Z
UID:10000905-1771320600-1771324200@blogs.qub.ac.uk
SUMMARY:Excel 3: Data Analysis
DESCRIPTION:This advanced course looks at some of the data analysis tools and functions available in Excel 2010 and involves a range of practical exercises using different types of data. Participants will learn how to use a variety of what-if analysis tools that can be employed in data analysis and decision making\, such as Data Tables\, Scenarios\, Goal Seek and Solver. In addition\, the course will cover a wide range of useful functions\, including text\, logical\, financial\, lookup and date and time functions\, which can be used to manipulate spreadsheet data. An introduction to the interface for creating PivotTable and PivotChart reports in Excel 2010 is also included. \nAimed at: Staff who wish to advance their knowledge of Excel or who are hoping to take the ECDL Advanced module in Spreadsheets. \nPrerequisites: As this is an advanced course\, previous attendance at Excel 1 and 2 or significant experience of creating spreadsheets using Excel 2007 or 2010 is recommended. \n  \nAccess on iTrent
URL:https://blogs.qub.ac.uk/digitallearning/event/excel-3-data-analysis/
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:20260506T103000
DTEND;TZID=Europe/London:20260506T113000
DTSTAMP:20260426T053944
CREATED:20240917T092035Z
LAST-MODIFIED:20260416T095828Z
UID:10000895-1778063400-1778067000@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
END:VCALENDAR