Today, September 30, 2015 is the 30th anniversary of Microsoft Excel. Version 1.0 debuted for the Mac on September 30, 1985. Excel, of course, was not the first spreadsheet program. It was not even the first spreadsheet program from Microsoft, who had released Multiplan a few years earlier. Eventually, though, Excel went on to become the spreadsheet program that is in use on 750 million desktops.
Over the last several months, I’ve been updating my books for Excel 2016. One of the best features, though is the feature formerly known as Power Query. This feature is so good, anyone with Excel 2010 or Excel 2013 can download Power Query for free.
I recently had a change to review an early draft of M is for Data Monkey by Ken Puls and Miguel Escobar. In an hour with the book, I learned many new Power Query tricks. So, today, for the return of the MrExcel Podcast, we take a look at how Power Query can be used to clean and load a whole folder of badly formed CSV files and then repeat the whole process tomorrow in a couple of clicks.