Applications of VLOOKUP + MATCH and named ranges.

Using shapes for a prettier excel dashboard.Custom number formats and conditional formatting.Adding interaction to dashboards with slicers.In this article, we will focus on the following key concepts. With Excel 2013 and prior versions, however, creating a waterfall chart for instance, would require some tweaking, but yes, it is achievable ( follow the link to learn the 4 steps). The good news is that Microsoft Excel has continued to make improvements that allow the process and available visualizations (charts) easy to generate.įor instance, with Excel 2016, you have a Waterfall chartas a standard chart. In my career as an Excel specialist and trainer, I’ve noted tremendous time savings on those students who have gone through our Excel dashboards course. Surprisingly, using shapes for stylish Excel dashboards is one of the little known concepts. One of the key skills that will set you apart as an analyst is the ability to provide management with a distilled view of the key company numbers, with the ability to have multiple views in interactive Excel Dashboards.

How to use slicers in excel 2007