MyExcelOnline

Download Workbooks

Power Query Cheat Sheet - Getting Started with Power Query

Power Query Cheat Sheet - M Functions

Introduction

Query Editor Overview

Installing Power Query in Excel 2010

Excel 2010 & 2013 Add-In Download Link

Installing Power Query in Excel 2013

Trim

Format Dates and Values

Parsing URLs (Split Columns by Delimiter)

Split Text Fields (Split Columns by Delimiter & Number of Characters)

Group By

Unpivot Columns

Pivot Columns

Split Columns into Other Columns with Delimiters

Filter Your Data & Add a "Year" Column

Sort Your Data

Transform v Add Column

Add Column From Examples

Group and Rank Items

Modulo

FROM FOLDER: Consolidate Workbooks - Part 1

FROM FOLDER: Consolidate Workbooks - Part 2

FROM FOLDER: Extract Data from Forms

FROM WORKBOOK: Extract & Consolidate Data Based on Multiple Criteria

FROM WORKBOOK: Extract & Consolidate Data from Multiple Worksheets

Append Worksheets to Consolidate Data

Merge - Joins Introduction

Merge - Full Outer Join (all rows from both)

Merge - Left Outer Join (all from first, matching from second)

Merge - Right Outer Join (all from second, matching from first)

Merge - Inner Join (only matching rows)

Merge - Left Anti Join (rows only in first)

Merge - Right Anti Join (rows only in second)

BONUS EXAMPLE: Merge - Left Outer

BONUS EXAMPLE: Merge - Full Outer Join

BONUS EXAMPLE: Merge - Right Anti Join