Please ensure Javascript is enabled for purposes of website accessibility
Microsoft Excel: Excel Power Query And Get And Transform Data
0( 0 REVIEWS )
46 STUDENTS
2h 34m

This course is designed for those interested to learn the basics of Microsoft Excel Power Query, the various data analytical tools to easily find and clean your data, and techniques within Power Query and Get and Transform to shape your data and consolidate reports without the need to use Formulas or Macros.

Read more.
Course Skill Level
Beginner
Time Estimate
2h 34m

Instructor

I'm a book author of the 101 Excel Series paperback books. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, and much more


Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

Last time, you opened a Power Query file and were overwhelmed by the number of things to do. You didn’t know how to make the best use of your time. But it doesn’t have to be this way with this course.

By the end of this course, you will walk away with:

  • More time
  • The ability to create your own Power Query data transformation from scratch in just 120 minutes.
  • Understanding of the essence of the Power Query cleanups, and see them in action.
  • Knowing how Power Query is used with real examples.

After this class, you will be able to:

  • Actually smile when you open the Power Query Editor
  • Brag to your friends about how you can use Power Query confidently

If you’re like me, you use Microsoft Power Query on a daily basis for important tasks, text processing, or reports. Whether it’s for business or personal related projects, everyone wants to be able to use Power Query freely and easily. We take it up a notch to clean your dirty data and showcase the things you can do in Excel Power Query.

Requirements

  • Compatible with Microsoft Excel 2010, 2013, 2016, 2019 and Office 365
  • No prior Power Query knowledge is required

This course is for:

  • People who are in: Accounting, Finance, Management, Auditing, Admin and Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus more
  • People who want to change career and apply for a new job
  • People who want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress and get a promotion or pay-rise

Our Promise to You

By the end of this course, you will have learned how to use Microsoft Excel Power Query.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Microsoft Excel Power Query.

Course Curriculum

Section 1 - Introduction
Introduction To Power Query 00:00:00
Power Query And Query Editor Ribbon 00:00:00
Section 2 - Transform Data
Trim 00:00:00
Format Dates And Values 00:00:00
Parsing URLs 00:00:00
Split Text Fields 00:00:00
Group By 00:00:00
Unpivoting Columns 00:00:00
Pivoting Columns 00:00:00
Split Columns Into Other Columns 00:00:00
Filtering Rows And Adding A Year Column 00:00:00
Sorting Column 00:00:00
Transform And Add Columns 00:00:00
Section 3 - From Folder
Import From Folder 00:00:00
Doing Auto Cleanup 00:00:00
Extract Data From Forms 00:00:00
Section 4 - From Workbook
Extract Multiple Criteria 00:00:00
Extract Multiple Worksheets 00:00:00
Section 5 - M Coding In Power Query
M Overview 00:00:00
Enabling M 00:00:00
Finding The List Of M Functions 00:00:00
Simple M Expressions 00:00:00
Simple M Expressions – Nested Expressions 00:00:00
M Variables 00:00:00
M Functions 00:00:00
M Functions – Reusable Functions 00:00:00
M Functions – Invoking 00:00:00
Passing M Functions 00:00:00
Passing M Functions – Using The Each Keyword 00:00:00
Using M Functions 00:00:00
Power Query – Resources 00:00:00
You see three titles on your podcast app, which one would you likely listen to based on the title alone: