Tutorials

Sometimes Excel finds a problem if you are working with a large a complex spreadsheet, and – upon saving, modifying, or opening – you receive the following error message: Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other … Read more

An absolute reference in Excel keeps your formula fixed. So, if you copy the formula to another position, nothing will change. Unlike a relative reference, it is pointing to an actual fixed location on a worksheet. How to use absolute reference The key is the dollar sign: $. For example, insert a dollar sign before … Read more

Using a Panel chart (small multiples) is a great decision if you want to compare products or sales and show the data on the same scale. If you create dashboards in Excel, it is important to use space-saving methods and focus on the data. Our step-by-step tutorial shows you how to create a panel chart … Read more

The scroll bar in Excel is one of the most useful tools in Form Controls. If you are using it, you will save time and get more space. The biggest advantage comes when you work with a large data set. Using scroll bars, you can manage any size list in a small space. Sounds good! … Read more

If you are working on an excel dashboard, you need to create great-looking navigation. Everyone loves great UX! I will show you how to build an interactive settings menu for your spreadsheet in today’s guide. Take a close look at the picture below! Take a close look at the picture below! This simple menu enables … Read more

Use a heat map in Excel to create quick data visualizations! Today’s guide will be about how to build maps using conditional formatting. What is a heat map? Heat Map is the perfect solution for you if to want to highlight the crucial data points in a table or a range. Let us see a … Read more

Bullet Graph is a great data visualization in Excel if you want to show key performance indicators using a quality scale. We will show you how to build a bullet graph in Excel using a few steps. If you need to build a dynamic dashboard in Excel, this chart is yours! How to build a … Read more

How to use external data connections in Excel? Today’s tutorial is all about data import (SQL, CSV, and XML) and the managing of data sources. Stay with us! It is not surprising that we almost never store databases and a large amount of raw data in Excel worksheets. The main reason for this is that … Read more

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 in … Read more

Learn how to build a forecast chart in Excel! It is a custom combination chart that uses one column and two line charts. In this article, I’m going to show you how to create a simple forecast chart using conditionally formatted colors. What is a forecast chart? Let us see the main task: we want … Read more

Learn how to change shape color based on cell value in Excel using a few steps. In this tutorial, we will explain how to create interactive charts using conditional formatting. Believe it or not, it’s possible to change shape color on chart objects using some VBA tricks! You will learn how to extend the formatting … Read more

The popularity of the gauge chart is indisputable. It’s a combination chart: a doughnut that displays the zones, and a pie chart indicates the actual value. Not only is it used by Excel PowerBI but leading BI providers too. When you take a look at the above visualizations, it is clear why it is so … Read more

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

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

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!