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.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
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who 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
What you’ll learn:
- Create your own Power Query data transformation from scratch in just 120 minutes.
- Understand the essence of the Power Query cleanups, and see them in action.
- Know how Power Query is used with real examples.
Requirements:
- Compatible with Microsoft Excel 2010, 2013, 2016, 2019 and Office 365
- No prior Power Query knowledge is required
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.
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.
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 | ||
Related Courses
Are you interested in higher education?