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

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

John Michaloudis

Table of Contents

Video #2:

Coming Soon

Video #3:

Coming Soon

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 Soleil12: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

X Facebook LinkedIn Copy Email Print Reddit

John Michaloudis

Founder & Chief Inspirational Officer

at

MyExcelOnline.com

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.

$1 Trial for 30 days!

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-introduction.svg" alt="Introduction" class="" width="48" height="48" /> Introduction

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" class="" width="48" height="48" /> Formulas

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formatting.svg" alt="Formatting" class="" width="48" height="48" /> Formatting

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" class="" width="48" height="48" /> Charts

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-printing.svg" alt="Printing" class="" width="48" height="48" /> Printing

$1 Trial for 30 days!

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" class="" width="48" height="48" /> Formulas

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" class="" width="48" height="48" /> Pivot Tables

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" class="" width="48" height="48" /> Macros & VBA

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" class="" width="48" height="48" /> Data & Analysis

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" class="" width="48" height="48" /> Charts

$1 Trial for 30 days!

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" class="" width="48" height="48" /> Formulas

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" class="" width="48" height="48" /> Pivot Tables

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" class="" width="48" height="48" /> Macros & VBA

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-query.svg" alt="Power Query" class="" width="48" height="48" /> Power Query

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-pivot.svg" alt="Power Pivot" class="" width="48" height="48" /> Power Pivot

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" class="" width="48" height="48" /> Data & Analysis

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" class="" width="48" height="48" /> Charts

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-bi.svg" alt="Power BI" class="" width="48" height="48" /> Power BI

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-dashboards.svg" alt="Excel Dashboards" class="" width="48" height="48" /> Excel Dashboards

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-financial-modeling.svg" alt="Financial Modeling" class="" width="48" height="48" /> Financial Modeling

$1 Trial for 30 days!

Word

PowerPoint

Outlook

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-onenote.svg" alt="OneNote" class="" width="48" height="48" /> OneNote

Teams

Access

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-sharepoint.svg" alt="SharePoint" class="" width="48" height="48" /> SharePoint

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-project.svg" alt="Project" class="" width="48" height="48" /> Project

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-visio.svg" alt="Visio" class="" width="48" height="48" /> Visio

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-automated.svg" alt="Power Automate" class="" width="48" height="48" /> Power Automate

<img src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-powerapps.svg" alt="Power Apps" class="" width="48" height="48" /> Power Apps

Forms

$1 Trial for 30 days!

101 Most Popular Excel Formulas

101 Most Popular Excel Formulas

101 Ways to Master Excel Pivot Tables

101 Ways to Master Excel Pivot Tables

101 Ready To Use Excel Macros

101 Ready To Use Excel Macros

Ultimate Debt Repayment Tracker

Ultimate personal finance tracker

Ultimate small Business Bookkeeping tracker

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

Video #2:

Coming Soon

Video #3:

Coming Soon

VIDEO #1:

Different Ways to Format Data Using Power Query

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

#ez_toc_widget_sticky--1 .ez-toc-widget-sticky-container ul.ez-toc-widget-sticky-list li.active{ background-color: #ededed; } Steps To Follow

30+ Excel & Office Courses

$1 Trial for 30 days

Related Articles

$1 Trial for 30 days!

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Introduction

Formulas

Formatting

Charts

Printing

Formulas

Pivot Tables

Macros & VBA

Data & Analysis

Charts

Formulas

Pivot Tables

Macros & VBA

Power Query

Power Pivot

Data & Analysis

Charts

Power BI

Excel Dashboards

Financial Modeling

OneNote

SharePoint

Project

Visio

Power Automate

Power Apps

Steps To Follow