Excel Basics Archives - Page 155 of 176

How to SUM with IF Condition in Excel (6 Suitable Examples)

Jul 3, 2024

Here's an overview of using the SUMIF function to check how many values fulfill a condition. Download the Practice Workbook SUM IF ...

How to SUM with IF Condition in Excel (6 Suitable Examples)

How to Sum Between Two Numbers Formula in Excel

Nov 11, 2025

Every now and then we need to find out the sum of data for a range between two numbers in Excel. In this article, we use functions such as SUMIFS, ...

How to Sum Between Two Numbers Formula in Excel

How to Compare Cells in Excel (10 Easy Methods)

May 24, 2024

We will use the sample dataset below to demonstrate how to compare two cells in Excel. Method 1 - Compare Two Cells Side by Side Using ...

How to Compare Cells in Excel (10 Easy Methods)

How to Delete Duplicates But Keep One Value in Excel (7 Methods)

Jun 14, 2024

You can see the Country, Name, and Position columns in the following dataset. Using this dataset, we will go through 7 different methods to delete ...

How to Delete Duplicates But Keep One Value in Excel (7 Methods)

How to Lookup and Return the Value in a Range in Excel – 5 Methods

Aug 4, 2024

This is an overview. The following dataset has the Income Greater than, Income Lower than or Equal, and Tax Rate columns. ...

How to Lookup and Return the Value in a Range in Excel – 5 Methods

SUMIFS: Sum Range Across Multiple Columns (6 Easy Methods)

Apr 16, 2024

To demonstrate how to sum ranges, we have the following dataset of product sales for different months. Let's determine the total number of sales for ...

SUMIFS: Sum Range Across Multiple Columns (6 Easy Methods)

How to Convert Bulk Text to Number in Excel (6 Suitable Ways)

Jun 16, 2024

In this article, we will show you how to convert bulk text to numbers in Excel in 6 ways. Consider the following dataset of Product and Order IDs. ...

How to Convert Bulk Text to Number in Excel (6 Suitable Ways)

How to Convert Text to Date and Time in Excel (5 Easy Ways)

Jun 16, 2024

Here's a brief overview of how you can convert various text formats into the date formatting in Excel. We will discuss several functions that ...

How to Convert Text to Date and Time in Excel (5 Easy Ways)

How to Create Dynamic List From Table in Excel (5 Quick Ways)

Jun 26, 2024

We have a sample Sales Dataset containing the “Product”, “Quantity”, “Unit Price” and “Total Sales” columns shown in cells B4:E18. We want to ...

How to Create Dynamic List From Table in Excel (5 Quick Ways)

Excel VBA to Transpose Array (3 Suitable Examples)

Aug 4, 2024

The generic syntax of transposing an Array with VBA is: WorksheetFunction.Transpose(Arg1) Arg1 = It is a required argument which is a range ...

Excel VBA to Transpose Array (3 Suitable Examples)

How to Delete Blank Rows in Excel?

Aug 1, 2024

Method 1 - Delete a Couple of Blank Rows Manually Press & hold the Ctrl key and select the blank rows. Right-click > Go to the ...

How to Rotate Text in Excel ( 3 Easy Techniques)

Nov 11, 2025

By default, Excel cells store horizontally aligned text. But for our purposes, very often we need to change the orientation of the text in cells from ...

How to Rotate Text in Excel ( 3 Easy Techniques)

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