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: Clear data & cell contents in Excel using a macro

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

How To: Enter formulas in Excel with a macro

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

How To: Extract records that meet certain criteria in Excel

How To: Create an Excel inventory template with running totals

How To: Cross tabulate categorical data in Microsoft Excel

How To: Calculate income tax payroll deductions in MS Excel

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

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Turn off AutoCorrect symbols in Excel

How To: Create a checkbookbalancing formula in Excel

How To: Create a bond discount or premium amortization table in Excel

How To: Convert Excel spreadsheet data to XML

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

How To: Create a line chart in Microsoft Excel 2011

How To: Group categories in an Excel frequency distribution

How To: Round only the total column with SUM & ROUND in Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

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

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

How To: Enter formulas in Excel with a macro

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

How To: Extract records that meet certain criteria in Excel

How To: Create an Excel inventory template with running totals

How To: Cross tabulate categorical data in Microsoft Excel

How To: Calculate income tax payroll deductions in MS Excel

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

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Turn off AutoCorrect symbols in Excel

How To: Create a checkbookbalancing formula in Excel

How To: Create a bond discount or premium amortization table in Excel

How To: Convert Excel spreadsheet data to XML

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

How To: Create a line chart in Microsoft Excel 2011

How To: Group categories in an Excel frequency distribution

How To: Round only the total column with SUM & ROUND in Excel
Be the First to Comment
Share Your Thoughts