Excel Formulas

How to Calculate Binomial Probability in Excel (with Easy Steps)

In the modern world, most of our work depends on data or report analysis, which helps to make future predictions, business proposals, thoughtful ...

How to Add 15 Percent to a Price in Excel (2 Easy Methods)

Sometimes we may want to increase the price by a certain percentage. It's quite easy to change the price by a certain percentage in Excel. Here in ...

IF Percentage Formula in Excel (4 Easy Examples)

Consider the following dataset as an overview of what you can achieve by using the IF function to check percentile values. The dataset contains marks ...

How to Create a Percentage Polygon in Excel (2 Handy Ways)

Excel has a powerful graphing feature that can add visual depth and clarity to even the most mundane of datasets. For instance, you may need to make ...

How to Add Military Time in Excel (3 Easy Ways)

Military time is a 24-hour time. This timing system is quite different from the standard timing system. There is no AM or PM in military time. The ...

How to Average Negative and Positive Numbers in Excel

We have created a column in Excel with positive and negative numbers like Water Height from the Average Depth of a River in the range C4:C11. We have ...

How to Add an Average Line to an Excel Chart -3 Steps

Step 1 - Prepare the Dataset Assume you have the following class result table: Select the data range and go to Insert >> Recommended ...

AGGREGATE vs SUBTOTAL in Excel (4 Differences)

This article will focus on the AGGREGATE vs SUBTOTAL functions of Microsoft Excel. The AGGREGATE function in Excel contains nineteen distinct ...

Excel AutoSum Not Working: 4 Possible Solutions

Method 1 - Changing the Cell Format Steps: Select all the cells from C5 to C9. Go to the Number section under the Home tab and select the ...

How to Calculate Daily Average in Excel (3 Methods)

The sample dataset contains hourly views of different blog posts of ExcelDemy from 9/20/2022 to 9/24/2022. From these hourly views for a day, we will ...

How to Add and Subtract Dates in Excel (6 Suitable Ways)

We'll use a dataset of a company's Product Order Date. Columns B and C in the dataset represent Product Name and Order Date, respectively. ...

How to Calculate Population Growth Rate in Excel: 2 Effective Methods

Method 1 - Calculate Average Annual Population Growth Rate Find out the average annual growth rate of the population. Find the growth rate for each ...

How to Calculate Percentage Share in Excel (3 Suitable Ways)

Percentage share is a popular term in business organizations. In other sectors, this term is also used. We will calculate the percentage share in ...

How to Create a Department Budget in Excel (with Detailed Steps)

Looking for a way to create a department budget in an Excel workbook? Don't worry at all. You have landed in the right place. just take a cup of tea ...

How to Add Comma Before Text in Excel (6 Suitable Ways)

Whenever working with Excel you may face a situation where you will need to add comma before text. The main objective of this article is to explain ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo