One of things I like to do when I build dashboards in Excel is to create dynamic titles. By this, I mean I link the title to a cell and when the cell contents change, the title changes too.

I also like to make my dashboards and reports more interesting by including shapes and icons, which can also be connected to cell values.

In this video I’ll show you some example of how to make your visuals more appealing using Dynamic Titles and Linked Shapes