We also have an interactive Excel workbook that you can download and follow these steps on your own.ĭownload the Excel Dashboard tutorial workbook. Once your dashboard is created, we’ll show you how to share it with people by creating a Microsoft Group.

This makes it very handy because you only need to create the dashboard report once.įor this example, we're going to create four PivotTables and charts from a single data source. In addition, you can quickly refresh your dashboard when you add or update data. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In this topic, we’ll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic dashboard. In the past, Excel reporting often required you to generate multiple reports for different people or departments depending on their needs. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just what’s important to them. A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place.

Dashboard widgets mac mojave