Free Practice Workbook
Table of Contents
Video #2:
Coming Soon
[/one_half]
Video #3:
Coming Soon
VIDEO #1:
Different Ways to Format Data Using Power Query
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
Bonus Video:
Install Power Query Using Excel 2010 & 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)
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.
