In this video the instructor shows how to do temperature conversions using y = m*x + b. Now if Celsius is represented by the variable C and Fahrenheit is represented by the symbol F, you can replace then in the previous equation in place of the variables x and y giving you the equation C = m*F + b. Now to solve for the values of the constants m and b you need to have values of two sample temperatures in both Celsius and Fahrenheit. Take the first sample and substitute in the above equation gi...
In this video the instructor shows how to factor the GCF and difference of squares. When you are asked to factorize a number or monomial or a polynomial, the way to do is break it down into individual terms. When asked to factorize a binomial, try to pull out any common terms and factorize the simplified equation. When you are asked to factorize the difference of squares use the general formula which states that the factors of (a*a - b*b) is (a-b) * (a+b). Now substitute the given values in t...
In this video you will learn how to find a slope of a line. The man in the video shows in a practical and easy way, how to do it with formulas. First he teaches how to find slopes of lines containing both negative and positive points. He shows with formulas how to do it. He teaches how to find slopes on a flat line and demonstrates that the slope of it is equal to 0. Next, he teaches a "trick" to help students learn how to identify zero and no slope lines. In the last example, he demonstrates...
This video teaches how to convert a value in Celsius to Fahrenheit in simple steps. First take a paper and marker and keep in mind a Celsius value (e.g-32) to convert into Fahrenheit. Now use the formula to convert Celsius to Fahrenheit which is F=1.8(32)+32. Use a calculator to calculate the formula and you will get the result as 89.6 Fahrenheit. Now round it off the and your final result will be 90 degree Fahrenheit.
To find the slope of a line you must have two points and then you must plug in the two points into the slope formula. The slope formula is m= y2-y1 over x2-x1. If the slope is a fraction be sure to reduce to the lowest. Remember if a number is divided into zero it is zero, if zero is divided into the number it is undefined. A calculator can help one remember this. Horizontal lines have slopes and vertical lines do not. Drawing the lines on a graph can help you see the actual slopes and which ...
For people who are learning geometry, this video will show you how to simply find the volume of a cube. This video provides the formula as well as some basic examples in order to get you started in finding the volume. The formula for the volume of a cube is the length of one side of a square^3. This is easy to remember since you are making a cube and all sides should be equal in length. By following the simple steps and by watching this video, you should be able to easily find the volume of a...
In this video the tutor shows how to find the volume of a cylinder. He relates the cylinder to real world examples of cans etc. Now he states the formula of the volume of the cylinder as the area of the base circle multiplied by the height of the cylinder. So the formula turns out to be V = Pi * r * r * h, where r is the radius of the base circle and h is the height of the cylinder. He solves a sample example to give you the idea of the problem. This video shows you how to find out the volume...
Easily learn how to graph a straight line using rise over run also known as slope.
This tutorial the shows how to find out the measure of an exterior angle of a regular polygon. He shows the formula to find it which is 360/n, where n is the number of sides of the regular polygon. He goes on further to explain the formula by taking an 18-sided regular polygon as example and computes its exterior angle as 360/18, which is 20 degrees. If you are looking to compute the exterior angel of a regular polygon, follow the procedure given in this tutorial.
In this video the instructor shows how to find the slope of an equation which is in the form Ax + By + C = 0. He says that the formula to find the slope of a line in the above form is slope m = -A/B, where A and B are the numeric constants of the variables x and y in the given equation. He goes on and further shows how to do this with a couple of examples. He shows how to reduce any equation into the general form and how to apply the slope formula then. This video shows how to find the slope ...
For people who are learning geometry and would like to be able to find the perimeter of a rectangle, this video provides and quick and simple tutorial which provides the formula as well as a good example. The formula for finding the perimeter of a rectangle is simple the sum of all sides, or l+l+w+w, where l is the length and w is the width of the rectangle. After attaining the values of the length and width of the rectangle, you can simply plug in the values to this equation in order to find...
In this video the author show how to find the volume of a sphere. The formula for finding the volume of a sphere is 4/3 * Pi * r*r*r, where r is the radius of the sphere. Now to compute the volume of a sphere you have to note down the radius of the sphere and substitute it in the above formula along with the other substitutions. The author shows this with an example by taking a sphere of some radius and calculating its volume. To find out how to calculate the volume of a sphere watch this vid...
In this tutorial the author shows how to find the circumference of a circle. He says that the circumference of a circle can be calculated by using the formula circumference C = 2 * Pi * R, where R is the radius of the circle. He shows how to solve these kind of problems using some examples and calculating the circumference by substituting the value of radius in the formula. This video gives a good introduction on how to find the circumference of a circle.
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
In this tutorial the instructor shows how to compute the area of irregular shapes. He demonstrates this with an example showing an irregular area and says that as there is no direct formula to calculate it, you need to break up the irregular area into identifiable simple geometric figures. He goes on and breaks the irregular shape into a square, a triangle and a trapezoid. Now he computes the individual areas using a standard formula and sums them up to arrive at the final complete area of th...
This video teaches you how to use APT (Arbitrage Pricing Theory) models and formulas. This video shows two specific parts of the APT models the first being the after the fact version and the before the fact version. The before the fact version is focused on as being the most important which is used to calculate expected returns to calculate risk. It is discussed how flexible this model is and how different factors can be moved in and out of the formula and how each different factor is used. T...
This video tells you how to draft an equation in point-slope form. Consider the equation (y+4) = 2(x+7) for example. The formula for the point-slope form is (y-y1) = m(x-x1). To plot the graph you have to identify m the slope, the x intercept x1 and the y intercept y1. In this equation the slope is 2 and (x1,y1). The x intercept according to the formula is -x1 but the given value is +7 so you have to figure out what will give you +7,only -(-7) can give you +7 so the point is -7 and now the y ...
Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use.
It’s time for science. You are able to calculate the molar mass for a compound using the periodic table and the amount of compound involved. You might need to know this in your everyday life but you will definitely need this in a chemistry class.
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
This video shows us how to use a formula to find the area of a parallelogram. The formula for finding the area of parallelogram is the same as finding the area of rectangle or a square which is equal to length time’s breadth. But the parallelogram looks a bit different and the parallelogram is basically a rectangle but it is not at right angles. If you draw two altitudes then it is a rectangle with two triangles and if you cut one of the triangles and paste it next to another triangle then we...
Is it that time? Time to wean your baby or toddler from the breast? In this tutorial, learn how to button your shirt for good with the help of these steps.
Is baby ready for their first solid meal? Cereal is a nutritious first food for little ones. You Will Need
Improve your skin’s appearance by choosing the right foundation formula and shade. You Will Need:
In a recently released video, it was revealed that Formula-E's partner Roborace has developed a driverless race car that can complete laps at full racing speed.
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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.
Learn how to store, use and manipulate equations in MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started using mathematical equations and formulas in your own 2010 worksheets, watch this free video guide.
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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
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 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping fea...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!
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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
