Skip to Content

Course Details

Excel Get & Transform

Event 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

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 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.

Covid-19 restrictions

Due to Covid-19 restrictions face-to-face training will not be offered at this time.  This course will take the following format:

  • A demo of the Get and Transform features will be held on 14 October, 9.30 - 10.30.  Book via iTrent
  • Course participants access a workbook and associated files here. 
  • Additional topic specific resources (see link below) can be accessed as required
  • An online clinic to address any queries/problems will be running on 22 October, 9.30 - 10.30.  If you wish to attend this clinic please email s.mcmorrow@qub.ac.uk

Additional Resources

This collection of resources can be accessed via LinkedIn Learning, an online learning resource for staff.  New users will need to complete the LinkedIn Learning sign up here.

Excel Get and Transform


Pre-requisites

As this is an advanced course previous attendance at Introduction to PivotTables or a working knowledge of creating pivot tables is recommended.


Booking Information

Book via iTrent


Booking URL:

http://www.qub.ac.uk/qol

Course Contact Details

Name: IT Training and Assessment Unit
Telephone: 6189
Email: itcourses@qub.ac.uk
New Course: No
Course Type(s): Spreadsheets - Continuing Professional Development
Staff Categories: All Staff
Keywords: Power Query Power Pivot Get and Transform Excel