This category shows all powerful features in Excel to analyze data using various ways.
Learn how to make a rule dependent on the content of another cell using conditional formatting in Excel! So far, we have processed only and exclusively situations where the color of the given cell was specifically determined by the relationship of the values in a given range. What will happen if we would like to … 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 You can use a few easy steps to find and highlight duplicate values in Excel. First, let us see how it works. 1. Select data, in this case, C2:E12 2. Click … 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
