Get & Transform - Introduction Video

%3CLINGO-SUB%20id%3D%22lingo-sub-38635%22%20slang%3D%22en-US%22%3EGet%20%26amp%3B%20Transform%20-%20Introduction%20Video%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-38635%22%20slang%3D%22en-US%22%3E%3CP%3EGet%20%26amp%3B%20Transform%20(Power%20Query)%20is%20amazing%20at%20connecting%20to%20and%20transforming%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20just%20build%20the%20connections%2C%20do%20the%20transformations%20once%2C%20and%20then%20simply%20refresh%20anytime%20you%20want%20to%20update%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Query%20is%20built%20into%20Excel%202016%20and%20is%20a%20free%20download%20for%20Excel%202010%20and%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CA%20href%3D%22http%3A%2F%2Fyoutu.be%2Fn0-XKgZwDgk%3Futm_source%3DThe%2BBarrow%26amp%3Butm_campaign%3Df1eeba27ee-Power%2BQuery%2Bis%2BAwesome%26amp%3Butm_medium%3Demail%26amp%3Butm_term%3D0_5ebc0c9764-f1eeba27ee-%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECheck%20out%20this%204-minute%20video%3C%2FA%3E%3C%2FU%3E%3CSPAN%3E%3CU%3E%26nbsp%3B%3C%2FU%3Ewhich%20steps%20through%20the%20process%20of%20combining%20the%20data%20from%20every%20CSV%20file%20in%20a%20folder%20into%20one%20table%2C%20then%20impress%20your%20colleagues%20as%20you%20replicate%20this%20demo%20for%20them!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252Fn0-XKgZwDgk%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253Dn0-XKgZwDgk%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252Fn0-XKgZwDgk%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22400%22%20height%3D%22225%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-38635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-39388%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20-%20Introduction%20Video%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-39388%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Sergei%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-39330%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20-%20Introduction%20Video%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-39330%22%20slang%3D%22en-US%22%3E%3CP%3EWyn%2C%20good%20job!%3C%2FP%3E%3C%2FLINGO-BODY%3E
MVP

Get & Transform (Power Query) is amazing at connecting to and transforming data.

 

You just build the connections, do the transformations once, and then simply refresh anytime you want to update the data.

 

Power Query is built into Excel 2016 and is a free download for Excel 2010 and 2013

 

Check out this 4-minute video which steps through the process of combining the data from every CSV file in a folder into one table, then impress your colleagues as you replicate this demo for them!

 

2 Replies

Wyn, good job!

Thanks Sergei