Excel Basics Archives

How to Sum Between Two Numbers Formula in Excel

Dec 2, 2021 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 Delete Duplicates in Excel but Keep One (7 Methods)

Dec 2, 2021 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)

Dec 1, 2021 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)

Dec 1, 2021 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, ...

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

Dec 1, 2021 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)

Nov 30, 2021 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, ...

How to Delete Blank Rows in Excel (10 Methods)

Nov 30, 2021 Excel Basics

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 Delete Blank Rows in Excel (10 Methods)

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

Nov 29, 2021 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

Nov 30, 2021 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 ...

Invoice Excel Formula

Nov 29, 2021 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 ...

Convert Number (YYYYMMDD) to Date Format in Excel

Nov 29, 2021 Excel Basics

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, ...

Excel Transpose Formulas Without Changing References (4 Easy Ways)

Nov 29, 2021 Excel Basics

Transpose data means data in Excel's rows are shifted in Excel’s columns where auto-update is necessary or not. Transposing formulas is the same as ...

Cumulative Sum in Excel If Condition Applied (6 Methods)

Nov 28, 2021 Excel Basics

Cumulative summation is one of the most used operations throughout the world to keep track of data related to similar things. Cumulative summation ...

Remove Last Character from String Excel (5 Easy Methods)

Dec 1, 2021 Excel Basics

In instances, we come across additional data attached to the right of entries. We badly want to remove them. But doing it manually is a hideous task. ...

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

Nov 25, 2021 Excel Basics

It is a common phenomenon in Excel that we import data from external sources. By doing so, we encounter entries void of spaces. In this article, we ...