Add manual information into a query | Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
https://exceloffthegrid.com/add-manua...

★ About this video ★
There are many scenarios where raw data itself isn't enough to complete a task efficiently. For example, we may need to add manual information, such as categorization, commentary, or reference numbers.

In this video, we look at this process and understand how to add manual information into a query.

0:00 Introduction
0:36 Example and process
1:31 Step 1: Get data & unique reference
4:43 Step 2: Add manual information
5:24 Step 3: Merge manual info with the original query
7:26 Step 4: Refreshing the data and testing
8:56 Important information
9:27 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel