Power query

Welcome to our Course page showing our current courses and those that we are currently updating. All of our courses are written specifically for the training of Finance Teams. This means that all courses are taught using scenarios that Finance Teams would be likely to see on a daily basis from collating purchase order reports to reconciling payroll, creating budgets to analysing results, reviewing sales to posting journals. Have a look around for a course that will help you become more efficient and more accurate at your job today!

Free

Protected: A Finance Team’s Guide to Pivot tables

Pivot tables are the single most powerful tool in Excel for a Finance Team. Simply, they take any size dataset and summarise it dynamically by any piece of information in the underlying dataset. They are quick to create, easy to amend, and simple to add to or refresh. Whatever job you perform in a Finance Team, pivot tables will save you time.

Free

Getting Started with PowerQuery for Finance Teams

This free course explains how PowerQuery can cheaply and quickly make a Finance Team much more efficient by automating dataset transformations using Microsoft Excel. As well as explaining what PowerQuery is, it also gets the course user started with some basic transformations.