Latest Posts

Excel formula to calculate hours worked & overtime [with template]

It is easy to build an Excel formula to calculate hours worked and overtime of your employees. This is why Excel is widely used in the ...

Biweekly mortgage calculator with extra payments [Free Excel Template]

Biweekly mortgage calculator with extra payments "No Macro used. No installation is necessary. Just download and start using." - ...

How to calculate compound interest for recurring deposit in Excel!

In this short tutorial, I will show how to calculate compound interest (maturity value) for recurring deposits in Excel. If you don’t have a ...

Excel Formula to Add Percentage Markup [with Calculator]

In this tutorial, I will show several ways of using the Excel formula to add percentage markup to the cost price of a product. Adding markup % to ...

Excel Formula for Overtime over 40 Hours [with Free Template]

In this article, you will get the Excel formula for calculating overtime over 40 hours. The Excel template is ready for your daily use. ...

Flat and reducing rate of interest calculator in Excel [Free Download]

Flat and reducing rate of interest calculator in Excel "No Macro used. No installation is necessary. Just download and start ...

Mortgage calculator with extra payments and lump sum [Excel Template]

Mortgage calculator with extra payments and lump sum (Free Excel Template) "No Macro used. No installation is necessary. Just ...

How to find the 5 most frequent numbers in Excel (3 Formulas)

In this tutorial, I will show how to find the 5 most (or less or more) frequent numbers/values in Excel. I will use an Excel formula to do so. ...

Switch first and last name in Excel with comma (5 Easy Ways)

In this article, I will show how to switch first and last names in Excel with a comma. Depending on the problems, you might face many ...

How to Remove Commas in Excel (From Text & Numbers)

In this article, I will show you how to remove commas from the names (placed in the middle/in-between/last) and the numbers in Excel. Download Excel ...

Add days to date in Excel excluding weekends and holidays (4 ways)

In this tutorial, we shall discuss how to add days to date in Excel excluding weekends and holidays. I shall show several methods. Use that ...

How to find text in an Excel range & return cell reference (3 ways)

In this tutorial, I shall write how to find text in an Excel range and return the reference of the cell that holds the text. I will show ...

How to use point and click method in Excel [Make Formula Error-less]

When you use the Point and Click Method to build a formula in Excel, the formula becomes error-less and the process saves you time. So, it is ...

How to calculate future value with inflation in Excel

Do you want to know how to calculate the future value of money with inflation in MS Excel? Want to calculate inflation-adjusted return from your ...

How to reference cell in another Excel sheet based on cell value!

Want to use Excel to reference cells in another sheet based on a cell value? In this tutorial, I will explain the whole process step by step. I ...

ExcelDemy
Logo