Basic Math 
Pre Algebra
Algebra I 
Algebra I
Algebra II 
Geometry 
Trigonometry 
Precalculus 
Math Analysis 
AP Calculus AB 
AP Calculus BC
AP Statistics
Gen. Statistics 
Gen. Statistics
Probability 
College Calculus: Level I
College Calculus: Level II 
Multivariable Calculus 
Linear Algebra 
Differential Equations 
General Chemistry 
Gen. Chemistry
AP Chemistry 
Biochemistry 
Organic Chemistry 
Organic Chemistry Lab 
Physical Chemistry 
Physics – High School (Theory & Application) 
AP Physics 1 & 2 
AP Physics C: Mechanics 
AP Physics C: Electricity & Magnetism 
AP Physics B
AP Physics C: Mechanics
AP Physics C: Electricity Magnetism
Life Science (Middle School)
Regular Biology
Anatomy & Physiology 
General Biology 
AP Biology 
AP Environmental Science
Microbiology
Molecular Biology 
Intro to Psychology
AP Psychology
AP US History
AP World History
HTML Training 
HTML 5
Intro to Ruby Programming 
Web Design & E-Commerce
Introduction to C++
Intermediate Level C++
CSS Intro
Java
AP CompSci: Intro to Java
JavaScript
Introduction to PHP 
Advanced PHP Training w/ mySQL 
C#
Visual Basic
XML Training
QuickBooks (How-To Guide) 
MATLAB
Excel Power Query
Adobe Dreamweaver CC
Adobe Dreamweaver CS6 
Adobe Photoshop CS6 
Photoshop Designs to Code
Edge Animate CC
jQuery Mobile
Adobe Illustrator CS6
Adobe Premiere Pro CS6
Adobe Premiere Elements 11
ColdFusion 9
ColdFusion 9: Application Framework
Fireworks CS6: Web Workflow
Adobe Photoshop Elements 11 
English Grammar
Advanced English Grammar
English Composition
Application Essays
AP English Language & Composition
AP English Literature & Composition
Shakespeare: Plays & Sonnets
Reading Comprehension
AP Spanish
AP Studio Art 2-D
Music Composition
Music Theory
Music History & Appreciation
Learn Piano for Beatmakers and Producers
Answer Engine
Table of Contents
Section 1: Excel Power Query
Power Query Intro and Excel version
3m 4s
Power Query and Query Editor Ribbon
8m 38s
Trim
5m 27s
Format Dates and Values
2m 15s
Parsing URLs
5m 26s
Split Text Fields
9m 34s
Group By
2m 57s
Import From Folder
6m 33s
Doing Auto Cleanup
6m 57s
Extract Data from Forms
13m 26s
Extract - Multiple Criteria
4m 39s
Extract Multiple Worksheets
4m 3s
Unpivoting Columns
5m 19s
Pivoting Columns
2m 18s
Split Columns into Other Columns
4m 4s
Filtering Rows
5m 3s
Sorting Columns
2m 20s
Transform and Add Columns
6m 41s
Intro to Joins
3m 31s
Merging
7m 43s
Full Outer Join
5m 43s
Right Anti Join
8m 50s
Convert Reports into Pivot Tables
5m 4s
Modulo
5m 45s
Section 2: M Language in Power Query
M Introduction
2m 42s
Enabling M in Power Query
2m 19s
Simple Expressions
7m 35s
Simple Expressions - Nested Expressions
2m 54s
Variables
8m
Functions
6m 6s
Functions - Reusable Functions
2m 13s
Functions - Invoking
35s
Passing Functions
8m 11s
Passing Functions - keyword each
2m 41s
Finding the list of M functions
2m 28s
Using M Functions
9m 59s
Loading...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of Excel Power Query
For more information, please see full course syllabus of Excel Power Query
Share this knowledge with your friends!
Copy & Paste this embed code into your website’s HTML
Please ensure that your website editor is in text mode when you paste the code.(In Wordpress, the mode button is on the top right corner.)
×
Since this lesson is not free, only the preview will appear on your website.
- - Allow users to view the embedded video in full-size.
Start Learning Now
Our free lessons will get you started (Adobe Flash® required).
Sign up for Educator.comGet immediate access to our entire library.
Membership Overview