In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards.

With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about.

All you need is Microsoft Excel -- there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume.

If your Excel dataset has a lot of columns, it becomes quite difficult to find data from one end to another end of a row.

But if you generate a system in which whenever you select a cell in your dataset,  the whole row will be highlighted, then you can easily find data from that row.

Provides a simple way of creating a contents menu for easy navigation of a workbook.