Excel Basics

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

How to Rename Sheet in Excel (6 Suitable Ways)

While working in Excel, often we have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. In ...

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

How to Autofill a Column in Excel (7 Easy Ways)

Below you can see a dataset with missing entries. In this article, we’ll cover 7 methods that use autofill to fill up the empty cells. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo