Excel File to Download: https://docs.google.com/spreadsheets/d/10Sx5Fomu0WP8uV2ZR85UQGkcN0yJuEjk

In this Excel video tutorial, we're going to learn how to make a Dashboard in Excel using only the Sumifs function and the text function. Text Formula and the Sum Ifs formula 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 many different designs and layouts to make our dashboard modern and futuristic.

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

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 an especific salesperson.

The sumifs function or sumif function differs from the sum function, as the sum function will sum all the values in the selected range, while 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