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

Sparklines in Excel

excel sparklines

How to insert sparklines in Excel? In this article, you will learn all about sparklines. Get some useful examples! Now I’ve created this post to be a follow-along lesson. You can download the Excel file that I use during the article. Sparklines are in-cell Excel charts, and we are using these graphs to show variance … 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!