What will I learn?

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.

Click on the topics below for more detail of what is covered.

What’s Included in Our Courses?

We pride ourselves on delivering first class training that meets your staff’s needs. Here’s what to expect:

  • Your own booking specialist to help you choose the best training for your needs.
  • A choice of online or face to face training, delivered by our friendly and highly experienced trainers.
  • Free pre-course IT skills assessments to help establish which level of training is required.
  • Lots of interaction and practical examples to keep everyone focused and to embed learning.
  • Post-training support from certificates, user guides, workbooks and a summary of the delegate feedback.

Why Choose To Learn With TrainingU?

We’ve helped hundreds of mid-level and blue chips train all their team members since 2006. Got questions? Speak to one of our team now on 0333 344 6630

Trusted Pair of Hands

Established over a decade ago, we are a team of knowledgable training and software rollout experts.

We Love What We Do

We are passionate about delivering excellent training and software rollout support that makes a real difference to you and your teams. We strive to exceed your expectations in all that we do.

Personal & Bespoke Service

We pride ourselves on listening and offering a personal and reliable service to each and every client that we work with. We seek to build a strong and lasting relationship and to become your go-to training partner.

Experts in our Field

Our trainers are experts in their subject matter, bring a wealth of experience and have a natural ability to make everyone feel comfortable and to bring out the best in learners.

If you’re looking to upskill your team
or want help rolling out new software

or call the TrainingU team on 0333 344 6630

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)