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

A. There are many ways to calculate depreciation in Excel, and several of the depreciation methods already have a built-in function included in the software. The table below includes all the built-in ...

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

How to Create the Average Function to Calculate Average Projected Revenue in Excel. If you track your daily earnings using an Excel spreadsheet, you can use the same spreadsheet to estimate your ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

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

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

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.