Examine Current Search Results

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

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.

How To: Calculate the future value of annuity with the FV function in Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the FV function to calculate the future value of an annuity.

How To: Create a savings plan that will yield $1,000,000 at retirement in Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PMT function to contrive a savings plan that will yield $1,000,000 at the time of retirement.

How To: Calculate the present value of annuity in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV function to calculate the present value of an annuity.

How To: Calculate the present value of an annuity for asset valuation in Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 34th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of annuity in Excel.

How To: Calculate the present value of an annuity with Excel's PMT function

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 35th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present of a loan with the PMT function.

How To: Use the APR function to make loan payment calculations in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.

How To: Extract dates from a cell with dates and words in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to use the DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM and REPLACE to extract dates from a cell containing both dates and words.

How To: Calculate monthly retirement income in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.

How To: Calculate APR and EAR given cash flows from annuity in Excel

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 how-to. 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.

How To: Calculate the number of periods it takes to pay off a credit card in Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 39th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the number of periods it will require to pay off a credit card balance in full.

How To: Create a perpetuity preferred stock valuation formula in Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 40th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a perpetuity preferred stock valuation formula in Excel.

How To: Create an interest-only loan schedule in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an interest-only loan schedule in Excel.

How To: Build an amortization table for a consumer loan with Excel's PMT function

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 4nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a consumer loan in Excel with the PMT function.

How To: Build an amortization table for a business loan with the PMT function

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 43rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an amortization table for a business loan with Excel's PMT function.

How To: Build an amortization table for a deep discount loan in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 44th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a deep discount loan in Excel.

How To: Calculate inventory turnover & days to sell ratios in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 18.5th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate common financial ratios.

How To: Calculate the future value of an investment in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 21st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the future value of an investment in Microsoft Excel.

How To: Calculate the present value of an investment in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 22nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of an investment in Microsoft Excel.

How To: Solve for total number of periods when you know PV & FV in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 23rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to solve for the total number of periods when the present and future values are known to you.

How To: Perform basic financial ratio analysis in Microsoft Office Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to perform simple financial ratio analysis.

How To: Make basic balance sheet calculations in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 9th installment in his "Excel Finance Class" series of free video lessons, you'll learn a number of handy formulas for making common balance sheet calculations.

How To: Calculate growth ratios and market value ratios in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the Earnings per Share EPS, Price to Earnings (PE), Dividends per Share, Internal Growth and Sustainable Growth ratios in Excel.

How To: Calculate cash flow from assets in Microsoft Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate cash flow from assets, cash flow to creditors and cash flow to shareholders using accounting financial statements.

How To: Calculate average and marginal tax rates in Microsoft Excel 2010

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.

How To: Use the CUMIPMT function for interest in MS Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the CUMIPMT function to calculate the cumulative interest on a loan for a 1 year period.

How To: Do a complete loan analysis in MS Excel

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 how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the PMT and RATE functions for a complete debt/loan analysis.

How To: Build an Excel table of fraction & percent equivalents

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.

How To: Use Excel's built-in SUM, MOD, LCM & PRODUCT functions

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.

How To: Make present value calculations in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 58th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make simple value calculations for the present.

How To: Find a checking account's service charge MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 35th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate the service charge for a checking account and see how to create a formula for the balance in a checkbook or checking register.

How To: Work with bank checks in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 34th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with the various elements of bank checks in Microsoft Excel.

How To: Solve an interest loan problem for part/base in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.

How To: Solve trade discount word problems in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 45th installment in his "Business Math" series of free video lessons, you'll learn when to solve a trade discount word problem with Excel.

How To: Find credit for a partial invoice payment in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 47th installment in his "Business Math" series of free video lessons, you'll learn how to determine credit given for partial payment of an invoice.