Calculating Search Results

How To: Calculate income tax payroll deductions 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 42nd installment in his "Excel Business Math" series of free video lessons, you'll learn about the wage bracket and percentage methods for calculating federal income tax payroll deductions.

How To: Calculate a bonus 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.

How To: Force a stuck formula to calculate 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 210th installment in their series of digital spreadsheet magic tricks, you'll learn what to do if your formula does not calculate and is showing the equal sign and the rest of the formula without calculating.

How To: Speed up calculations with custom Excel formulas

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.

How To: Calculate simple and compound 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 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Calculate percent error in chemistry lab activities

If you want to know how to calculate percent error easily, you should watch this video. Error is the amount of deviation from accurate values. Error calculation is not possible, unless you make a quantitative measurement of the various quantities involved in your experiment. Measurement can help us in calculating errors and knowing how right we are in our theoretical models. In calculating percent error, We need to get the experimental value and the value which you are aiming at, which is the...

How To: Use a formula to calculate the volume of a cube

Calculating the volume of a cube is very important in high school geometry classes. Calculating the volume of a solid can be confusing at first, but with a little practice you will be able to get it right. In this tutorial, high school math teacher Doug Simms teaches you exactly how to calculate the volume of a cube and offers examples so you can follow along. Listen to Mr. Simms and you will be at the top of your class!

How To: Calculate percentage growth rates

One formula that you will run into in Calculus is calculating the percentage growth rate using a logarithmic derivative, elasticity of demand, relation among elasticity of demand and also revenue. In this video you will learn the different formulas that are used, methods of solving each formula, and also the full solutions.

How To: Learn to calculate percent error with this music video

Math, chemistry, physics can all be a very difficult thing to understand. But if you have the right teacher, then it can make life a bit easier. Maybe even a music video explaining it can be a bit easier. In this tutorial, if you're having a tough time with calculating the percent error, this music video may be what you need. So check it out and good luck!

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Use Excel databases for home improvement calculations

New to 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 Excel tutorial from ExcelIsFun, the 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.

How To: Calculate the area of any triangle

This video will show you simply how to calculate the area of any triangle using basic geometry formulas. Since a triangle is basically half of a rectangle, the formula for calculating the area of a triangle is base times height. This video offers some insight and examples provided to you by a teacher about how to apply this formula to various types of triangles, whether they are right triangles, equilateral, isosceles, or another form of triangle. By watching this video, you will be well prep...

How To: Calculate the area of a parallelogram

Calculating The Area Of A Parallelogram A parallelogram is a 4-sided shape formed by two pairs of parallel lines. Opposite sides are equal in length and opposite angles are equal in measure. To find the area of a parallelogram, multiply the base by the height. The formula is:

How To: Calculate percentages with monetary examples

Do you need to brush up on your fraction and percentage skills or get ahead of the class in math? This video shows several different examples of how to calculate percentages by using fractions. Money is used as a frequent example because quarters and change are easier to figure out and can help you translate when solving a math problem. You can also solve equations by writing them down and diving the part by the whole. Sound complicated? Watch the video and see how easy you can master calcula...

How To: Calculate simple interest

Learn how to calculate simple interest with step-by-step instructions using the formula I=prt. Simply defined, interest equals principle times rate times time. The video shows various examples of calculating this formula by plugging different variables into the equation. Although, these calculations can seem hard to follow, the way they are presented is straightforward and simple to understand. The video also explains converting percentages to decimals, which is the cornerstone of applying th...

How To: Calculate percentage growth rates in calculus

Want to calculate percentage growth rates (also known as the relative rates of change)? Learn how with this free video calculus lesson, which covers calculating the percentage growth rate using a logarithmic derivative, elasticity of demand and the relation between elasticity of demand and revenue. 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 t...

How To: Calculate probability in "at least one" problems

Calculating probablities can be used to help us make decision. PatrickJMT explains how to calculate probability in an "either A or not A" scenario. The probability of A plus the probability of not A is equal to one. Therefore, the probability of A is equal to one minus the probability of not A ; P(A)= 1 - P(not A). The probability of a major earthquake in San Francisco over a period of time is used as an example. The probablity of an earthquake of a magnitude of 7.5 or greater in San Francisc...

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 NPV & IRR with a TI BAII Plus calculator

The video shows you how to calculate capital budgeting with a Texas Instruments BA2+ financial calculator. Capital budgeting will help you determine cash flows for given investments for a certain number of years in the future, thus helping you determine if the investment is worthwhile. The buttons you will use are the CF (cashflows) button, the NPV (net present value) button, and the IRR (internal rate of return) button. The video uses the example of a $10,000 investment that will return $5,0...

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 a handicap in golf

This video presentation details the process of calculating a handicap in golf, in this presentation the handicap will be calculated on the USGA handicap system which is the official handicap system to be used in the United States. On each score card, there is a designation for the handicap and slope, these numbers do not vary frequently between sixty-eight and seventy-four, and one-fifteen, and one-thirty, respectively. The 'Slope' is a new calibration that is used to help make a handicap fai...

How To: Cook the perfect prime rib

Cook the perfect prime rib by mathematically calculating a precise cooking and resting time. In this video tutorial, a bone-in prime rib is seasoned with the secret ingredient parve and is cooked to a medium-rare pink with the perfect rare moisture.

How To: Place links on a page in the right place to generate better PageRank

Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...

How To: Perform the mind blowing trick "card text"

First of all you need to a set up deck. You need to learn about two things. First you need to learn about calculating the numerical value of the card and also work out the suit the card. First take out a card and lay it face up. This is 4 of clubs. The rule here is that next card shall be 3 more in numerical value because this deck is a set up. So pick the next card that is 7(4+3) of hearts then 10 of spade (10+3) and then king of diamonds (10+3). Now remember the phrase "chsd", c for club, h...

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Create a formula timer in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.

Prev Page