Learn Excel - Power Query - Podcast 1956

  • Loading...
  • Published on:  Wednesday, September 30, 2015
  • This video, for Excel's 30th anniversary walks through what a game-changer Power Query is for Excel. You start with a folder full of horribly-formatted CSV files. Using the Query Editor, you load all of those files, clean the data, unpivot the data. Tomorrow, when more files are in the CSV folder, a simple Refresh will load and clean all of the data again. Power Query is built in to Excel 2016 under Data, Get & Transform or a free add-in for Excel 2010 and Excel 2013. Download from http://www.microsoft.com/en-us/download/details.aspx?id=39379
    To try it out yourself with my files, download them from http://www.mrexcel.com/podcast1956.zip
  • Source: https://youtu.be/vZSOpmg4ehw