Dashboards

Hi Juliana,

Thank you for the forum question.

You have a lot of tools in Excel to create dashboards. One of them is the pivot table tool. You can use the form tools in combination with a number of Excel functions such as Vlookup, Hlookup, Index, Match, Choose and many more.

How you should create your dashboards is a question about how you have your source data, how you want to present them and your Excel knowledge.

I have attached some examples from Best STL's dashboard course. I will suggest that you have a look at the examples.

I can recommend that you have our Excel Dashboard course.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector