#Can i do web queries in excel 2016 upgrade#
If you do not have this then you will need to upgrade to Office 365 using this link: So goodbye VBA coding 🙂 🙂 🙂 So how do I get your hands on this super awesome add-in…I hear you say?įirst, you need to have Microsoft Office 2010 Professional Plus with Software Assurance. You can use Power Query to perform transformations that would be very complex in VBA or SQL. You have all that functionality in Power Query at the press of a menu command! Now your life has just become a lot…well, a hell of a lot easier 🙂Īpart from cleaning data, Power Query can append or merge two separate tables together (bye bye VLOOKUP!) as well as create extra columns in your data that can display your custom calculations! So no more formulas, text to columns, trim spaces, vlookup, find & replace, etc. The best thing is that the next time you receive the same ugly file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way! Well Power Query accesses, cleans, and transforms all that messy data and displays it in a way that Excel loves and can work with. Well you know when you get data from a file, a data dump/import, or an external data source and it comes into Excel in an ugly, unworkable format? I can hear you say YEEEES!
0 kommentar(er)
