Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 49th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for markup on cost in MS Excel.
This video demonstrates how to calculate shipping costs with UPS. UPS provides an easy-to-use online calculator to help customers accurately estimate shipping costs. By following a few simple steps, this tool can help customers control their shipping costs and avoid confusion during the billing process.
With gas prices soaring in the US and around the globe, the cost to drive to a vacation destination is becoming a much larger expense item in the overall travel budget. Although it's easy to see that gas prices have risen dramatically in the past several months, it's not nearly as easy to figured out how it will impact that upcoming car trip, so here are the items you need to take into consideration to calculate how much it will cost to drive to a destination.
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 325th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that takes a fixed daily cost and calculates the monthly total for months with different number of days.
Not sure exactly how to calculate a twenty percent tip for your waitress? Or how about how to figure out how much less your cost will be with that thirty percent off tag? Use these steps to calculate percentage, without a calculator.
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 285th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a sales price given cost and markup on said price.
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
The 'net present value' is the difference between the initial cost outlay of making a product or an investment, and the present value of expected cash flow. Using the equation given in this video, you can start with the initial estimation and determine the net present value for your endeavor.
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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.
Electrical engineering is a math-heavy business, and you're certainly not alone if you're studying it and having trouble with the math. Watch this video for a very cogent explanation of a simplified method for calculating resistor dividers in a circuit.
Regression functions are a vital part of statistical analysis of populations, and if you're involved in business, science, or nearly any academic field you should understand how it works. This series of videos will show you how standard regression functions, ANOVA, ordinary least squares, and everything else you need to know.
Struggling to find and calculate the correct consumer surplus for an econ class or in any other situation? Take a look at this guide that will walk you through the different equations and graphs necesssary to understand and calculate consumer surplus.
Need help figuring out how to calculate surface integrals in calculus? Learn how. 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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to fin...
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.
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. With this four-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the optimal angle at which to launch a projectile.
Do you need help in math? Unable to calculate the surface area of a rectangular prism? This video helps you understand how to calculate the surface area of a rectangular prism. By showing each step required to calculate the surface area of a prism and a detailed explanation of each step, anyone will be able to learn how to successfully calculate the surface area of a rectangular prism. By the end of the video, you can also calculate the surface area of a rectangular prism.
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.
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...
Check out this science-filled two-part video tutorial on blood pressure regulation in humans. This educational video will show you the MABP (mean arterial blood pressure), which is the overall blood pressure in your body, the TPR (total peripheral resistance), and the CO (cardiac output). You won't just learn about the blood pressure, you'll see how to calculate the MABP. You'll be fascinated, whether you're a physiologist, biologist, scientist, medical student, or just an human anatomy nut.
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...
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.
You just found out you are pregnant and you are anxious to calculate your due date. Learn how to calculate your due date even before going to see your doctor by watching this maternity how-to video. Keep in mind that most pregnancies last about forty weeks.
Looking for a guide on how to figure out the slope of a line in basic algebra? 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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calcul...
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 study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate a confidence interval in basic statistics.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the value of angles formed between transversals and parallel lines in basic geometry.
Could you use a little help figuring out how to find percentage composition? Watch 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). With this free math tutorial, you'll learn how to calculate percentage composition by formula.
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...
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 see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
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.
This video both shows the viewer how to calculate the volume and surface area of a cylinder. It also explains what these different numbers mean. The volume is the amount of ‘matter’ that the cylinder can hold. The surface area is literally the area of the cylinders curved face and the two end circles.
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...
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!
This video begins with teaching of percentage lesson. He is also teaching conversion of percentage to decimal and vise verse. This teaching is using advanced technology note pad when he goes on writing on pad that will display on screen. He is telling that percent 35% in decimal it is .35 and if decimal 2 it is 20% in percent. And he was teaching how to convert fraction to percent by taking one example 7/8 , to convert this first we have to divide 7 by 8 then we get answer .875 then to conver...
This academic tutoring video, made by BrainKindle, defines acceleration in simple to understand terms and shows how to measure acceleration. He shows how a plain cardboard box, pencil and string are used to make a simple pendulum, which moves as the car accelerates. Using data from the arc of the pendulum, he shows how to calculate acceleration. This is an easy method to use if you do not have an iPhone with an application to measure acceleration. A great trick for a budding scientist or phys...
In this video the instructor shows how to calculate the area of a circle using squares. She starts with the formula of the circumference which she says is circumference C = Pi * D, where D is the diameter of the circle. Now she says that you can turn the shape of circle into a square and compute the area of the square there by calculating the area of the original circle. She shows how to do this by cutting up the square into sectors and arranging them in the form of a rough square and calcula...
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
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 calculate the debt ratio, debt to equity ratio, equity multiplier ratio and times interest earned ratio.
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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
Calculate the angles formed between parallel lines and a transversal. This free video geometry lesson will show you how. 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).
