As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this howto. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how compound interest is calculated. See that Excel only sees 15 significant digits in Excel.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a Tangent Line with Excel

How To: Generate random numbers (with decimals) in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Create a Basic Attendance Sheet in Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Clear data & cell contents in Excel using a macro

How To: Find critical values with T functions in MS Excel

How To: Make an Excel gradebook that drops the 2 lowest scores

How To: Automatically insert symbols in Microsoft Excel

How To: Create a simple form in Microsoft Access

How To: Create a passfail grade formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Extract records that meet certain criteria in Excel

How To: Find range and interquartile range in Microsoft Excel

How To: Calculate geometric average in Excel with GEOMEAN

How To: Create a cumulative frequency distribution in MS Excel

How To: Fill in missing column values with Excel's IF function

How To: Apply names to formulas with Excel's Apply Name tool

How To: Find a PValue with Excel

How To: Create a Tangent Line with Excel

How To: Generate random numbers (with decimals) in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Create a Basic Attendance Sheet in Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Clear data & cell contents in Excel using a macro

How To: Find critical values with T functions in MS Excel

How To: Make an Excel gradebook that drops the 2 lowest scores

How To: Automatically insert symbols in Microsoft Excel

How To: Create a simple form in Microsoft Access

How To: Create a passfail grade formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Extract records that meet certain criteria in Excel

How To: Find range and interquartile range in Microsoft Excel

How To: Calculate geometric average in Excel with GEOMEAN

How To: Create a cumulative frequency distribution in MS Excel

How To: Fill in missing column values with Excel's IF function

How To: Apply names to formulas with Excel's Apply Name tool
Be the First to Comment
Share Your Thoughts