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. Course objectives: What is Power BI? Power BI Desktop Power BI service Importing Files Creating interactive visualisations Reports and Dashboards Row-Level Security Sharing reports and […]
Power Automate is a service that helps you build workflows that automate time-consuming business tasks across applications and services. Power Automate can be used to synchronize files, get notifications, collect data, and more. Power Automate is one of the Microsoft 365 suite of apps. Course objectives: Understand what Power Automates is and how it works […]
Panopto is fully integrated with Canvas VLE. This training session will show you how to use Panopto from within Canvas. Topics covered include: Accessing Panopto A tour of the Panopto folder Creating and uploading videos Managing your videos Embedding videos in Canvas pages Adding quiz questions into Panopto videos General tips and advice Note that […]
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. Access on iTrent
This practical course is the essential starting point for anyone interested in learning how to produce spreadsheets using Microsoft Office Excel and forms an ideal basis for further courses in Excel. This course is also suitable for those needing to update their skills so that they can make efficient use of the latest version of […]
The aim of the is session is to introduce you to the key features and functionality of OneDrive to help optimise your use of the app in day-to-day work processes. The session will focus on navigating around the OneDrive landing page (My files, Shared areas etc) and how to easily access folders/files in a SharePoint […]
Microsoft Bookings is an Office 365 scheduling app that lets you configure an online booking calendar that integrates with Outlook. Use it to create a booking form that allows QUB students and staff (and external contacts), to book a service or resource. It also integrates with MS Teams, so appointments can be set up as […]
Designed for: Staff interested in using Computer Assisted Assessment (CAA) or doing survey work During this practical session, participants will have the opportunity to create a range of question types, add them to an assessment and schedule the assessment for themselves. Scheduling for a group of students will also be covered. Questions will be provided, […]
This practical course is designed to assist those who want to learn about Word’s mail merge feature in order to efficiently create, save and print personalised letters, envelopes and labels. The course will be useful to those wishing to build on their existing knowledge of Word 2010 and who want to improve office efficiencies and […]
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 […]
“People expect the world to be so much more visual than it’s ever been before.” David Marcus, Facebook’s Head of Messenger In this workshop we will practice using Piktochart, Canva and Sway, free tools which allow us to create professional, visually appealing social media posts, infographics, newsletters and more. Access on iTrent
Power Automate is a service that helps you build workflows that automate time-consuming business tasks across applications and services. Power Automate can be used to synchronise files, get notifications, collect data, and more. Power Automate is one of the Microsoft 365 suite of apps. Course objectives: Understand what Power Automates is and how it works […]
Microsoft Lists is a productivity app included with Microsoft 365 that allows you to organize your thoughts, create lists with your teammates, and share lists throughout the organization. In this course you will be shown how to create a list from scratch or from a template and adjust lists using a wide variety of built-in […]
A SharePoint business/communication site allows you to share news, reports, status, and other information in a visually compelling format. When you add a modern page to a site, you add and customize web parts. This course will provide some working examples of Share Point Online Communication sites and how you can build your site by […]
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 […]
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, […]
