Tutorials

Discover how to drill down into a Pivot table in Excel. Then, let’s take a closer look and learn how to use the Quick Explore function easily!

Learn how to compare two columns in Excel to find, highlight or extract matches and differences using various methods.

This article will explain how to add a comma in Excel using the ampersand (&) operator or built-in functions.

This article explains how to sort by color in Excel using conditional formatting, filter function, or VBA automation. How to sort by color in Excel Here are the steps to sort by color: Select a cell inside the range that you want to sort. Use the Ctrl + Shift + L shortcut to turn the … Read more

This tutorial will show you how to fill a cell or a range using RGB color in Excel to create a gradient scale. The first part of the article will be about how to fill a cell using the myRGB function. We will use the Excel COLOR function in the second part to return the … Read more

Today’s tutorial will show how to swap cells in Excel (adjacent and non-adjacent) using a few clicks or a small VBA macro. Swapping cells is a fast and effective time-saving trick; you need only two clicks to perform it instead of using the usual copy-pasting or move operations. This guide is a part of our … Read more

This tutorial will explain how to show protected cells in Excel using conditional formatting, Microsoft Inquiry, or Search and Replace. How to show protected cells in Excel using conditional formatting? Steps to highlight protected cells in Excel: Select the entire Workbook Create a new conditional formatting rule Define a formula: =CELL(“protect”, A1)=0 Explanation: It’s easy … Read more

This tutorial will explain how to clear multiple cells (adjacent or non-adjacent) in Excel.

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: Sorting data to … 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

The scroll bar in Excel is one of the most useful tools in Form Controls. Using it will save time and get more space if you are using it. The most significant advantage comes when you work with a large data set. You can manage any size list in a small area using scroll bars. … Read more

If you are working on an excel dashboard, you need to create great-looking navigation. Everyone loves great UX! In today’s guide, I will show you how to build an interactive settings menu for your spreadsheet. Take a close look at the picture below! Take a closer look at the picture below! This simple menu lets … Read more

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? A Heat Map is a perfect solution to highlight the crucial data points in a table or a range. Let us see a simple example: You have … Read more