Excel Basics

How to Group and Ungroup Columns or Rows in Excel

  Consider you have data in existing cells that contain names from different countries. They have different room numbers to be allocated ...

How to Freeze Rows and Columns at the Same Time in Excel

We have an Excel worksheet with information about a company. We'll freeze the column header and the employee names so they stay on the screen while ...

How to Use the CLEAN Function in Excel – 10 Examples

This is an overview. CLEAN Function in Excel Function Objective The CLEAN function removes all non-printable characters from a text. ...

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...

How to Select Specific Data in Excel (6 Easy Methods)

  We have a datasheet where ID, Marks, and Student Names are given in columns B, D, and C, respectively. We will use the dataset to select ...

How to Calculate in Excel If Cells are Not Blank: 7 Exemplary Formulas

Method 1 - Combine IF and AND Functions to Calculate If Cells are Not Blank Step 1: Add a row to show the calculation. Step 2: Go to ...

How to Remove Single Quotes in Excel (6 Ways)

Consider a dataset of product descriptions for some products. The texts in the product description column lie between single quotation marks. If you ...

How to Apply Conditional Formatting to Color Text in Excel

While working with a big dataset in Excel that contains numerous entries, we need to find texts based on their specific text values, conditions, and ...

How to Use the VLOOKUP Function in Excel VBA – 4 Examples

Quick View: Sub VLOOKUP_with_User_Defined_Lookup_Value() Book = InputBox("Enter the Name of the Book: ") Set Rng = Range("B4:D13") MsgBox ...

How to Name a Cell in Excel (2 Easy Ways)

In our dataset, we have multiple Products with the sold Quantity, Unit Price, and Total Price. Here's an overview of naming cell D5 using the Name ...

How to Clear Contents in Excel Without Deleting Formulas

The GIF below is an overview of clearing Excel values without deleting formulas. Here, a VBA code clears the contents without deleting formulas. When ...

How to Return Value If Cell Is Blank (12 Ways)

Consider the following overview of checking if the cell is blank, where the status is updated based on the delivery date. We are using the ...

Change Font Color Based on Value of Another Cell in Excel

In this tutorial, we will demonstrate how to change font color based on the value of another cell. Here is an overview of the process. To ...

How to Add Leading Apostrophe In Excel (4 Ways)

Excel may treat certain entries, particularly numbers that start with zeros, as formulas or numeric data. By adding a leading apostrophe to a cell ...

How to Perform Data Validation for Alphanumeric Only in Excel

Method 1 - Using a Custom Formula to Data Validate Any Alphanumeric STEPS: Use the following formula in the C5 cell. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo