From the course: Excel: Power Query for Beginners

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Next steps

Next steps

From the course: Excel: Power Query for Beginners

Start my 1-month free trial Buy for my team

Next steps

“

- [Dave] So let's review what we did in this course and talk about next steps to take. We started here with our original data which had all sorts of problems. We then used Power Query and cleaned up those problems. Now, what do we do? Well, mostly likely you want to chart this data or you want to make a pivot table to get more insights. There's a lot to teach when it comes to those two things, but here are some quick ways to get going. Let's select anywhere inside this dataset and go ahead and press Control + Q. That will bring up this quick analysis feature. I'm going to click Charts, and then I'm going to hover over these and get a preview of the chart that I'll get from this data once I click. And I like this one, it will show us the breakdown of the three product categories. So I'll click that one. And Excel will put this sheet in here called sheet one. I'll go ahead and I will resize this chart. I might even move this…

Contents