Excel Basics Archives - Page 156 of 176

How to Remove Blank Lines in Excel (7 Methods)

Jul 24, 2024

Dataset Overview In our dataset we have data of different members of a club. Our dataset contains several blank lines. We will delete these empty ...

How to Remove Blank Lines in Excel (7 Methods)

How to Separate Two Words in Excel (6 Easy Ways)

Apr 16, 2024

The following image shows one of the ways to separate two words in Excel. Read on to learn more. Let’s say we have a dataset containing a ...

How to Separate Two Words in Excel (6 Easy Ways)

How to Paste Transpose in Excel Using Shortcut: 4 Methods

Jul 7, 2024

Method 1 - Using Ribbon Paste Shortcut to Transpose in Excel We can transpose by using the Ribbon commands. The process is given below: Steps: ...

How to Paste Transpose in Excel Using Shortcut: 4 Methods

How to Convert Text to Date in Excel (10 Ways)

Jul 29, 2024

Here's an overview of a list of dates in textual values that will be converted to dates. How to Convert Text to Date in Excel: 10 Ways We ...

How to Create an Invoice using an Excel Formula – 8 Steps

Aug 13, 2024

This is the sample dataset. Download Practice Workbook Download this practice workbook. Invoice Excel Formula.xlsx Include: ...

How to Create an Invoice using an Excel Formula – 8 Steps

How to Convert Number to Date in Excel (6 Methods)

Jul 29, 2024

Overview In the following sections, I’ll explain various methods for converting numbers to dates using Excel. Whether you’re dealing with raw data ...

How to Convert Number to Date in Excel (6 Methods)

How to Transpose Formulas Without Changing References in Excel

Nov 11, 2025

Transposing data means data in Excel’s rows are shifted into Excel’s columns, whether auto-update is necessary or not. Transposing with formulas is ...

How to Transpose Formulas Without Changing References in Excel

Does TABLE Function Exist in Excel?

Nov 11, 2025

In Microsoft Excel, a Table is a tremendously instrumental tool to process large amounts of data with ease. It saves a lot of time and reduces a lot ...

How to Get a Cumulative Sum in Excel If a Condition is Applied (6 Methods)

Jun 4, 2024

Method 1 - Using IF with Cell Reference for Excel Cumulative Sum with Condition Steps: In cell D5, enter the following formula: ...

How to Get a Cumulative Sum in Excel If a Condition is Applied (6 Methods)

How to Add Space Between Text in a Cell in Excel (4 Easy Ways)

Jun 28, 2024

We imported Name and ID data into Excel as merged text. We want to make a proper structure of Name and ID. How to Add Space Between Text ...

How to Add Space Between Text in a Cell in Excel (4 Easy Ways)

Excel Cell Color: Add, Edit, Use & Remove (7 Quick Ways)

Nov 11, 2025

Sometimes we need to color our Excel cell to make the dataset unique, highlighted, beautiful, and easy to visualize. In this article, we will know ...

Excel Cell Color: Add, Edit, Use & Remove (7 Quick Ways)

How to Check If Cell Contains Text Then Return Value in Excel

Jul 2, 2024

We have entries of certain Categories and Products in a dataset. We'll check if a cell contains text and then return a value in Excel. ...

How to Check If Cell Contains Text Then Return Value in Excel

How to Find Lowest 3 Values in Excel: 5 Easy Ways

Jun 3, 2024

Method 1 - Using SMALL Function Step 1: Click on any cell E5. Insert the formula: =SMALL(C5:C10,1) Step 2: Press ENTER. The First lowest ...

How to Find Lowest 3 Values in Excel: 5 Easy Ways

How to Set a Minimum and Maximum Value in Excel – 4 Methods

Aug 4, 2024

This is an overview. The dataset below showcases the Sizes and Prices of several shirt samples. Method 1 - Using the Data ...

How to Set a Minimum and Maximum Value in Excel – 4 Methods

How to Remove Blank Cells in Excel (10 Easy Ways)

Jul 3, 2024

Here's the overview of a sample dataset where blank cells are removed. How to Remove Blank Cells in Excel: 10 Quick Ways Method 1 - ...