From spreadsheet to showpiece Building a robust dashboard in Excel doesn’t require rocket science. Following these simple steps above, you can transform any database into a powerful visual tool.

It’s a simple process to copy the objects to a blank sheet to create the dashboard. To do so, select a PivotTable and its Slicer by holding down Ctrl while clicking both.