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 Excel 2013 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! Read the tutorial on how to install Power Query in Excel 2010 here So what is Power Query? Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010.
0 kommentar(er)
