Excel Basics Archives - Page 156 of 176

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

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

How to Remove Non-Printable Characters in Excel?

Jul 3, 2024

The sample dataset contains some non-printable characters in the Student Name column. We will try to remove these characters using the following ...

How to Remove Non-Printable Characters in Excel?

How to Count Odd and Even Numbers in Excel (3 Easy Ways)

Jul 11, 2024

Method 1 - Combine SUM and MOD Functions to Count Odd and Even Numbers 1.1 Counting Odd Numbers Steps: Apply the following formula in your ...

How to Count Odd and Even Numbers in Excel (3 Easy Ways)

How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

Jul 3, 2024

Method 1 - Combining MID, CELL, and FIND Functions to Insert the Sheet Name into Cell Value Consider the following dataset. We want to insert the ...