Dashboard Using EXCEL Developer - ID Card Make

Dashboard Using EXCEL Developer - ID Card Make welcome to other levels in today's video you will learn how you can create a dynamic sales growth and net profit margin dashboard in Excel without using.

Dashboard Using EXCEL Developer

Pivot tables and slicers only by using the Excel spinner and options buttons as you can see the dashboard can be filtered by year it can also be filtered according to three different types of.

Data as this is by final profits or according to total sales and according to purchases we can also move to the spreadsheet and make changes and updates easily.

visit our online store other Dash levels.com to get our templates or the data set .

Let's start this is the data set and we will start enhancing the look and feel we need only the header and total row we don't want the formula bar and grid lines.

Select all cells and change the font type to helvetica make font size 12. for the table headers will be in bright blue.

make it bold change the total row color to turquoise next insert 12 rows in above.

And one row left of the table adjust the column's width here we will make the header more higher Now set the cells as a background .

Foreign foreign next we'll add the second table and.

Place it on top no need to show the year set font size to 9 and bold then set the font color and number format.

then add a separator between each part looks great let's add the main title using a text box set the font size 24..

And make it white next insert a square to in turquoise color and place your company logo on it thank you.

    - ID Card Make

    We would rather not show the cell selection border to appear on a one cell cover a one cell with a rectangle with the same background color.

    Finally insert menu icon to navigate between the dashboard and the data sets now let's add abstract dots use the white color and the transparency 83 percent.

    Ctrl D to duplicate the circle distribute them vertically then align to Center .

    Foreign now we need to add another abstract triangle shape .

    Use a white gradient color foreign that's all for today's video hope you.

    Learned something useful for you on the other hand you have an easy way to directly purchase this template from our website other Dash levels.com thank you and see you in next video.

    DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continuetomake videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=k0ZeDSYVQ5Q
Previous Post Next Post