How to create a drop-down list in Excel

drop-down list in excel

Using the drop-down list, we can choose elements from a predefined list. It is beneficial when, for example, we would like to show the efficiency of different departments within one company. Moreover, it is worth using because when choosing its elements, the dashboard automatically refreshes and likewise the connecting charts. Forget all user-generated errors! Drop-down … Read more

Key Performance Indicators

key performance indicators

In this article, you will learn about key performance indicators. Is it easy to create a kpi? From the technological view, yes. Before we dive deep, just a few words about creating a useful KPI. Prepare these four metrics below: KPIs are essential when you build dashboards in Excel. We have to give these values … Read more

How to install an Excel Add-in

how to install an excel add-in properly

Learn how to install an Excel add-in and how to fix the disappearing add-in ribbon using a few simple steps. Don’t forget to enable the Developer tab!