Excel Formulas

How to Concatenate Date/Day, Month, and Year in Excel

Frequently, we combine day, month, and year to create a complete date in Excel. But sometimes, you might need to combine the date along with the ...

How to Concatenate Email Addresses in Excel (4 Effective Ways)

While mailing a lot of people at a time in Microsoft Outlook, it’s quite boring and time-consuming to insert each email address one by one. If your ...

How to Calculate Percentage of Completion in Excel (3 Methods)

While working in Microsoft Excel, you might need to calculate the percentages of a project's completion so that your final report looks impressive. ...

How to Concatenate Rows in Excel with Comma (4 Easy Methods)

Concatenate is a fancy word for joining something. Microsoft Excel offers many ways to join two or more cell contents. But to join multiple cell ...

How to Calculate Semi Variance in Excel (3 Simple Methods)

Microsoft Excel is a powerful software. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel ...

How to Calculate Lead Time in Excel (2 Suitable Examples)

Projects are all about product quality and service to the customer. These elements' quality is mostly defined by the time span they are performed. ...

How to Calculate Current Age in Excel (2 Easy Ways)

The tutorial demonstrates various approaches for determining age in Excel given a birthdate. You will learn a few formulas to determine your exact ...

How to Calculate On Time Delivery Performance in Excel

When working with production and supply chains, it is an important task to calculate the on-time delivery performance. In this article, I will show ...

How to Create Minimum Variance Portfolio in Excel (2 Examples)

The article will show you how to create a Minimum Variance Portfolio in Excel. A properly organized portfolio with individual risky properties or ...

How to Create a Project Budget in Excel (With Easy Steps)

When you are creating a project budget, Excel can be a handy tool for you. Today we are going to show you how to create a project budget in Excel ...

How to Create Option Probability Calculator in Excel

Option probability is an important concept in trading from both the seller's and buyer’s perspectives. These values are also helpful in volatile ...

How to Do Trapezoidal Integration in Excel (3 Suitable Methods)

Trapezoidal Integration is one of the 2 methods of Numerical Integration in Excel. In Excel, there is no built-in function to calculate the ...

How to Calculate Productivity Percentage in Excel (3 Useful Cases)

Certainly, you can easily calculate a percentage in Microsoft Excel, powerful software for calculations. Productivity is a common term in economics. ...

How to Calculate Median Follow-up Time in Excel (with Easy Steps)

Have you ever heard of the term median follow-up time? Most people, especially those who don’t have involvement in the technical sector haven’t heard ...

How to Create a Payment Advice Template in Excel With Easy Steps

A payment advice is a document buyers send to seller to confirm an invoice has been paid. Steps: Add the name and address of the supplier ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo