Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

How to Calculate Time Cards in Excel. If you pay employees an hourly wage and use time cards to track their weekly work time, you can use Microsoft Excel to calculate work totals, simplifying your ...

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.