From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)
Join today to access over 24,400 courses taught by industry experts.
Top three sales managers and numbers: Sort data in PivotTable
From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)
Top three sales managers and numbers: Sort data in PivotTable
- [Instructor] Okay. So we already created the first part of our dashboard, before we move on, let's make some minor cosmetic adjustments to this. I'm just going to change the header to bold. Let's also remove the grid lines, and also group these shapes together because every time I want to move this shape, I don't want to have to worry about selecting the other shapes as well and moving them together. So let's select all these shapes by holding down the Ctrl key and clicking on the text boxes and the pictures, and then we can right mouse click, select group from here and group again. Now we can just move this object in one go without having to worry about selecting all the objects together. Let's do the same for March as well. So click, click, and click. Now, you can also group by going to the menu here, so from shape format, under group options select group, okay. So far so good. As a next step, we want to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
(Locked)
Link Excel shapes to the data and linked picture trick9m 26s
-
(Locked)
Top three sales managers and numbers: Sort data in PivotTable5m 8s
-
(Locked)
Linked table for sales by product category8m 23s
-
(Locked)
Excel PivotChart for monthly sales6m 5s
-
(Locked)
Pivot Slicer connected to multiple PivotTables12m 15s
-
(Locked)
-