Latest Blog Posts - Page 354 of 413

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 Delete Row If Cell Contains Specific Values in Excel?

Jul 29, 2024

We will be using a sample dataset that contains the Name and Age of some people. Method 1 - Using Find and Replace to Delete a Row If a ...

How to Delete Row If Cell Contains Specific Values in Excel?

How to Convert Text to Number in Excel with VBA

Jun 16, 2024

How to Identify Numbers Formatted as Text Take a look at this dataset. We have some numbers in a column. Though we have numbers ...

How to Convert Text to Number in Excel with VBA

How to Convert Number (YYYYMMDD) to Date Format in Excel – 4 Methods

Aug 3, 2024

Several Date formats are available in Excel. This is the sample dataset. Method 1 - Using the TEXT Function to Convert Number ...

How to Convert Number (YYYYMMDD) to Date Format in Excel – 4 Methods

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Aug 11, 2024

Observe the GIF: Click on the image for a better view. The VBA command will be used to delete an entire row. Customize the command to ...

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

Aug 12, 2024

Method 1 - Using a VBA Macro to Insert Rows Based on the Cell Text Value in Excel To insert a new row based on the specific text value “Insert ...

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

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 Compare Addresses in Excel (11 Possible Methods)

Jun 11, 2024

To demonstrate our methods, we'll use the following dataset of two sets of bank customers, and find out which have accounts at both banks. ...

How to Compare Addresses in Excel (11 Possible Methods)

How to Use IFERROR with VLOOKUP in Excel: 5 Different Methods

Jul 5, 2024

Method 1 - Replace #N/A with Custom Text Search for a student whose name isn’t in the list, you want to show custom text such as “Not found”. Enter ...

How to Use IFERROR with VLOOKUP in Excel: 5 Different Methods

How to Delete All Rows Below a Certain Row in Excel: 6 Methods

Jun 4, 2024

Method 1 - Use of Delete Option in Context Menu to Delete Rows Steps: Select the Cell B11. Press CTRL+SHIFT+➜+⬇. The cells of the last ...

How to Delete All Rows Below a Certain Row in Excel: 6 Methods

How to Sum Colored Cells in Excel (4 Ways)

Jul 3, 2024

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. However, there are a few ways to implement this kind of ...

How to Sum Colored Cells in Excel (4 Ways)

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 Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

Jul 5, 2024

Method 1 - Use Excel TRIM Function to Remove All Leading and Trailing Spaces The TRIM function removes all spaces from a text string except for ...

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

How to Fill Color in Cell Using Formula in Excel (5 Easy Ways)

Jul 3, 2024

Here's an overview of the formulas we used to fill in cells with colors. We're using a sample Pay Sheet of several employees. There are 4 ...

How to Fill Color in Cell Using Formula in Excel (5 Easy Ways)

SUMIFS with Multiple Criteria Along Column and Row in Excel

May 21, 2024

Introduction to SUMIFS Function in Excel The SUMIFS function is a math and trig function. It adds all of its arguments that meet multiple criteria. ...