Excel Power Query Tutorial - Merging Tables (VLOOKUP Alternative)
Рет қаралды 7,628
2 жыл бұрынMerging tables of data with Excel Power Query is the focus of Part 7 of my Power Query tutorial series. In this video I demonstrate how to use the Power Query alternative to the VLOOKUP function to add group characteristics for more powerful analyses
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
Get the Excel workbook used in this video:
💻 github.com/DaveOnData/ExcelPo...
-----------------------------------------------------------------------------------------------------------------------
Additional Power Query Tutorial Videos
-----------------------------------------------------------------------------------------------------------------------
What is Excel Power Query AND Why it Matters to You! (Part 1):
📺 • What is Excel Power Qu...
Excel Power Query - Add Column From Examples (Part 2):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Custom Column 1 (Part 3):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Conditional Column (Part 4):
📺 • Excel Power Query Tuto...
Excel Power Query - Grouping Tables of Data (Part 5):
📺 • Excel Power Query Tuto...
Excel Power Query - Transforming Nested Tables (Part 6):
📺 • Excel Power Query Tuto...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video: • Learning R Programming...
Stay healthy and happy data sleuthing!
#ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryMergingTables
@joeltochukwu4199 2 жыл бұрын
Thank you. When are we expecting the next video?
@sathyesh-si5vy 2 жыл бұрын
Waiting for next video 🤗... Really appreciate
@eunicen4250 29 күн бұрын
Awesome stuff. very insightful. very clear step by step tutorial. thankyou so much David
@DaveOnData 24 күн бұрын
My pleasure!
@aytacavcilar1330 2 жыл бұрын
Super simple, clean and quick tutorial on KZfaq. 👍
@DaveOnData 2 жыл бұрын
Thank you for the feedback, glad you liked the video!
@laxmanrao4554 Жыл бұрын
The best part about yout videos (that I feel) is the design thinking process, to build hypothesis and then what we want to see followed by what we need to reach there and finally reaching there . Thank you 💗
@KP-ky1sn 2 жыл бұрын
Very much appreciated and nice and easy to follow. The join function was well explained. I've had some trouble wrapping my head around left, right, inner outer joins for a while now and figured the only way i will truly understand them is to see them all in action by running some demo files. For me it's easier to understand when i see the application and the outcome. Big thanks again.
@Data_Mom 2 жыл бұрын
Simple and quick video, enjoyed watching.
@DaveOnData 2 жыл бұрын
As always, appreciate the feedback and glad you enjoyed the video!
@AOPsimi 2 жыл бұрын
Hi David, I just subscribed to your channel and I’m super excited!
@DaveOnData 2 жыл бұрын
Awesome! I hope you find the content useful.
@Sandy-qt5su 2 жыл бұрын
super helpful, waiting for the next one Dave ;)
@DaveOnData 2 жыл бұрын
Excellent! Glad you found the content.
@flaviobertasi2728 2 жыл бұрын
Great job! Thank you so much for your super useful vids..
@DaveOnData 2 жыл бұрын
Thank you for the feedback, much appreciated! So glad you are finding my content useful.
@mog1888 2 жыл бұрын
Great videos David...would you be able to show how to store weekly comments when the file changes with new orders
@shhruti6775 Жыл бұрын
You are awesome
@VaibhavRungta 3 ай бұрын
Hello @david langer, these are incredibly helpful videos :-) I am working with a larger data set and after getting the power query table (green one) I am trying to apply some formulas on it. Most of the formulas are either breaking or not allowing me to exclude headers from selections (eg: UNIQUE and FILTER). Is this common? I am not using pivot because the breaks I am trying to see (often on 2 axis) are easier to create using formulas than pivots and size of the sheet becomes too large with more pivot tables. Any suggestions? Thanks
@DaveOnData 3 ай бұрын
If I understand your situation correctly, I think Power Query might be useful here. Power Query can create pivots (i.e., grouping tables). This video might be helpful: kzfaq.info/get/bejne/mKmKdMl-p5m3nI0.html
@davidably Жыл бұрын
👍
@statistikochspss-hjalpen8335 Жыл бұрын
It's was a bit too complex pivot table. It would've been good if you showed percentage instead of count.
@JaveGeddes 2 жыл бұрын
Your voice goes from normal to a whisper..
@piotrr597 Жыл бұрын
Channel dead? :( soo sad
Excel Campus - Jon
Рет қаралды 217 М.
Efficiency 365 by Dr Nitin
Рет қаралды 2,5 М.
Tokparty
Рет қаралды 2,1 МЛН
Sameer Gaming
Рет қаралды 2,4 МЛН