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 […]
This course provides participants with an opportunity to learn about more advanced features in PowerPoint 2010 in order to incorporate interactivity and multimedia in presentations. Intended for staff who are already familiar with the basic concepts of creating PowerPoint presentations, this practical course will enable users to create sophisticated presentations that make full use of […]
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 […]
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 […]
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 […]
Check back soon for more information. Access on iTrent
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 […]
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 […]
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 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 […]
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 […]
“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 […]
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 […]
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 […]
