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 38th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR and EAR given cash flows from annuity in MS Excel.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Make calculations for 30 day months in Microsoft Excel

How To: Enter formulas in Excel with a macro

How To: Calculate proportions and percentages in Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Create an Excel inventory template with running totals

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

How To: Update inventory records by formula in Microsoft Excel

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

How To: Find range and interquartile range in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Graph the probability density function in an Excel file

How To: Print doublesided and reverse printing order in Word

How To: Identify the first occurrence of a value in a column in Microsoft Excel

How To: Download & install the Microsoft Excel MoreFunc addin

How To: Remove tabs & scroll bars from an Excel spreadsheet

How To: Calculate hours worked while subtracting lunch hours in Excel 2010

How To: Use rounding functions & paste special values in Excel

How To: Find a PValue with Excel

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Make calculations for 30 day months in Microsoft Excel

How To: Enter formulas in Excel with a macro

How To: Calculate proportions and percentages in Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Create an Excel inventory template with running totals

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

How To: Update inventory records by formula in Microsoft Excel

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

How To: Find range and interquartile range in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Graph the probability density function in an Excel file

How To: Print doublesided and reverse printing order in Word

How To: Identify the first occurrence of a value in a column in Microsoft Excel

How To: Download & install the Microsoft Excel MoreFunc addin

How To: Remove tabs & scroll bars from an Excel spreadsheet

How To: Calculate hours worked while subtracting lunch hours in Excel 2010

How To: Use rounding functions & paste special values in Excel
Be the First to Comment
Share Your Thoughts