How to Freeze Panes

how to freeze panes

In this tutorial, you will learn how to Freeze Panes to lock specific cells, rows, and columns in place. If you are working with large data tables, this function is yours! When your spreadsheets become beyond control, you should have to freeze the rows and columns. Table of Contents: Introducing the Freeze Panes feature First, … Read more

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 kpi excel contect

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. Remember that context is key if you work in analytics and your job involves KPI reporting or dashboard design. When … 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!