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

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!

Introduction

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

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

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

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

$1 Trial for 30 days!

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

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

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

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

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

$1 Trial for 30 days!

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

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

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

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

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

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

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

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

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

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

$1 Trial for 30 days!

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

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

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

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

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

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

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

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

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

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

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

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-forms.svg" alt="Forms" width="48" height="48" /> 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!

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

Word

PowerPoint

Outlook

OneNote

Teams

Access

SharePoint

Project

Visio

Power Automate

Power Apps

Forms

Steps To Follow