This category shows all powerful features in Excel to analyze data using various ways.
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
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
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
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
Learn how to combine the Excel RANK function to determine the sorting order using colors.
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
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 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 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 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
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
