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

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Finalize the dashboard

Finalize the dashboard

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

Start my 1-month free trial

Finalize the dashboard

“

- [Instructor] Now we're ready to upload the latest data, which includes sales data from May. So let's go to our folder. I'm just going to drag and drop the new file with the same name. The only difference is that this file also includes May data. I'll just drop it into our folder, replace the file in the destination. Now, all I have to do is go back to the dashboard and refresh the report. So let's go to the data tab and select refresh all. What we should see here is May and April. We should get the new names for our top three sales managers in May, which we do, the table updates. The period line chart here updates as well. The moment we refresh, we get to see the latest information with a click of just one button. As a few final steps, what we can do, or what I prefer to do, is to hide any columns or rows that I don't need. Basically, I just want to restrict my dashboard to the used area. So I'm just going to…

Contents