Named Range

named range in excel - tutorial

Assign a descriptive name to a range of cells using a named range in Excel. Use it to create easy-to-understand formulas. What is a named range? Named range enables you to add an easily memorable name to a cell or range of cells. From now, you can write much better formulas, and it is easy … Read more

Name Box

name box in excel

The Name Box in Excel has placed on the left side of the formula bar. Learn how to use names in your Workbook! What is a Name Box in Excel? The functions of the Name Box: Show the selected cell on the active Worksheet Display the name of the cell, range, or other objects (text … Read more

Formula Bar

formula bar in Excel

Learn all about the Excel Formula Bar. Discover how to use, expand, show, and hide quickly through examples. What is the Formula Bar in Excel? The Formula Bar is the place where you can edit data or formulas in the selected cell. For example, if you want to check the formula in the active cell, … Read more

Quick Access Toolbar

the excel quick access toolbar - customization and guide

The Excel Quick Access Toolbar is ideal for adding your favorite commands or storing macros because it is always visible. Table of contents What is the Quick Access Toolbar? Customizing the Quick Access Toolbar Quick Access Toolbar shortcuts Moving the QAT Add macro to the Quick Access Toolbar What is the Quick Access Toolbar? In … Read more

Wrap Text in Excel

wrap text in Excel - the ultimate guide

Learn how to wrap text in Excel to fit the long content inside the cell and adjust it to show on multiple lines within the cell. Table of contents: What is Text wrap in Excel? Wrap text using Ribbon commands How to use the Excel wrap text shortcut Format cell dialog box Convert large in-cell … Read more

How to select multiple cells in Excel

how to select multiple cells in Excel - Quick Guide

Today’s guide will be about how to select multiple cells in Excel (adjacent or non-adjacent) using the mouse click, Shift, and Control key. Check our easy-to-understand examples! Selecting single or multiple cells is an essential skill in Excel because it stores the values, formulas, or conditional formatting rules in a cell or a range. However, … Read more

Fix Excel found a problem with formula references in this Worksheet

fix Excel Found A Problem With Formula References In This Worksheet

It can happen that Excel found a problem with one or more formula references in this worksheet upon saving, modifying, or opening. Fix it! Sometimes you are working with a large a complex spreadsheet, and you receive the following error message: “Excel found a problem with one or more formula references in this worksheet. Check … Read more

Absolute Reference

excel absolute reference guide

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

Panel Chart Template

final panel chart template

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

Create a Scroll Bar in Excel

how to create a scroll bar in Excel

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 most significant advantage comes when you work with a large data set. Using scroll bars, you can manage any size list in a small area. Sounds … Read more

Interactive Settings Menu for Dashboards

Interactive Settings Menu

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

How to Create a Heat Map in Excel

heat map excel

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

bullet graph excel

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

Data connections

excel data sources

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

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

Forecast Chart

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