In this Excel tutorial, we are going to learn How to Make a Dashboard in Excel Within 15 minutes just using two functions, the Sumif Function and Text Function in Excel.

The Dashboard that we are going to make in this free Excel tutorial is a beautiful and modern dashboard in an Excel spreadsheet. We are going to use several different designs and layouts to make our dashboard modern and futuristic.

You can use this Dashboard spreadsheet in our presentations, in our reports or even use this data analysis through the Dashboard in your professional spreadsheet.

The chart that we are going to use to make this excel dashboard is the column chart in Excel. But you can also use line chart, or area chart, or bar chart, etc.

The Dashboard in Excel is a visual panel where we can analyze important data for any operation of a company.

The Dashboard can be powered by several third-party sources. That is, we can integrate the Dashboard into the Excel spreadsheet with several other external sources.

Basically, the Excel Dashboard is a visual and control panel, where we have several graphs to visualize the main information and relevant data of our company or whatever it is that we are analyzing.

The SUMIF function in Excel is used to sum the values in a cell range that meet the criteria you specify.

We can, for example, use the Sum function, not to add up all the sales in a sales spreadsheet, but to add up only the sales for the month of January for the salesperson Ana.

The sum function differs from the sumif function, as the sum function will sum all the values in the selected range, whereas the previously mentioned functions add only the data that are within the specified criteria, as well as the example in the paragraph previous.

The text function will help us to extract from the date just the day or just the month or even just the year of the selected date.

#JopaExcel #Dashboard #Excel