Excel Formulas

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

Method 1 - Concatenate a Date with Text and Keep the Date Format in Excel If you concatenate Text with Dates, then the Dates will be converted to ...

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

In the dataset below date and time values are in Text Format (they are left aligned).   Method 1 - Convert Text Date and Time to ...

How to Count Filtered Cells with Text in Excel – 3 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company. There is a blank cell and a number in Column B. Method 1 - Using ...

How to Calculate Average Rating in Excel: 7 Methods

Method 1 - Calculate Average Rating Using Multiplication and SUM function Step 1: Go to Cell E5. Put the formula below, which is the ...

How to Calculate the Turnaround Time in Excel Excluding Weekends – 3 Methods

This is the sample dataset. Calculate the Turnaround Time in days and then in Hours. Method 1 - Using the NETWORKDAYS Function to ...

How to Subtract Hours from Time in Excel (2 Easy Ways)

  Case 1 - Subtract Less Than 24 Hours from Time in Excel Method 1.1 - Apply Fundamental Method to Subtract Hours From the dataset, we can ...

How to Link Files in Excel (5 Different Approaches)

Method 1 - Link to a New File in Excel Our sample dataset contains some product names in column B and their prices in column C, and we want to ...

How to Convert Unix Timestamp to Date in Excel (3 Methods)

The Unix timestamp is a system of tracking time as a running total of seconds. The time count started at the Unix Epoch on January 1st 1970 UTC. So a ...

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

Consider a dataset, there are 6 AD timestamps which need to be converted to readable dates. To do that, the example will use Sequential Serial ...

How to Concatenate and Keep Currency Format in Excel (3 Methods)

While concatenating two or more pieces of text in Excel, different number formats like currency, decimal format, and percentage format are removed ...

How to Fix Convert to Number Error in Excel (6 Methods)

The sample dataset represents some bestseller books at amazon.com. The triangle-shaped green sign at the top-left corner of every cell in the ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

Method 1 - Apply the TRIM Function to Convert Scientific Notation to Numbers in Excel Step 1: Select cell C5 to convert scientific notation to ...

How to Use an Excel Formula to Calculate Overtime and Double Time (3 Methods)

Dataset Overview Let’s say we have a dataset containing an employee’s Entering and Existing Time on certain Dates. We want to calculate the Overtime ...

How to Convert SAP Timestamp to Date in Excel (4 Ways)

The following table containing the sales records of a company. It has some SAP Timestamps in the Order Time column. We will convert them into dates. ...

How to Calculate Average of Multiple Columns in Excel: 6 Methods

Method 1 - Calculate Average of Multiple Columns Using AVERAGE Function Steps: Type the below formula in cell B13 to calculate the average of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo