FREE DASHBOARD TO DOWNLOAD: https://jopaexcel.com/dashboardexcelfdekdxdt70y/

In this Excel video tutorial, we will learn how to make a Sales Dashboard in Excel from scratch and step by step. We will also learn how to make a table in Excel, how to make a pivot table in Excel and how to make a pivot chart in Excel. You can download this Excel sales sheet for free to follow this lesson along with me.

The Dashboard is also known as the control panel. It is a visual management tool that presents, in a clear and objective way, everything you need to monitor the evolution of your business results and ensure the achievement of your goals. With the Dashboard you can analyze the results in a simple and interactive way, in addition to helping you make decisions on a daily basis and in the job market.

To make a Dashboard in Excel, we can follow the steps.

1 Have a Database.
2 Transform the Database into a Table with the format as Table tool.
3 Create PivotTable from Table.
4 Create Slicer.
5 Create the Dashboard Background Image with Objects or Shapes or Icons.
6 Create PivotCharts and Value Cards.

1 Having a database in Excel is the first step, as we need information so we can create graphs, tables, pivot tables and pivot charts, etc. A database is needed to create the Dashboard.

2 Creating a Table in Excel is using the Tool called format as table. So, let's take our database and transform it into a table with a very important Excel functionality.

3 Creating a PivotTable in Excel can help us a lot in creating the Dashboard, because with the pivot table we can make dynamic charts, that is, whenever we make any filters or data segmentation, the information in the charts will update automatically. Pivot table is also known as pivot table and pivot chart is known as pivot chart.

4 Data segmentation, or also known as options box, list of options, filter button, selection buttons, dynamic filter, etc., will be very important to make our spreadsheet interactive in Excel.
Every time some information is selected from the slicer box, all values in the worksheet, all values in the Dashboard will be updated automatically. This way, we were able to make our Excel spreadsheet interactive and dynamic. Just with clicks we can filter the information we need to view.

5 Creating the Dashboard background is very important because we can make the dashboard modern and beautiful just with the image we choose for the Excel spreadsheet screen background.
We can use figures and objects such as rectangles, squares, circles, rectangles with rounded corners, etc. In addition to being able to use icons or images from our computer.

6 Dynamic charts, or pivot charts, will make our dashboard more beautiful and interactive in Excel. Every time any value is filtered and information is segmented, the graphs update automatically, showing only the selected information.

00:00 - Subscribe to the channel!
00:30 - Leave a LIKE on the video!
02:09 - Adjusting the Database
06:32 - Format as Table
07:45 - Pivot Table
23:08 - Dashboard

#JopaExcel #Dashboard #Excel