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

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
 

See also  Create To Do List in Excel 3 Examples

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

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!