Home » Software Training » Excel Power Query » Extract Multiple Worksheets

Start learning today, and be successful in your academic & professional career. Start Today!

Connecting...

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
Bookmark & Share Embed

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.)
  ×
  • - Allow users to view the embedded video in full-size.
Since this lesson is not free, only the preview will appear on your website.

  • Discussion

  • Table of Contents

Please login to ask a question and view discussion.

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

  • Unlimited access to our entire library of courses.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lesson files for programming and software training practice.
  • Track your course viewing progress.
  • Download lecture slides for taking notes.
  • Learn at your own pace... anytime, anywhere!

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

Educator®

Please sign in to participate in this lecture discussion.

Resetting Your Password?
or
Still having trouble? Contact us
OR

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
 Get immediate access to our entire library.

Membership Overview

  • Available 24/7. Unlimited Access to Our Entire Library.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lecture slides for taking notes.
  • Track your course viewing progress.
  • Accessible anytime, anywhere with our Android and iOS apps.