Course: Design and Create Custom Dashboards in Excel

In the completed workbook you will find a copy of the Introduction sheet shown in this video. Hopefully from the article earlier, you are also familiar with the ability to …

In this article, we are going to quickly revise some of the Excel functions we have used and will use to create interactive and dynamic charts. Charting in Excel is …

Finish setting up the charts as demonstrated in this video. First, change the settings so you can keep the formatting. Then set up the data validation as shown in this …

Named ranges in Excel are labels that you can assign to individual cells or cell ranges. This allows you to use range names anywhere you would use a cell or …

Using the chart you prepared in the previous step, take some time now to add the dynamic formatting and the data validation. Make sure you can carry out the steps …

Using the formatted chart from the previous step, now take some time to create and format the overlay chart as shown in this video. Comment below: What are your main …

Before you move on to the next video, make sure you are able to create a waterfall chart like me in this video. You can choose alternative formatting options if …

It is good practice to keep inputs, or original data on one sheet, with calculations and helper columns on different sheets. It would be common to see calculation sheets for …

It is important that you are able to recreate this custom visual. Using the calculations you prepared in the previous step, take some time now to recreate this custom visual. …