PowerQuery Course

Free Preview

PowerQuery is a new tool within Excel and part of the PowerBI tools. It is the best way to get and cleanup any data in Excel and has the benefit of ‘recording’ your steps and allowing you to replay them as often as you like.

PowerQuery Course Details

  • 44 lessons
  • 92 video clips
  • 21 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
  • Aimed at Intermediate and above Excel users, based on our free Excel skills assessments
  • Equivalent of attending a 1 day live course
  • Lifetime access
  • Start/ stop as required and repeat when necessary

Examples of what you will be able to do

After the lessons and exercises you will be able to:


Easily delete unwanted rows


Fill in Gaps (easily)


Make a report into a database
Perform more complex data normalisations


Convert numbers that Excel does not recognise
Fix ‘numbers’ that Excel seems to not see


Keep/ put back leading zeros


Remove parts of cells


Keep leading zeros especially when importing data


Fix messy system dates
Sort out problemsome Excel dates


Split columns based on constant size


Put imported data into its own Excel columns


Split columns using formula
Split text into columns based on a delimitor


Identify duplicates
Identify duplicates for deletion or further analysis


Neaten up your spreadsheets


and much, much more!

For the full list of contents go back to the Data Cleanup in Excel Course contents main page.

Buy the course now to get immediate access!

Back to: Online MS Excel Super Bundle