This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.

Right-click on it and select Report Connections. Select PivotTables from the following menu. Click Ok. Here, you are connecting the slicer to the pivot tables on the dashboard.