Microsoft Excel Get and Transform Introduction

For more Excel features and tips visit the OfficeNewb blog:

Also, download the file used in the video to practice Excel's Get and Transform feature:

[tipoo]

I have spent weeks on researching how to merge these two workbooks and get them to pull the data that I need. Thank you for this video! Everyone kept suggesting VLOOKUP which would work but it was doing all the steps I needed. You made it easy for me to understand!

[BoardgameBaker]

Most videos on this subject start from a way too advanced level. This was a proper introduction which gave me a solid platform to stand on while exploring the Get & Transform function. Great job!

[stella]

This video is so underrated. Maybe the title should be change, because this is the one that i need, but i missed the 'getdata' in my search, until i saw someone use it and search the keyword.

[sandeepkothari]

A powerful presentation on Power Query! I like your look, bearded & capped!

[fluffyhoneytina]

i tried to use get and transform and when I go to get from file, I can't find nor see my files....I can't even get started.

[DanielLamarche]

Good old Northwind database. Still useful! Thanks for video.

[proberts]

Solid introduction to Get & Transform. Thanks for the video. If you have a similar video for Excel 365, please provide the link in the Description. It's Data > Get & Transform ribbon buttons are somewhat different. And yes, I'll go look for myself. ;)

[kenkannon]

I am learning more on this topic by trying to make some sense of the diverse data on the Cornavirus -- I cannot find one Official source for what I want to see
If successful, I hope to learn how to update with updated data as things change

[KingKing-cpmn]

Hello, I have a problem I'm hoping you could help me with. When I get my data from web. It comes back with a column that say list. I believe it's because the column has 3 values in the one column. How to I get the value I need to come instead of it just saying list? I would greatly appreciate your help if you can. Thanks

[pinaki]

Can you please add a link to download the practice file

[PatrickFuller]

Whoops! No download link in the description!