Excel Basics Archives - Page 84 of 108

How to SUM with IF Condition in Excel (6 Ways)

May 17, 2022 Excel Basics

Sometimes we need to sum up values based on criteria in Excel. To meet up this requirement, Excel has embedded itself with a built-in function called ...

How to Sum Between Two Numbers Formula in Excel

May 17, 2022 Excel Basics

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 Compare Two Cells in Excel (10 Easy Methods)

May 17, 2022 Excel Basics

There are many ways to compare cells in Excel. You can compare two cells and find matches, differences, and some other operations using Excel. In ...

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

Feb 22, 2022 Excel Basics

Excel is one of the widely used tools we use for our office and business. For most of those works, we need to deal with a large amount of data. ...

Lookup Value in a Range and Return in Excel (5 Easy Ways)

May 17, 2022 Excel Basics

If you want to look up certain criteria in a range and find the matching value, this article is the right place for you. I’ll show you 5 easy ways to ...

SUMIFS Sum Range Multiple Columns in Excel(6 Easy Methods)

May 17, 2022 Excel Basics

Often, we come across instances where we need to sum range spreading multiple columns. In this article, we use functions such as SUM, SUMIF, SUMIFS, ...

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

May 17, 2022 Excel Basics

Sometimes the numbers in your worksheet don’t act like numbers; they don’t execute any kind of arithmetic operations as they should, they even may ...

Convert Text to Date and Time in Excel (5 Methods)

Feb 20, 2022 Excel Basics

In Excel, we mainly work with data. We organize and manipulate data as per our requirements. We find out the required information from our managed ...

Excel Create Dynamic List from Table (3 Easy Ways)

May 22, 2022 Excel Basics

In general, lists are made by extracting entries from a dataset. If the lists update automatically then the lists are dynamic lists. In this article, ...

Delete Blank Rows in Excel (8 Handy Methods)

May 21, 2022 Advanced Excel

Imagine a case when you have a set of data in an Excel worksheet, and you see some unnecessary blank rows. No doubt, such unexpected empty rows annoy ...

How to Rotate Text in Excel ( 3 Easy Techniques)

Apr 25, 2022 Excel Basics

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 Separate Two Words in Excel (6 Easy Ways)

May 17, 2022 Excel Basics

Separating two words in Excel is quite handy in order to extract data from a dataset. In this article, we use LEFT, RIGHT, LEN, SEARCH, FIND ...

Excel Paste Transpose Shortcut: 4 Easy Ways to Use

Jun 20, 2022 Excel Basics

In this article, we will discuss the Transpose option of Excel Paste Shortcut. In Excel, we generally transpose Rows to Columns or vice-versa. We can ...

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

Jun 21, 2022 Excel Basics

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

Invoice Excel Formula

Mar 19, 2022 Excel Basics

Many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...