What is Power Query in Excel?

- [Dave] Often you're given some data, but quite frankly, it's not always in great shape. For example, in this data, we've got a couple of problems, but one being that there are a bunch of blank rows. So what is Power Query and how can it help? Power Query is a data connection technology that lets you import and clean data. In other words, it can take data like this and clean it up like this. When your data's clean, you can more easily create formulas, create pivot tables, and even charts. And furthermore, you can refresh this data in case it changes in the future. So let's show you how to do all of this. Let's get started with Power Query in Excel.