fbpx

Excel On Steroids: Power Query Course

Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest. 

  • Video Lessons = 74+ (6 Hrs)
  • Lifetime Access
  • Lifetime Support

What is Excel on Steroids: Power Query Combo

Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest.
→  Excel on Steroids: Power Query Combo is a Combination of Power Query and Power Query M Language. It will help you optimize and build highly flexible data mashup queries also the Course will let you work with the Power Query M language to import and transform data. Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest.

, Excel Steroids on Power Query Combo

What Power Query can do?

Automatically clean your Data with Power Query

Before Power Query

How to sort data in Excel

Data Cleaning Arrow

After Power Query

Sorted Data

Become Smarter, Quicker & Faster

Life Of Regular Excel User

data science

Life After Excel On Steroid

data science

Reasons why you should choose Excel on Steroids: Power Query Combo

Situation: The Organizations these days have an island of Data to deal with. Agree? Or not?

Why employees are Frustrated:

  • The Undeniable fact is, ‘Most of the Managers lack the Technical Skills required for Data Problem Solving’
  • The amount of Manual Labor involved in pulling out a Report together

What’s the Way out: Power Query M-Language, comes with potential solutions to solve your organization’s data problems and in pulling out your Data Together

Bonus: Your Reports are now error free and you can save yourself some great amount of time. This lets you analyze the Report rather than compiling it.

 

What you’ll learn from this ‘Excel on Steroids:
Power Query Combo’ Course

Do you know what is ultra-cool about Power Query? Once you have performed the steps. These steps are repeatable the next time you want to perform the earlier exercise. Much identical to the idea of a Macro but easier to use. Still confused in enrolling the power query online course?

1Extensive Knowledge:

In this Power Query M Language Course, The Trainer provides an extensive knowledge on the fundamentals of the Power Query’s M programming language which is an add on to your Current skillset

2Working on Advanced Editor:

It gives a Powerful Base to work with the Advanced Editor while designing the queries in Power BI Desktop

3Deploying of Power Query Logic:

You’ll learn how your new-found M programming skills can be used to step up your Working Game. With M Language, you’ll be able to develop Custom data connectors. These are helpful for the Organizations in authoring the shared query logic. Multiple Power BI Desktop projects later help in deploying and reusing this Query logic

4Challenges of a functional language:

You’ll learn to tackle the challenges of a functional language as opposed to an imperative language (VBA, C#). Once you’ll learn the advancements of using M Programming Language, you’ll be forever ready to Learn M

5Power of M:

You will learn that M language behind the scene of Power Query, is more Powerful than the Power Query’s graphical interface

6Features of Power Query M:

You’ll learn about the functions, generators, parameters, generators and other interesting features of this tool

7‘M’ the Scripting Language:

You’ll learn about ‘M’ the Scripting Language. It is a Data Transformation engine of Power BI. If you wish to do data preparation and data transformation before loading the Data into your Model, M Language will always stand out

COURSE CURRICULUM

14 Module & Over 6 hours of video

Power Query – M Language

Direct Power Query Limitations- Error Handling

  • Errors handling- While you Modify a Table / Delete a Table / Rename a Table
  • Dynamically rename columns while avoid errors
  • Perform a Case sensitive Advanced Filter
  • Identify/Keep/Remove – Power Query error Rows in the Data Frames
  • Null Handling values during query Results (addition / Multiplication / Division)
  • Merge queries & case sensitive Duplicates – JOINS
  • Solutions- Different Unpivot issues

Power Query- Case Studies

  • Date and Time – Convert for different time zone
  • Understanding the Business Value of ‘Leave Data Part 1’
  • Understanding the Business Value of ‘Leave Data Part 2’
  • Stack the un-stack Data which is Uneven – Part 1
  • Stack the un-stack Data which is Uneven – Part 2
  • How to quickly combine multiple row data into single cell using this Reverse trick
  • Power Query Ranking- Excel Magic Trick
  • Date List – Allocating Fixed cost on monthly Basis
  • Recording Prepaid Expenses each month

Deep dive into Advanced Power query editor concepts and Power query- M Language

  • Concept explained: M Language and Advanced query editor
  • Power Query Parameters – Introduction
  • Create / edit / deleting Parameters Using PQ interface
  • Introduction – Microsoft Power Query Custom M Functions
  • Microsoft Power Query Parameters and Power Query Interface -Custom M Functions
  • Microsoft Power Query using advanced editor – Custom M function
  • Nested calculation in Power Query- Power Query Conditional RANKIF based on custom M function
  • Show Query Dependency and Grouped Queries

Custom M Functions – Dynamic (ready to use) Patterns

  • Introduction- Dynamic (ready to use) Custom M Function
  • Vendor Ageing analysis with Approximate Match in Power Query
  • Power Query Custom M- Code – Calculates working days between dates

+

Power Query (Basic To Advanced)

How to Consolidate and Append Data

  • How to Append Multiple Worksheets within the same Excel file
  • How to find the Relationship between Append, Duplicate/Replicate and Referencing of multiple Queries
  • Learn about Importing data from files in a folder
  • Learn about Importing data from multiple excel files in a folder
  • How to create Dynamic List of files stored in a folder
  • How to Change the file path for source data

The beauty of Power Query

  • Understanding What is Power Query. Why to learn Power Query and what is Covered in Power Query

How to Import Data from External Data Sources into Power Query

  • How to Import Data from Excel File
  • How to Import Data from another files and folders

Loading and Refreshing Data

  • How to load and Refresh a query as per Data Modeling

Define the multiple Transformation Steps

  • How to do Column Transformation in Power Query
  • How to do Row Transformation in Power Query

How to do in built transformation in Power Query

  • How to do Text Transformation
  • How to do Numbers transformation
  • How to do Date transformation
  • How to do Conditional Column transformation

How to use Merge feature to combine Multiple Joins in Power Query

  • What are the Multiple JOINS in power query
  • What are the Different Joins in Power Query
  • Learn how to create a Cross Joins and Cartesian Product Joins
    with Power Query

Fundamentals of M: The Formula Language for Power Query

  • Learn what are the roots of M, the Formula Language/ Power Query Formula Syntax
  • Learn about the Text functions in Power Query
  • Learn about the Date functions in Power Query
  • Learn about the Conditional Functions in Power Query

Case Studies

  • Using Power Query to Convert the Financial Statement Data into a Table
  • Converting the Payroll Data into a Tabular format with Power Query
  • How to pull Stacked Data from the Address Book to the Excel?
  • How to apply Multiple filters on single column using Merge Query Option
  • How to Convert a Row data set into a Tabular Format using Power Query?
  • How to get data from Multiple lookup Values using Power Query
  • Invoice/Order data Modeling (Converting Pivoted Data using Unpivot Function) with Power Query
  • Shape and Combine Data from Multiple Sources in Power Query. Here, Sales analysis using MaxIF, MinIF,

Power Query Objects

  • List all the object and functions in Power Query and how it can be used
  • How to Record as object and details about the Record functions in Power Query
  • Table & other objects and Table functions in Power Query
  • Quick Recap on What are the Power Query Objects

Advanced Case Studies

  • Learning to Extract only relevant data in Power Query
  • How to Create a dynamic Calendar table
  • Mode of Calculating and finding Individual sales to total sales percentage
  • How to apply Multiple filters on single column

Bonus

  • What are the Conditional Functions?
  • Using the Extract & Transform Column
No Frills

Lifetime Access

Advanced Excel Course
$79
  • 177+ Course Lessons
  • Downloadable Sample Files & Ebook
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • Lifetime Support
  • Lifetime Video
  • Lifetime Free Updates
Get Instant Access
Office Training Bundle Package

Annual Access

Advanced Excel Course
$99
  • 74+ Course Lessons
  • Downloadable Sample Files & Ebook
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • Lifetime Support
  • Lifetime Video
  • Lifetime Free Updates
Get Instant Access

What Student Say?

The Course instructors at Yoda Learning are at Par. My only Weakness till date was Excel which is long gone now. Not only I’ve learned about Excel but I can confidently do VBA Coding and automate my Regular Excel Tasks. A colleague of mine made me watch a Couple of your Videos where you have taught Excel Tricks. And since it had a Lifetime Support it really motivated me to take your Course. Thank you so much for delivering your Best knowledge.

Peter Thomas
Peter Thomas
Sr. Consultant

I have all the courses from Yoda Learning. I consider it as one of the best platforms in making Learning easier for its Learners. The Courses here are comprehensive and one of the easiest Courses on the Online Platform in recent times. Professionally explained. I love the takeaways from the Course. It’s amazing especially the Money back Guarantee which gives you the Confidence to take the course.

Barbara_Kern
Barbara Pern
Data Analysis
Office Training Bundle Package

Lifetime Access

Excel On Steroids: Power Query Combo
INR10,500
  • 74+ Course Lessons
  • Downloadable Sample Files & Ebook
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • Lifetime Support
  • Lifetime Video
  • Lifetime Free Updates
Get Instant Access

What Student Say?

The Course instructors at Yoda Learning are at Par. My only Weakness till date was Excel which is long gone now. Not only I’ve learned about Excel but I can confidently do VBA Coding and automate my Regular Excel Tasks. A colleague of mine made me watch a Couple of your Videos where you have taught Excel Tricks. And since it had a Lifetime Support it really motivated me to take your Course. Thank you so much for delivering your Best knowledge.

Peter Thomas
Peter Thomas
Sr. Consultant

I have all the courses from Yoda Learning. I consider it as one of the best platforms in making Learning easier for its Learners. The Courses here are comprehensive and one of the easiest Courses on the Online Platform in recent times. Professionally explained. I love the takeaways from the Course. It’s amazing especially the Money back Guarantee which gives you the Confidence to take the course.

Barbara_Kern
Barbara Pern
Data Analysis

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

30 days money back gauarantee

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

Feel free to call us for any query related to courses. Our support team will resolve your issue.

Contact Me

Still confused on which Course to take?

 Email [email protected]

 Call Now!+1-203-349-9909