Pinterest Pixel

Data Cleansing Training – Different Ways to Format Data Using Power Query

  VIDEO #1:  Different Ways to Format Data Using Power Query   In this training you are... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Data Cleansing Training - Different Ways to Format Data Using Power Query | MyExcelOnline Data Cleansing Training - Different Ways to Format Data Using Power Query | MyExcelOnline

Video #3:

Coming Soon

Data Cleansing Training - Different Ways to Format Data Using Power Query

 


VIDEO #1: 

Different Ways to Format Data Using Power Query

 

In this training you are going to learn the following:
Intro from John Michaloudis & Oz du Soleil
12:10 – Intro to Power Query (Get & Transform in Excel 2016)
16:30 – Trim leading & trailing spaces
20:30 – Format “text” Dates & Values using Excel v Power Query
24:15 – Parse URLs using Excel v Power Query
27:55 – Transform & automate reports from an ERP system (e.g. Oracle, SAP, QuickBooks) into a flat Excel file
 

download the excel workbooks used in this video Power-Query-Data-Cleansing-Excel-Workbooks.zip

 


Bonus Video:

Install Power Query Using Excel 2010 & Excel 2013

 

 

CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2010

CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2013

 


 

Please leave a comment below with your data cleansing issues

and we will reply back with a fix 🙂

 

(make sure to be specific and attach example workbooks if possible)

If you like this Excel tip, please share it
Data Cleansing Training - Different Ways to Format Data Using Power Query | MyExcelOnline Data Cleansing Training - Different Ways to Format Data Using Power Query | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  The Best Guide for BCC in Outlook Calendar Invites

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...