Udemy Certificate 0

Advanced Excel Power Query-M language, troubleshoot, Pattern

Name: Advanced Excel Power Query-M language, troubleshoot, Pattern
Price: 199.99 USD
Availability: InStock

About this course

Hello and welcome to Excel Power Query Advanced course.At the outset I thank you for showing interest in this course. In this video I will provide overview of all the contents of this course and what are basic requirements before you enroll into this course. So let’s get started. There are four major areas I will be covering as part of this course. The first one is for troubleshooting the Power Query errors and workaround for limitation of Power Query. In real any software is not foolproof and has its own limitation. Also, if you don’t use the software as programmed you may encounter errors. And I hope you would agree that error codes or description in most of the software are not that user friendly or they do not provide appropriate solution to resolve the error. Hence in this first section I will show some of the common areas where you face Power Query limitation and erros. Some of them are as follows: Error encountered with adding / rename / deleting a particular column headings. Handling null values during arithmetic calculation. Identify error rows encountered while creating or on refresh of query. Multiplying effect when you JOIN queries Issues with filters and how to use advanced filters. Then the next area is for advanced case studies. Similar to my starter course of Excel Power Query where I have shown you more than 20+ real life case studies of applying power query, here also I have taken some real life case studies which require some more in depth knowledge of Power Query and workaround. This section will be updated new case studies as and when I see some interesting datasets. The current video are related to Applying local setting when converting the dates fields Leave dataset which needed leave details to be broken into separate rows from a single cell.

69/100

CourseAsk score

What the provider tells you: 45/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

troubleshoot Power Query errors
apply advanced filtering techniques
manage null values in calculations
analyze case studies to implement Power Query solutions

Course objectives

to provide learners with advanced troubleshooting skills in Power Query
to enhance practical data handling capability through real-life case studies

Data Analysis #excel #data manipulation #data analysis #power query #troubleshooting #error handling #analytics #case studies #advanced filtering #null values

$199.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.