Our Microsoft Excel Power Query course teaches you how to import, tidy up, transform data and output a workable clean dataset for analysing.
You’ll learn what Power Query is, identify where in the data analysis process Power Query sits, import data from various sources, restructure and transform data ready for output, load data to a Table Query, create a Connection only and add to the Data Model.
To attend you should be proficient in writing formulae and Excel functions.
We currently deliver all training online to comply with the Government's guidelines.
Online training works well for businesses whose staff are mainly working from home.
It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.
Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.
When permitted we also offer face to face training at your offices.
All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.