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:
[ Ссылка ]
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
Watch the rest of the training videos here:
VIDEO 2: Format & extract data using Excel Formulas & Excel's Data Tools
[ Ссылка ]
VIDEO 3: Consolidate Workbooks & Worksheets using Power Query
[ Ссылка ]
WATCH OUR FREE WEBINAR ON POWER QUERY (GET & TRANSFORM) & DATA CLEANSING NOW: [ Ссылка ]
Please share, like & leave your comments below.
My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]
My blog: [ Ссылка ]
![](https://i.ytimg.com/vi/WDzTRDkZHPk/maxresdefault.jpg)