From the course: Excel: Power Query for Beginners

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Next steps

Next steps - Microsoft Excel Tutorial

From the course: Excel: Power Query for Beginners

Start my 1-month free trial Buy for my team

Next steps

“

- So let's review what we did in this course, and I also want to show you some fun tips for taking advantage of all the data cleaning we did. Furthermore, I want to give you some additional topics to learn about, because believe it or not, we really just scratched the surface of what you can do with Power Query. Okay, here's what we did. We started with our original data and it had all sorts of problems. Then we cleaned it up on this sheet with Power Query. Now what do we do? Well, most likely you want to chart this data, or you want to make a PivotTable to get more insights. There's a lot to teach when it comes to those two things, but here are some quick tips to get going. First, I'll select just the Sales amount column, and then I'll hold down the Ctrl key and select the Day Name column as well. Then I'll head on over to the Insert tab and click Recommended Charts. Right off the bat, this chart looks great. I'm going to go ahead and click OK. Another way to get quick insights is to…

Contents