Logo - Skillwave Training

An End to Manual Effort

Author: Ken Puls

This is the video portion of the “An End to Manual Effort: The Power Query Effect” seminar with Ken Puls. In this course, you’ll learn how Power Query can clean up, reshape and combine your data with ease.

8 hours
  • Excel
  • Data Preparation

What you'll learn?

  • Importing data from text files and web pages
  • Appending data from one table to another
  • Merging two data sets together
  • Importing all files in a folder in one shot
  • Unpivoting tables with ease
  • Creating dashboards from email in minutes
Course Icon - An End to Manual Effort

An End to Manual Effort

$249Renews at $29 per year
(All prices in USD)
  • 8 hours of training content
  • 13 modules
  • Downloadable files and Handouts
  • Certificate of Completion

An End to Manual Effort


Course Description

The sad reality is that not all data is stored in nicely curated databases and often – even when it is – the data analyst doesn’t have access. Instead we have to piece together data provided in text files, Excel files, web pages and even the body of emails to build the business intelligence solutions we need. Until now this has been a painful process with a great deal of cut and paste effort, and updates have been tedious and error prone. That stops today.

In this course, you’ll learn how Power Query can clean up, reshape and combine your data with ease. Converting ASCII files into tables, combining multiple text files in one shot and even un-pivoting data is not only simple, but an investment in the future, refreshable with a single click when next needed.

Who this course is for?

  • Anyone who needs to pull data into Excel, clean it up and/or consolidate it.
  • Registrants should already have a strong working knowledge of Excel’s basic functions as well as working knowledge of PivotTables. 

Course Formats

This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files and practice sets.

Course Content

Expand All

About the author

Ken Puls

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.


How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

  • Excel
  • Power BI
2h 30m
4 Modules
  • Excel
  • Power BI
27h 15m
24 Modules