Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jan 10, 2017
In this 1st of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to format your messy data using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-cont...
This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2010, 2013 & 2016 versions.
You will learn the following topics:
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