Advance Excel (Dashboard)

EXCEL DASHBOARD TUTORIAL

A dashboard is a visual form of selected data and it develops by Excel’s graphical tools like Pivot table and chart.

HOW TO CREATE A DASHBOARD IN EXCEL

Different types of data can be represented by Excel dashboard. So let’s create the following dashboard in Microsoft Excel.

STEPS TO CREATE DASHBOARD

Step 1: Open the Microsoft Excel.

Step 2: Insert the following data.

Step 3: Select the data.

Step 4: Click on “Insert” menu.

Step 5: Click on “Pivot table” tool.

Step 6: Click on “Pivot chart”

Step 7: Insert Year in “Axis Fields“ and “Salesman A to E” in Values.

Step 8: Now click on “Slicer” tool from the Insert menu.

Step 9: Select the Year from “Insert Slicers” window.

Note: Slicers are used to filter selected pivot table data, for example, we want to see only “Year- 2005” data, so just simply double click on 2005 in Year filter (Slicer’s filter) window.

HOME