Pinterest Pixel

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

John Michaloudis

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

Coming Soon

Data Cleansing Training - Consolidate Multiple Excel Workbooks & Worksheets Using Power Query

[/one_half]

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
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  LAMBDA Function in Excel - Create Custom Functions in Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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