Power Query
Power Query Trick For Combining Files Without Renaming Table
Combining Files with Inconsistent Headers- No Mapping Table We have multiple files in a folder. Each file corresponds to a continent. There is a single sheet in each file having a list of countries in...
Three Methods To Translate Text or Functions in Excel
If you ever wondered how to translate excel spreadsheets into another language. This blog will give you a clear guidance on how to do exactly that. Translation is more than just changing words from ...
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...
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...
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....
- 1
- 2
Write NOTES Inside a Function in Excel – Simple steps
One of the most common questions in my youtube channel is “How to Write NOTES inside a Function in Excel” Sometimes I build complex functions with multiple levels of nesting. To make it ea...