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

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

How to calculate average GPA in Excel? You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>.

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

In Excel, the formula used to calculate a bond's modified duration is built into the MDURATION function. This function returns the modified Macaulay duration for a security, assuming the par value ...

Learn about the book value of equity per share, what it measures and how to calculate a company's book value of equity per share using Microsoft Excel.

How to Calculate Inflation-Adjusted Prices: Formulas & Examples Adjusting prices for inflation can help investors calculate how the value of their money changes over time. Dominic Diongson ...

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.