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 […]

Virtual Course offered via MS Teams This course (offered over two separate sessions - Part I (1 hour) and Part II (1 hour)) is aimed at staff who wish to become more familiar with M365 suite and how some of its cloud apps available can be used to enhance the delivery and communication of a […]

This course will focus on the Site contents functionality available under Site settings icon. The site contents page provides site owners with a list of all pages, libraries, lists, and other apps on their sites. This session will demonstrate how you can access the familiar view and interaction capabilities of all of the content on […]

In this short, introductory session, QUB staff will be introduced to the University's video content management system, Panopto. Panopto is a best-in-class video platform that complements the University's approach to lecture capture and video recordings. It integrates seamlessly with Canvas and can be used to capture recording from your personal laptop/desktop in your office (campus […]

“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP How 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 […]

This course concentrates on useful features of Word 2007 such as creating master and subdocuments, tracking changes and use of form fields. Auto Text and Quick Parts will also be covered, along with an overview of macros, which can be used to automate repetitive tasks. Participants will learn how to increase their efficiency when word […]