Download the Excel FilesComplete the form below to instantly access the Excel files.

Water Sports Rentals Sales Dashboard – BEGIN.xlsxDownloadWater Sports Rentals Sales Dashboard – FINAL.xlsxDownload Video TutorialWatch on YouTube & Subscribe to our Channel

In this tutorial, we take the dashboard design we created with AI tools in the previous video and build it out completely in Excel, step by step.

We start with the raw data and walk through creating every Pivot Table that powers the dashboard, from the KPI cards to the charts. From there, we build out each chart, including a top 5 items chart, a sales-over-time chart with a week/month toggle, and a customer mix chart. We also connect a slicer so one click filters everything on the dashboard at once.

The best part is that none of this requires complex formulas or VBA. Every piece of the dashboard is powered by Pivot Tables, so it stays fully dynamic and updates with the click of a button as new data comes in.

If you haven't seen the first video where we designed this dashboard with AI, check that out after watching this one, to see how the look and layout came together.

Link to post: How to Build an Interactive Excel Dashboard with Pivot Tables