Excel Formulas

How to Find a Residual Standard Error in Excel (2 Easy Methods)

Below is a dataset with 3 columns: “Company,” “Advertising,” and “Revenue.” We will find the relationship between advertising and revenue generation ...

How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)

  In an Eisenhower Matrix, we will have two parts. One part is the data section of the template. The data section will contain two parameters ...

How to Round Percentages in Excel (4 Simple Methods)

The dataset below shows employees' sales commissions in a percentage format. We will round the percentages. Method 1 –  Using the ROUND ...

How to Find a Significant Difference Between Two Numbers in Excel (2 Methods)

Method 1 - Using the ‘Data Analysis’ Tool    Step 1: Download and Install the Data Analysis ToolPak Go to the top left corner of Excel ...

Round Time to the Nearest 5 Minutes in Excel – 4 Methods

The dataset contains a column with time. To round the time to the nearest 5 minutes: Method 1 - Using the ROUND Function STEPS: Set ...

How to Create a Matrix Chart in Excel (2 Methods)

In the dataset below, we have records of the selling prices, cost prices, and profits of a company's products. Watch Video – Create a ...

How to Create a Training Matrix in Excel (3 Easy Methods)

To demonstrate our methods for creating a training Matrix in Excel, we’ll use the following dataset with 3 columns: “Employee”, “Topic”, and “Date”. ...

How to Round to the Nearest 5 or 9 in Excel (8 Methods)

Dataset Overview The following dataset will be used to demonstrate all of the methods. Method 1 - Combination of ROUND, CHOOSE and MOD ...

How to Round to the Nearest 10 Cents in Excel (4 Methods)

The Product List table contains ID No., Item and Price columns. We can see in the Price column the price is up to 2 decimal places. Here, we will use ...

How to Round a Formula with SUM in Excel (4 Simple Ways)

  We’ll use the following dataset that represents some product prices. Method 1 - Using ROUND and SUM Functions to Round a Formula ...

The Difference Between Two Dates in Months in Excel (4 Examples)

Let’s first introduce our dataset. It contains the launch and closing dates of some random projects. We aim to calculate the difference between two ...

Rounding Time in Excel to Nearest Hour: 6 Easy Methods

Method 1 - Rounding Time to Nearest Hour Using Excel ROUND Function Steps: Make a column for rounding time to the hour and type the formula in ...

How to Add a ROUND Formula to Multiple Cells in Excel – 2 Methods

This is the sample dataset. Method 1 - Dragging the Fill Handle Icon to Apply the ROUND Formula Steps Select D5 and enter the ...

Rounding to Nearest Dollar in Excel: 6 Easy Ways

Method 1 - Using ROUND Function for Rounding to Nearest Dollar Steps: Select cell E5. Write down the following formula into the cell. ...

How to Calculate Difference Between Two Times in Excel: 8 Suitable Methods

While calculating time differences in Excel, you have to be careful about the Number formats of individual time values. Before starting the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo