In this article, I will teach you how to create beautiful interactive sales dashboards in Excel, using Pivot tables and Power Query.
The guide is intended for people already familiar with basic concepts related to using Pivot tables and to some extend Power Query.
However, you do not need to be an expert to follow the instructions and create a stunning interactive dashboard.
You can use the sample data provided here, or you can use your own dataset.