Excel Basics

Conditional Formatting Based on Multiple Values of Another Cell

Method 1 - Conditional Formatting on a Single Column Based on Multiple Values of Another Cell Step 1: Select Column and Open Conditional Formatting ...

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

We have placed some Product Names and their IDs in the dataset. We want to remove the numbers from the Product IDs. Method 1 - Using Find ...

Null vs Blank in Excel

While working with data in Microsoft Excel, you may encounter Null values or Blank cells. What Is Null in Excel? A null value in a cell ...

How to Check If Cell Is Empty Using Excel VBA: 5 Easy Methods

Method 1 - Using the VBA IsEmpty Function to Check If Cell Is Empty  Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

How to Delete Empty Cells in Excel (8 Easy Methods)

In this tutorial, we'll be covering some easy ways to delete empty cells in Excel. We'll use the following dataset (a sample student mark sheet) and ...

How to Use Conditional Formatting to Compare Two Columns in Excel

Conditional formatting allows you to change the appearance of cells based on specific criteria that you define. When the conditions are met, the cell ...

How to Split Excel Sheet into Multiple Worksheets (3 Methods)

Here's an overview of splitting an Excel sheet into multiple worksheets. We'll use a sample dataset representing the sales information of ...

How to Use COUNTIF with WEEKDAY in Excel (3 Methods)

Dataset Overview Let’s say we have data from a supermarket that includes the staff’s duty schedule. In this example, we’ll explore how to ...

How to Remove Parentheses in Excel?

In this article, we will demonstrate 4 easy methods to remove parentheses in Excel. What Are Parentheses in Excel? In general, ...

How to Remove Formulas in Excel – 8 Easy Methods

A sample dataset is shown below. Download Practice Workbook Download and practise. Removing Formulas.xlsm How to Remove ...

How to Remove the Dollar Sign in Excel – 7 Methods

The pre-formatted dataset shows the dollar sign ($) before the Price value. Method 1- Using the Format Cells Feature to Remove the Dollar ...

How to Insert a Total Row in Excel (4 Easy Methods)

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset ...

How to Convert Serial Number to Date in Excel (7 Simple Ways)

Method 1 - Converting Serial Number to Date in Excel with Format Cells Option Steps: Select the C5:C16 cells >> Right-click to open the ...

How to Wrap Text Using Shortcut Keys (2 Hotkeys)

What is Text Wrapping? Text wrapping refers to converting single-line text into multiple lines to better display cell contents to users. ...

How to Convert Range to Table in Excel (4 Methods)

Converting a range to a table in Excel means transforming a selected group of cells, typically containing data, into an Excel Table.  In Excel, you ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo