To start, save that workbook to your hard drive. Quarters are going across instead of down the page. To give you an example of some of the awesomeness of Power Query, say that you get the file shown below every day.
Your Power Query commands will appear on a dedicated Power Query tab in the Ribbon. It is in the Get & Transform group on the Data tab.īut if you are in Excel 2010 or Excel 2013, go to the Internet and search for Download Power Query. But Power Query kept getting better, and every person using Excel should be taking the time to learn Power Query. I tell a story in my live seminars about how Power Query was invented as a crutch for SQL Server Analysis Services customers who were forced to use Excel in order to access Power Pivot. I say this about a lot of new Excel features, but this really is the best feature to hit Excel in 20 years. This means you can clean data on Day 1 in 80% of the normal time, and you can clean data on Days 2 through 400 by simply clicking Refresh. The best part: Power Query remembers your steps and will play them back when you want to refresh the data. The tool is designed to extract, transform, and load data into Excel from a variety of sources. Power Query is built in to Windows versions of Office 365, Excel 2016, Excel 2019 and is available as a free download in Windows versions of Excel 2010 and Excel 2013.
