Excel Formulas

How to Calculate the Duration of Time in Excel (7 Methods)

We have a dataset with starting times and ending times. We'll measure time durations from the starting times to the ending times. Method 1 ...

Concatenate Multiple Cells Based on Criteria in Excel (4 Methods)

Here's an overview of concatenating cells if they meet certain criteria. How to Concatenate Multiple Cells Based on Criteria in Excel: 4 ...

How to Get Average Time in Excel (3 Examples)

We'll show you three examples of how to calculate the average time from a data collection of specific times in the sections below. Here is an example ...

How to Convert Week Number to Date in Excel (2 Suitable Methods)

Method 1 - Using the DATE and WEEKDAY Functions to Convert Week Number to Date There are no straightforward functions to convert the week number to ...

How to Calculate the Annual Growth Rate in Excel – 3 Methods

Method 1 - Calculate the Compound Annual Growth Rate in Excel This is the basic formula: =((End Value/Start Value)^(1/Time Periods)-1 This ...

How to Calculate 7 Day Moving Average in Excel (4 Ways)

What Is the Moving Average? The moving average is a type of average of numbers where the time frame remains the same but the data keeps updating as ...

How to Convert a Column into a Comma Separated List With Single Quotes – 5 Methods

Download Practice Workbook Download the practice workbook to exercise. Convert Column to List.xlsm The dataset contains information ...

Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)

In this article, we’ll demonstrate the easiest ways to calculate the percentage in Excel using absolute cell references. What are Absolute ...

How to Calculate Reverse Percentage in Excel (4 Easy Examples)

Example 1 - Calculate Reverse Percentage Manually in Excel We will use the following sample dataset that contains the percentage of the total amount ...

How to Apply Percentage Formula in Excel for Marksheet (7 Applications)

  Method 1 - Fundamental Percentage Formula in Excel for a Marksheet If we want to determine what percentage of A is B we will use the ...

How to Concatenate Two Columns in Excel with Hyphen: 9 Quick Methods

Method 1 - Using the CONCATENATE Function to Concatenate Two Columns with a Hyphen Steps: ➤ Use the following formula in cell D4. ...

How to Convert Percentage to Number in Excel (5 Easy Ways)

Method 1 - Convert Percentage to a Number from the Home Tab Let's use a dataset that contains the information of sales for two months of some ...

How to Convert Single Columns to Rows in Excel with Formulas – 4 Methods

Method 1 - Excel Formulas with OFFSET Function to Convert One Column to Multiple Rows Steps: Enter the formula in D5. ...

How to Convert Multiple Columns into a Single Row in Excel: 2 Methods

Method 1 - Convert Multiple Columns into a Single Row with Formula You will find the dataset in the sheet named “Dataset”. Convert these ...

How to Concatenate Numbers with Leading Zeros in Excel: 6 Methods

Method 1 - Using the CONCATENATE Function in Excel to Concatenate Numbers with Leading Zeros STEPS: Go to the Home tab. Select Number and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo