Excel Basics

How to Highlight Text in Excel (7 Easy Ways)

Here's an overview of where you can find the conditional highlight options in Excel. Method 1 - Highlight Text in Excel Using the Font ...

How to Concatenate Apostrophe in Excel: 6 Easy Methods

Method 1 - Using Ampersand Operator (&) to Concatenate Apostrophe Steps: Type the following formula in cell D5. ...

How to Remove a Value in Excel (9 Methods)

The below dataset has 5 columns: Product Name, Order ID, Price, Order Date, and Status. Method 1 - Using a Keyboard Shortcut Steps: ...

How to Find a Character in Excel String (8 Easy Ways)

If we want to find specific characters of an Employee’s Name and ID, we have to find characters appearing in the Character Sign column. For a better ...

How to Remove Decimals in Excel (13 Methods)

    In the sample dataset, there are a variety of different currencies, quantities and their exchange rate to USD. The decimals need ...

How to Remove Semicolon in Excel?

Method 1 - Removing Ending Semicolon from Cells In the dataset below (B4:B9) containing some Microsoft Product names, there is a semicolon at the ...

Excel Find Last Column With Data: 4 Quick Ways

Method 1 - Use the TAKE Function to Find the Last Data of the Last Column Select any cell to place your resultant value. We selected the cell ...

Comparing Two Columns and Returning Common Values in Excel

Microsoft Excel offers several options for comparing columns, but most of them are for searching in one column only. This article will demonstrate ...

How to Highlight Selected Cells in Excel (5 Easy Ways)

Method 1 - Using Define Name to Highlight Selected Cells in Excel Step 1: Go to Formulas Tab > Select Define Name (in Define Names section). ...

How to Vlookup and Pull the Last Match in Excel – 4 Methods

This is a sample dataset with a list of products and their quantity.   Method 1- Applying the LOOKUP Function to Pull the Last ...

How to Remove Apostrophe in Excel?

Unwanted apostrophes can creep into Excel worksheets when copying data from Word or a website, or even from a simple typo. These apostrophes are ...

How to Highlight Blank Cells in Excel (4 Fruitful Ways)

In this article, we will discuss 4 different methods to highlight blank cells in Excel. We'll use the following dataset of the names of some students ...

Applying Conditional Formatting for Multiple Conditions in Excel

Here's an overview of using Conditional Formatting for multiple conditions. We have the two data tables, which we'll format. The first table ...

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

Method 1 - Using Conditional Formatting with INDEX-MATCH with a Fixed Lookup Value in Excel (Over a Single Column) Steps: Select the column on ...

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

The sample dataset (B4:F9) contains names of employees, their projects and their working hours on different days. Method 1 - Use the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo