Depending on the number of changes, this can be a lot of time! Power Query solves this problem. With Excel, you would have to open the workbook and make all those changes again just to get the same result. Simple, right? Then a month later, you are given a new report for the month of August. You open your table, make your changes, and save. If you regularly work with data, here are some great reasons to start using it.Ī common chore when working with Excel workbooks is having to make the same set of changes to different worksheets.įor example, let's say you are given a report that shows sales numbers for the month of July and you need to make changes. Think of it just like macros in VBA programming, if you're familiar.īecoming comfortable with Power Query can take your Excel skills to the next level. Power Query will save your changes as steps in a file known as a 'Query', which can be used any time. Using this connection, you can work with your data in the editor and make all your changes before you save to a workbook. When you import into Power Query it creates a connection to your data. If you're just starting out, it would be good to learn about the basics of Microsoft Excel. It allows you to import data from many different sources, make changes, and load the data right into your Excel workbooks. Power Query (known in Microsoft Excel 2016 as 'Get & Transform') is a data transformation tool built right into Microsoft Excel. If you're looking for a powerful new way to manage data, Microsoft Excel for Windows now has powerful software built in to help: Microsoft Power Query is a new tool that gives you more control over your spreadsheets than ever before. Over time, Microsoft has developed some pretty innovative ways to work with your data. Microsoft Excel is powerful and popular spreadsheet software that makes working with data simple.

Ms power query for excel