Hosne Ara

Often we need to remove the text before a space using an Excel formula. Although there are several ways to delete text before a space, using formulas is more ...

Method 1 - Use of ‘Paste Link’ Option to Connect Several Cells from a Different Worksheet Steps: Go to Sheet2 and copy the range of multiple cells (here ...

We'll use the Excel PPMT function to find out the principal portion of the mortgage monthly payment. We'll introduce the PPMT function first. Introduction to ...

Method 1 - Applying the Excel Clipboard to Join Several Cells without Losing Data Steps: Go to the Home tab and click on the Anchor button from the ...

In the following overview image all formulas are displayed in the sheet.   This is the sample dataset containing Employee Name, Basic Salary, ...

Method 1 - Applying Excel MAX Formula to Find Maximum Value in Range Steps: Type the below formula in Cell B15 and press Enter from the keyboard. ...

METHODS TO ADD Method 1 - Use an Empty Cell as Reference Insert a Blank Cell: Add an empty cell at the beginning of your source list. For example, ...

Dataset Overview We'll use the list of dates below to convert to year. Method 1 - Convert Date to Year Using Excel YEAR Function Open your ...

Let’s consider a dataset containing area-wise sales data of several fruits. We will create a Data Validation drop-down list of areas mentioned in the dataset ...

We have a sample dataset containing several fruits and their corresponding fruit types. We'll calculate the number of rows from column B that contain fruits ...

Let’s consider a dataset (B5:D10) containing fruit names in two columns (columns B and C). We will compare fruit names between these columns and return TRUE or ...

In this article, I will discuss how you can select multiple Excel cells without using a mouse. I will use keyboard shortcuts mostly to select cells. So, if you ...

Method 1 - Select All Cells with Values Using the ‘Go To Special’ Command The dataset below has data on several areas of fruit sales date-wise. However, it ...

Most of the time we use a cell reference in an Excel formula. However, often we have to update the formula based on different situations. Now, if you are ...

We have a data range (B4:E12) that contains sales data for several electronic products (Date-wise). You can delete blank cells manually by selecting them one ...