Excel Basics

### How to Convert Number to Date in Excel (6 Easy Ways)

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very ...

### Excel Transpose Formulas Without Changing References (4 Easy Ways)

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

### Does TABLE Function Exist in Excel?

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

### Cumulative Sum in Excel If Condition Applied (6 Methods)

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)

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)

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

### Excel Cell Color: Add, Edit, Use & Remove

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 If Cell Contains Text Then Return Value (8 Easy Ways)

Excel has various built-in functions to match and fetch value if a cell contains text or string. In many cases, we try to search for a text or string ...

### How to Find Lowest 3 Values in Excel (5 Easy Methods)

Often, we come across a situation where we need to find the lowest values in a dataset. In this article, we’ll use SMALL, ROW, and AGGREGATE ...

### How to Set a Minimum and Maximum Value in Excel (6 Easy Methods)

In a dataset sometimes we need to input entries between ranges. In that case, entries between one minimum and one maximum value represent a whole ...

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

Blank cells inside the dataset sometimes become disturbing. These also create difficulties in the calculation. There are numerous methods to remove ...

### How to Remove Non-Printable Characters in Excel (4 Easy Ways)

Every Character printable or non-printable bears a Unicode Character Code or Value. The First 32 characters (0-31) of Unicode or ASCII in programs to ...

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

Sometimes in a dataset, we have to count odd and even numbers in Excel to understand the entries. In this article, we’ll describe ways to count odd ...

### How to Use Excel Sheet Name From Cell Value (Three Ways)

In many cases, you may need to use an Excel sheet name from a particular cell value such as creating an excel sheet name from a cell value, referring ...

### COUNTIFS with Multiple Criteria (5 Easy Methods)

COUNTIF counts cells in a range depending on a single criterion. Whereas COUNTIFS count cells in one or multiple ranges depending on multiple ...