Copy – Paste?
How many times did you paste information from a website into an Excelsheet? It is a common scenario where people are surfing the web and want to keep the information they bump in to. A nice table presented by the website with all possible combinations, pricelists, adresses you name it. Well copy the table from the web and paste it into the Excelsheet right. But what if it is a very long table which exceeds the limits of your screen? Dragging your mouse very slowly and hoping that those annoying adds wont be in the selection as well. Enter PowerQuery!
|No more copy and pasting, no more annoying adds accidently being selected as well.
PowerQuery is an add in for Excel and you can download it here . When installed you will see an additional tab in your Excelribbon. For this example i want to use the data presented on the microsoft learning site about MOS certifications. There are various tracks to choose from. I want to have all the data. So let’s see if we can grab the info for Office 2013, 2010 and 2007.
Next time we will grab a more complicate table and edit the data before entering it into our worksheet. Stay tuned!
Happy Querying 🙂