Calculate 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: 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: 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: 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: 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: Calculate the height and volume of a pyramid

Need to know how to calculate the height and volume of a pyramid in geometry? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Calculate child support payments in Microsoft Excel

Looking for a primer on how to calculate child support payments in a Microsoft Excel spreadsheet? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, you'll learn how to do just that. For more information, including detailed instructions on how to find child support payment amounts yourself, watch this helpful how-to.

How To: Calculate taxable earnings given a ceiling in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...

How To: Calculate the coefficient of variation (CV) in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 42nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate the coefficient of variation.

How To: Calculate percentage change in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 267th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate percentage change using a simple universal formula: (End Value)/Beg Value)/Beg Value = Percentage Change.

How To: Calculate probabilities with Excel's BINOMDIST feature

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 21st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the BINOMDIST function to calculate probabilities for a binomial experiment - binomial distribution!

How To: Calculate interest rates for payday loans in MS Excel

The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an example where you give the lenders a check of $250 that has a date 25 days in future and get $200 loan today. Now he teaches us hot to calculate APR and EAR. HE has got the data ready there, the period of the loan which is 25...

How To: Calculate total savings in Excel

This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.

How To: Calculate averages in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Calculate the probability of two dependent events

This video explains how to solve the problem of probability dependent events. In this video the problem is that a box contains three pens, 2 markers, and 1 highlighter. The person selects one item at random and does not return it to the box. So what is the probability that the person selects 1 pen and 1 marker. That is 6 items total. First she count the all items that involved in this problem. Then count the individual probability of the pen and marker. The person selects 3 pens out of 6 item...

How To: Calculate percentages in your head

This video explains how to calculate percentages in your head. To calculate a percentage in your head, start by breaking the percentage off into smaller units. For example 25% is 10 + 10 + 5. 30% is 10, 10, and 10. Now you have numbers you can easily work with in your head. Find 10% of the number. This is easily done by one of two methods. You can either move the decimal point one place to the left or you can drop the last number. Dropping the last number sometimes gives you an estimate, thou...

How To: Calculate GPA

If you fear you're off to summer school, ease the stress of uncertainty with some simple math and know when to seek help with your grades.

How To: Calculate a limit at infinity with a radical

In this video, we learn how to calculate a limit at infinity with a radical. The idea is to take out the higher power of 'x' in the denominator first. If the x squared is under a radical, take that out so you're left with just 'x'. After this, divide every term by 'x'. Once you are finished with this, you can rewrite the equation. Next, you will use the rules of math to find the answer of the equation. This is hard math to do if you aren't used to it! Make sure you practice with the samples i...

How To: Calculate the volume of a cube in basic geometry

With mathematics, as with anything else, not everyone progresses at the same rate. Geometry is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the volume of any cube.

How To: Calculate the volume of a triangular solid or triangular prism

With mathematics, as with anything else, not everyone progresses at the same rate. Geometry is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the volume of a triangular prism.

How To: Calculate the volume of a rectangular solid

With mathematics, as with anything else, not everyone progresses at the same rate. Geometry is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the volume of a rectangular solid.

How To: Calculate the surface area of a triangular solid in geometry

With mathematics, as with anything else, not everyone progresses at the same rate. Geometry is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the volume of a prism.

How To: Calculate the surface area of a rectangular solid in basic geometry

With mathematics, as with anything else, not everyone progresses at the same rate. Geometry is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the surface area of a rectangular solid.

How To: Calculate standard deviation with graphing calculator

This video tutorial is in the Education category which will show you how to calculate standard deviation with TI graphing calculator. First you got to enter the data in to the calculator. Go to stat and click on enter. This will edit a list. Now you type in these numbers: 50, 20, 33, 40 and 55. Then press stat and click on enter. This will bring up the 1-var stats page. Press the "2nd" button and L1, because all our data is in L1. Click on enter and you will get all the data that you will nee...

How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Calculate compound interest using a TI-84 and solver

This is a video tutorial in the Electronics category where you are going to learn how to calculate compound interest using a TI-84 and solver. Press the apps button on the calculator and press enter to load the TVM Solver which is the 1st choice. Here the meaning of various notations are N is time, I% is the percentage, PV is present value, PMT is payment, FV is future value and C/Y is compounding period. The problem is find the compound amount and the interest earned on $12,903.45 compounded...