Logo - Skillwave Training

Master Your Data

Author: Ken Puls

This is the video portion of the “An End to Manual Effort: The Power Query Effect” seminar with Ken Puls. Power Query will change the way you “Get & Transform” data in Excel, allowing you to clean up, reshape, and combine your data with ease, no matter where it comes from.

Duration:
8 hours
Tools:
  • Excel
Skills:
  • 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
Course Icon - Master Your Data with Power Query

Master Your Data

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

Master Your Data

$250

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.

If you need to learn one skill in Excel today, how to work with Power Query is it.  Not only will it change the way you “Get & Transform” data in Excel, but it’s also the system used to collect data for Power BI, meaning these skills are transferable to other programs.

Who this course is for?

  • Anyone who needs to pull data into Excel, clean it up and/or consolidate it.
  • Experience working with Pivot Tables is an asset, but not required.

Course Formats

On-Demand
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.

FAQs

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.

  • Power BI
  • DAX Studio
  • Power Pivot for Excel
13h 30m
5 Modules
$350