Excel Basics

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 -> ...

Highlight Duplicates in Excel

In this article, we will learn how to highlight duplicates in Excel, find duplicates, and remove the duplicates in Excel. This option is quite basic ...

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 Remove Trailing Spaces in Excel (6 Easy Methods)

While working in Excel, we often encounter hasty inputs of trailing spaces in cells. Whatever the reasons may be, existing trailing spaces pose ...

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. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo