Power Query

power query

4 Easy Ways to Combine Files with Power Query

With the help of Power Query, you can work with multiple files and sheets and be able to combine the data efficiently. When working in Excel, you might be organizing your data in different files, and ...

Quality Analysis Report in Power BI

In this tutorial we are going to create a dynamic dashboard that analyses a production business where we have our data scattered in multiple files. With many products, employees and locations, the aud...

Dynamic Report With Power Query and VLOOKUP – Approximate Match

When you want to create a dynamic report from multiple sources and you need an approximate match, If the VLOOKUP Cannot get the job done, Then Power Query will come for rescue. In this tutorial I crea...

Transform data using Power query

From Data To Analysis with Power Query and CUBEVALUE Function

In this project: We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the...

Power query and Data validation

2 Effective Tools Power Query and Data Validation are Much Stronger Together

  In this tutorial  I am bringing multiple files from a Folder, I combine the Files together, clean and transform the data and create calculations in Power Query to return a nice report to Excel....

split text in excel

Simple way to split text in excel (Timesaver)

Split text in excel with this simple excel formula. If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for t...

Retirement planning in Excel

Retirement Planning in Excel (Easy and Effective method)

Retirement Planning in Excel using Functions, Dynamic Arrays, and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this p...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.