From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

What you need to know before starting

From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Start my 1-month free trial Buy for my team

What you need to know before starting

“

- [Narrator] Before we get started, let's quickly cover what you need and also what you need to know before starting. One assumption is you already use Excel and that you have Excel for Microsoft 365. This course was created with Excel for Microsoft 365 in 2020. Another assumption is that you are familiar with basic formulas and functions like IF, SOME and COUNT that you can create basic charts and also create a basic Pivot Table. They would also help if you're familiar with the Power Query interface, but it's not necessary to know Power Query well. So even if you're not that familiar with Power Query, you can still follow along with me and create this dashboard because I take you through all the steps you need to do to get there. I'll just make it easier for you if you've used or you've seen Power Query before. Now, in case you haven't and you decide that Power Query is something that you're interested in that you could actually use at work, make sure you check out the other courses that are available in the library. Next, let me quickly introduce you to the exercise files and how you can follow along with me.

Contents