In this section, you’ll find useful resources and ready-to-use solutions. Enjoy our detailed, step-by-step training and download the training materials and examples.
Our definitive guide will show you 15 ways to clean data in Excel. Learn more about data cleansing through useful examples. Clean data and string manipulation formulas in Excel are critical! Besides the well-known techniques, we will introduce special VBA codes to make the process quicker and more effective. Table of contents: Effective ways to … Read more
Excel wildcard is a special character that helps you find text values that are approximately similar but are not exactly the same. In other words, you can use fuzzy matching with wildcards. In the example above, we want to summarize values in the sales column where the product name starts with ‘A.’ The formula looks … Read more
A logical test in Excel (logical expression) returns only two types of values: TRUE or FALSE. What is a logical test For example, if you want to test that the cell B3 is equal to the string “Product”, use the following formula: =B3=”Product” The formula has two outputs: TRUE or FALSE. Steps to create a … Read more
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
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
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
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 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, C2:E12 2. … Read more
