In this video tutorial, viewers learn how to find the area of a rectangle. The formula for finding the area of a rectangle is: A= b x h. The base is the horizontal bottom lie of the rectangle and the height is the vertical straight line of the rectangle. Whenever working with area, users must square the unit of measurement. To find the area of a square, multiple the side of the square twice (square it). This video will benefit those student viewers who are struggling with math, and are in nee...
It's obviously important to look better than everyone else on your wedding day (sorry, but you know it's true), but even more vital to look great in wedding photos since you'll be looking back at them 10, 20 years down the road and you want to know you looked your best on your special day!
"Baywatch" babe Pamela Anderson is famous for big, sultry smokey eyes and plush, nude lips. In this tutorial you'll learn how to achieve an utterly gorgeous purple-based smokey eye that's perfect for a night out club hopping with your posse. It's a beautiful makeup look that'll get you noticed even if, like Pamela Anderson, you live in a town full of A-listers.
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 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
If you’re into final fantasy and wish to look like the character Lightning, this video will teach you how to style your hair to transform into the character. First, spray your hair with a root lifting formula and blow dry to add volume and texture. Next, separate the top portion of your hair and tie it into place. Then using a straightening iron, crimp and curl the bottom half of your hair to create nice, wavy hair. Let down the top portion of your hair. Again using a straightening iron, fl...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.
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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
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 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.
Disney star, Selena Gomez, always has stunning makeup and hair. Steal her look with help from this makeup tutorial hosted by Beechbum06. This look uses browns & silvers and is applied with all affordable makeup products! Wear this exact look with the following:
Box Tops are a great way to help your kids school generate more money. A formula can could help you keep your box tops neat and Tidy. Take paper off of can then tape paper to the side of the can. Then you can decorate as you please to match the decor of the room your putting it in. Scrap book paper works as a great paper. You can also use stickers to complete this. For the lid you can spray paint them but first you should cut a hole in the lid so the box tops can slide right in. You can make ...
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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
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.
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 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
This video describes how to find the area of a circle given a radius of 4cm. The video begins by describing the formulas needed to find the area of the circle. The narrator cautions the viewer on a few common mistakes that people frequently make while using these formulas, such as not properly squaring the radius of the circle. The solution to the formula for a 4cm radius is 50.24 cm^2. The video then demonstrates that this value makes sense by overlaying a grid onto the circle and visually s...
In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square and you wish to simplify it, the key is to write it as the product of a perfect square or another number. This video is very descriptive and clearly explains the functions of the formula. This video will benefit those v...
In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...
The instructor in this video uses humor to teach people math, which is not a favorite subject for many. The video goes on to teach the students in the video different ways to cut the conic sections into different shapes. The teacher then focuses on parabolas and defines the formulas. The formula is y = x^2. The rest of the video dissects the equation breaking it down into much more meaningful statements so that the average human being who is not very good at math can understand the equation. ...
In this video, it is shown how to calculate the area of a circle where the diameter is given. The formula for calculating the area of a circle is pi multiplied by square of radius. Radius is actually half of the diameter. In this video, the diameter is given as 10.6 meters. Hence, the radius will be half of 10.6 which is equal to 5.3 meters. Now, to find the area we shall multiply pi with the square of 5.3. Square of 5.3 is 28.09. If we multiply 28.09 with pi we shall get the area of the circ...
In this video the instructor shows how to solve a 3 x 3 linear system using the Cramer's rule. In this kind of problem you are given three equations in three variables x, y, z and you need to solve for the values of these equations. You can solve this using the Cramer rule which says that the value of x is Dx/D, where Dx and D are two different determinate. Now you have to figure out the determinate to get the value of variable x. The determinate D is called the foundation determinate and is ...
This video shows how to find areas between curves. The basic idea is that we find the space trapped between two curves on a graph. The formula for finding this is top curve, subtract bottom curve and then integrate. The presenter shows a parabola that goes through the origin. Then he draws a line that runs through the origin. We try to find the area trapped between the two. You take your smallest x co-ordinate to the largest x co-ordinate, you take the curve on top (2x) and subtract the curve...
In this video Ken teaches you about the Pythagorean Theorem. The Pythagorean Theorem is used to find the missing length of a side of a right triangle. By watching this video, you will learn how to find any the length of any side by using a simple mathematical formula. Ken walks you through various examples changing the dimensions of the triangle you are solving as well as changing the side you are solving. Ken even includes a real world application to further your understanding of the Pythago...
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
In this video the instructor shows how to write a linear equation. If you need to find the equation of a line that passes through the two given points then you need to find the linear equation of that line. The first step is to find the slope of the line that passes through these points. The slope can be calculated by finding the ratio of the difference of y coordinates to the difference of the x coordinates i.e. the change in y up on the change in x. Now substitute the value of slope and any...
In this video the instructor teaches about direct and inverse variation. Two variables x and y are said to be in direct variation with each other if you can write them in the form y = K * x. The value of y varies directly corresponding to the value of x. Y is said to be directly proportional to x. If you have a sample value of x and y, you can substitute the values in the above equation to compute the value of the constant K. Using this formula you can always find the value of one variable x ...
This videos explains how one can easily find the parallel line to a given mathematical equation. He starts by explaining what it means for two lines to be parallel mathematically speaking. Defining two lines, then comparing the slope of both lines you can mathematically determine that they are in fact parallel. He then moves to common math problems found on tests where you are given a point and a linear equation. He then forms a T-table with one column being line one and line two and illustra...
This video shows us the method to find the percent increase or decrease in a quantity. This can be done in 30 seconds. The formula states that the percentage increase or decrease is equal to the product of the ratio of amount (increase or decrease) and the original amount and 100. This is explained by two examples. In the first example the amount of increase of the price of groceries is found by taking the difference of the new price and the old price. This is divided by the original price an...
In this video, the instructor shows how to find the equation of a circle given its center point and a tangent line to it. To do this, take a graph and plot the given point and the tangent on that graph. Now, from the center of the circle, measure the perpendicular distance to the tangent line. This gives us the radius of the circle. Using the center point and the radius, you can find the equation of the circle using the general circle formula (x-h)*(x-h) + (y-k)*(y-k) = r*r, where (h,k) is th...
This is video on mathematics. It specifically deals with geometry. The video describes how to determine where the y-intersects are when a point and distance to the y-intersect are given. The author starts out by giving an example ordered pair. The speaker next shows an example of how to solve such a problem. The speaker uses the distance formula along with the given distance and x-coordinate in order to solve for the y-intersect values in question. Most of the video entails solving this example.
