MyExcelOnline

Download Workbooks

Power Query Cheat Sheet - Getting Started with Power Query

Power Query Cheat Sheet - M Functions

Introduction

Query Editor Overview

Excel 2010 & 2013 Add-In Download Link

Installing Power Query in Excel 2013

Installing Power Query in Excel 2010

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