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: Create a Basic Attendance Sheet in Excel

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

How To: Compare two lists and extract the new values in Excel

How To: Generate a dynamic list from a table in MS Excel

How To: Align & group objects & use gridlines in MS Word 2007

How To: Create a passfail grade formula in Microsoft Excel

How To: Calculate Commission Based on Varying Rates in Excel

How To: Extract records that meet certain criteria in Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

How To: Create confidence intervals for proportions in Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Save Your Word Document as PDF with One Click (Using a Macro)

How To: Repeat each successive date in an Excel date column

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

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

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Work with nominal, ordinal & interval scale in Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

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

How To: Compare two lists and extract the new values in Excel

How To: Generate a dynamic list from a table in MS Excel

How To: Align & group objects & use gridlines in MS Word 2007

How To: Create a passfail grade formula in Microsoft Excel

How To: Calculate Commission Based on Varying Rates in Excel

How To: Extract records that meet certain criteria in Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

How To: Create confidence intervals for proportions in Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Save Your Word Document as PDF with One Click (Using a Macro)

How To: Repeat each successive date in an Excel date column

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

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

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Work with nominal, ordinal & interval scale in Excel
Be the First to Comment
Share Your Thoughts