With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

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.

How to Calculate Hours in Excel Excluding Weekends. An Excel spreadsheet can become an indispensable tool for your business when you harness its power for keeping records and doing computations.

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

If you need to count or calculate number of Leap Years between two dates in Excel or list of two dates in Excel, make use of this formula to get things done.

Since each date is really just a number stored in Excel, to compute the midpoint of two dates you would use the same mathematical formulas you would use to calculate the midpoint of two numbers ...