To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

Your homepage worksheet should be similar to a homepage on a website—it should be welcoming, and viewers should be able to instantly see what's going on. That's why the first two elements you need to ...