Structured reference

structured-reference

Excel structured reference is a syntax that applies table names in easy-to-read formulas instead of regular cell references. Use this tutorial to discover the basics of Excel structured references. We will share the details if you are working with tables. Table of contents: What are structured references in Excel How to create an Excel structured … Read more

Excel Transpose Function

transpose excel main

The Excel TRANSPOSE function swaps a vertical range to a horizontal range and switches rows to columns but keeps the data structure. Table of contents: Convert rows to columns in Excel using Transpose Excel Transpose Shortcut How to use Excel Transpose Function Steps to convert rows to columns using Array Formula Transpose data in Excel … Read more

Conditional Formatting based on another cell

conditional formatting based on another cell

Learn how to use conditional formatting based on another cell and create a rule that depends on another cell value in Excel. Conditional formatting enables us to determine highlights based on the value of a referred cell. In the referred cell, we can modify the values arbitrarily. If the value changes, then the highlight of … Read more

Multiple Conditions (Conditional Formatting)

multiple conditions in excel conditional formatting

Learn how to use multiple conditions and formulas in conditional formatting to apply multiple criteria (AND, OR, LEFT, RIGHT) to a single cell or a range. Now let’s talk about the logical functions. In this section, we’ll show you how to create effective formulas to build a complex rule. First, we will create a new … Read more

Color ranking

color ranking in excel

Learn how to combine the Excel RANK function to determine the sorting order using colors.

Stop If True

how to manage multiple rules using stop if true

How to use the Stop If True rule in Excel to ignore the other rules?

Multiple Rules Hierarchy

Using multiple rules in Excel conditional formatting is not rocket science. Learn how the rules hierarchy and overlapping are works. If you are not familiar with the hierarchy and rules overlapping, this article is yours! What is this mean? The rules are subordinate to each other. Is more rule applying to one cell than Excel … Read more

Find Duplicates

how-to-find-duplicates-in-excel

Learn how to find duplicate values and how to highlight duplicate rows in Excel using conditional formatting through useful examples! How to find duplicates in Excel You can use a few easy steps to find and highlight duplicate values in Excel. But, first, let us see how it works. 1. Select data, in this case, … Read more

Color Scales

color scales in excel

Color scales in Excel are similar to Data Bars. Get a quick overview of your data! The shade of the color represents the value in the cell. Before you take a deep dive, you should know: What is the difference between color scales and data bars? Data bars representing the relationship between value and colors … Read more

Icon Sets

icon sets excel

Icon sets in Excel are effective tools for us to visualize values in a range of cells easily. Each icon represents a range of values. If you want to add an icon set, shape, or indicator, execute the following steps. Steps to add Icons sets We will use traffic light style shapes: green, yellow, and … Read more

Data Bars

data bars in Excel

Data bars in Excel make it easy to highlight values in a range of cells. A longer bar represents a higher value. A shorter in-cell bar chart represents a lower value. Get a quick overview of highs and lows! If you’re not using specific rules or conditions in your data range or cells, then data … Read more

Quick Analysis Tool

how to use quick analysis tool in Excel

Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines) In today’s lesson, we will explain how to use this feature in Excel. Table of contents: How to turn on the Quick Analysis feature Formatting Ranges using Quick Analysis Tool Inserting charts using … Read more