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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

A percent problem is one in which you are given a quantity and asked to compute the value of a percent of it. You may also be given the whole quantity and a part of it and asked to compute the percentage of the part in the whole. To do these kind of problems you need to use the rule which states that the ratio of the part to the base it equal to the ratio of the percent to hundred. That is part/base = percent/100. This comes from the definition of percentage which states that percentage is eq...

This educational math video describes the steps necessary to solve an equation involving absolute values. "Absolute value" refers to the magnitude of a quantity and is always expressed as a positive number. You can think of absolute value as the distance a number would be from zero if plotted on a number line. Positive 17 and negative 17 both have the same absolute value because both are 17 units from zero on a number line. Because of this, all absolute value problems have two answers, one wh...

In this video, the instructor shows how to identify the percentage change using proportions. When a given quantity increases or decreases by certain amount then we can calculate the percentage change in the quantity, which can be either increase or decrease based on the new value of the quantity. To solve these kind of situations you should know that the ratio of amount of increase (or decrease) of an amount to its original amount is equal to the ratio of percentage increase (or decrease) to ...

Here we look at squaring expressions that involve radicals because people tend to make some common mistakes while solving such expressions. Take 5 times the square root of y quantity squared, the answer here is not 5y. Here's the reason, square means to multiply something with itself so the square of 5 root y would be 5 root y into 5 root y. So 5 x 5 is 25 and under root y into under root y equals just y so the answer will be 25y.

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...

Percent problems, also called as proportion problems, are simple problems where you deal with percentages. Given a percentage problem you may need to identify the percentage, the part or whole quantity from it. You can use the proportion or percent equation to do this. Proportion equations says that the ratio of part to the whole is equal to the ratio of percentage to one hundred. Percent equation says that the product of the percentage in the decimal form and the whole gives you the quantity...

This video shows how to use optimization methods in calculus. Optimization means finding the maximum or minimum values of a quantity or finding when the maximum or minimum occurs.What quantities are optimized in economics?we want to minimize costs or maximize revenue.First steps in any optimization problem1.Identify the quantity to be optimized i.e., read the problem exactly what is exactly maximized or minimized.2.Identified the feasible domain. This is important because the math we can opti...

In this video the instructor shows how to use proportions to solve fractions. When you have a proportions problem with an unknown term, cross multiply and divide it to get the value of that unknown term. For example if given 7/8 = m/4, cross multiply 7/8 with 4, giving 7/2 which is the value of the unknown variable m. So if two quantities are proportionate then you can equate them as shown in the video and cross multiply to get the value of any unknown variable. Proportions are just fractions...

Elaine Lemm demonstrates how to make the traditional British dish, yorkshire pudding. This video recipe goes through all the necessary steps for preparing yorkshire pudding.

If you're not just a chemistry nerd, but also a firearms freak and explosives nut, then this home brew chemistry concoction is just what you need for some cheap homemade potassium chlorate. It's a mixture of potassium, chlorine and oxygen (KClO3) and is used for such things as gun primers, propellents, and explosives (when mixed with the appropriate fuel). And guess what? NurdRage is going to show you the steps for this makeshift potassium chlorate.

Watch this science video tutorial from Nurd Rage on how to make nitric acid. They show three ways to make nitric acid based on two different chemical approaches, both of which can be done using easily accessible materials.

The first video introduces the basic electrical quantities of charge, current, voltage, and resistance. The concept of quantities and units is explained. The units of Coulombs, Volts, Amperes, and Ohms are described. The three basic formulas of Ohm's Law (E=IR, I=E/R and R=E/I) are also introduced.

n this tutorial, we learn how to balance chemical equations. This is a straight-forward concept to balance out both sides of the equation of chemicals. To start, you will need to analyze how many atoms in each chemical you have on each side. Once you do this, you will need to find what you can multiply by on each side to make them equal to the other side. Once you do this and have equal atoms on each side, then the equation will be equal. Remember that you cant have a half of an atom, so that...

To solve a proportion for a variable you should employ cross multiplication. The basis of cross multiplication is the property which states that the product of the numerator of one fraction and the denominator of what it is set equal to is equal to the product of the remaining denominator and numerator. For example if you have x/15=21/45 you simply need to multiply x by 45 and 15 by 21 then set them equal to each other. The result of this is 45x=315. To solve this new problem for x, divide bo...

This tutorial video will teach you to make Shabu-Shabu. Shabu-Shabu is a Japanese beef hot pot served with porridge.

When eating healthy, try this strategy to feeling fuller on fewer calories. This diet and health how-to video is part of Healthy Appetite with Ellie Krieger show hosted by Ellie Krieger. Cooking healthy food can be quick, easy, but most of all, delicious. Nutritionist and author Ellie Krieger has created fast and simple healthy recipes for the real world. She'll show you how simple it can be to stay on the healthy track no matter how busy and stressful your life is. Ellie also has strategies ...

Phosphors are great for lighting up areas where fire will not burn, and also for keeping humans alive in very small quantities. Quenching phosphors allows you to use them for all sorts of cool projects, and this video will show you how to make an IR detection device with quenched phosphors and also how to measure temperature with thermally quenched phosphors.

When soap making, soap molds save you a lot of time, allowing you to produce prettily shaped bathtime goodies in less time and in greater quantities. Designs (decals) can then be added on top of these soaps for a personalized effect.

In this episode you will learn how to discuss food you like and dislike and how to express quantities in the English language.

This video tells us the method of interpreting derivatives of marginal cost and revenue. If C(x) is the cost of producing x units of a product, C(400) would be the cost to produce 400 units. Now marginal cost is the cost of producing one unit which is equal to the derivative of the cost function or C'(400) which is equal to limit of h tends to zero or lim h->0 [lim(400+h)-lim(400)]/h which is approximately equal to [lim(401)-lim(400)]/1. Similarly, if R(x) is your revenue function, marginal r...

ProfessorElvisZap teaches you about the laws of logarithms. When x is positive, meaning 0<x. x times y equals y times x. This is the commutative property. x times (y times z) equals (x times y) times z. This is the associative property. x times 1 equals x. This is the multiplicative property. x times x to the power of -1 equals 1. This is the multiplicative inverse property. You can use these properties with addition: a+b=b+a, (a+b)+c=a+(b+c), a+0=a and a+(-a)=0. A logarithm is a homomorphism...

This is a great instructional video on how to calculate the age of Universe from Hubble's constant. The speed the galaxy moves away from us is directly proportional to the distance from us. Now think of big bang theory. Hubble's constant is equal to velocity over distance. 1 over Hubble's constant is equal to distance over velocity that is equal to time. Time equals to 1over 71. If you change it into all the same units words it is one over 71000 or 3.09x 10 to the power of 22. It is 3.09x10 t...

This video loosely explains the method of how to make a blue colored slime from corn flour, blue food coloring, and a quantity of water which is undetermined. Quantities of ingredients to be added for this project vary and can be made up as the person goes along in combining the ingredients to produce the desired results. Ideally, the product should be of a slime like consistency, or can be described as 'gooey' in appearance. The resulting slime product should be easily stirred when it is sti...

In this video the instructor shows how to solve mixture problems using two variables. Usually in these kind of questions the problem statement goes like, if A costs $x for a pound and B costs $y for a pound, in what ratio should they be mixed such that one pound of the new mixture sells for $z a pound. So, in these kind of problems start with a box where you list down all the given data in the form of a table as shown in the video. Now denote the unknown quantity of A and B by two variables a...

This video describes how to store large quantities of meat for a rather long period of time. To start, take the meat and season it if you like, then place it in a plastic bag. Roll the meat down flat and get all of the air out of the plastic bag and then seal it. Take a skewer and press down to create three (or more) lines in the meat to create a grid. Finally, freeze the meat and then when you need some of it just break off as much as you would like and put the rest back in the freezer. This...

This video tutorial is in the Education category which will show you how to solve single-step inequalities using the reciprocal. Let's solve the problem "negative 5/2 X is less than equal to negative 1/5". To solve for "X", we need to get rid of "negative 5/2". To do that, we multiply both sides of the inequality by the reciprocal of 5/2 and we need to keep the negative sign also. So, we multiply both sides by "negative 2/5". Whenever we multiply a negative to both sides of an inequality, the...

This how to video shows you how to graph an inequality in slope intercept form. First, graph the line. Depending on the inequality, use a dash or solid line. Use a solid line for less than or equal to or greater than or equal to. Use a dash line for greater than or less than. If y is less than or less than or equal to, shade the bottom area of the line. If it is y is greater than or greater than or equal to, shade the top area of the line. Check your answer by substituting in any point from t...

This video shows the method to find the length of the total segment using the midpoint. Let the total line segment be PS. Let Q be the midpoint of PS. Let R be a point on the line segment QS. The first step involves the use of midpoint to find out the length of QS. We are given that QR = 1 and RS = 4.5. QS is equal to QR plus RS which is equal to 5.5. Now since Q is the midpoint of PS the total length of the segment PS is equal to twice the length of the segment QS. This is equal to 11 units....

This video teaches us to draw the graph of a piecewise function. This is shown using two examples. In the first example we have 'y' equal to 'x + 2' for x less than zero and '1 - x' for x greater than equal to zero. We plot two points on the function for x less than zero and do the same for the function with x greater than equal to zero. The graph for the first function is erased for x greater than equal to zero, and the same is done for the second function for x less than zero. Note that the...

This how-to video is about Fourth Law of Exponents. Before going to see this let's first know what the fourth law of exponent says. The fourth law of exponents says that "any value other than zero brought to an exponent of zero is equal to one".

Math can be tricky, especially when you're trying to decipher algebra. It's a love-hate thing; if you don't love math, then you hate it, and there's no in-between. But it doesn't have to be a pain to solve a few problems. It's actually quite simple once you figure it out. An algebraic equation is an equation that includes one or more variables. These equations can be solved as long as the number of variables does not exceed the number of equations.

In this video, we learn how to balance a chemical equation. First, take a look at both sides of the equation and figure out how many atoms there are for both. Once you write this out, you will have an idea of how unbalanced it is. Now that you've done this, you need to think about how you can make the equation equal. Look at the first line and then see how many you have to add to one side to make both equal to each other. Then, go to the second line and do the same. When finished, you will ha...

If you're a home cook, peeling garlic is probably not your most favorite part of preparing a meal. Sure, the first one or two bulbs are a cinch, but once you start peeling garlic in larger quantities the inevitable stickiness arises and the garlic becomes harder and harder to disrobe.

This video explains about the rule of corresponding angles. When measuring the angle between the parallel lines (i.e.) Line1 and Line2 across the straight line. The angle A and angle B are equal. The angle C and angle D are equal. The angle E and angle F are equal. Finally angle G is equal to angle F. So, the angle between the parallel lines in all the angles are equal. Hence, this is the rule of corresponding angles. This video is very useful to basic high school geometry courses. Correspond...

mathproblemgenerator.com provides a video about how to find a central angle with a given radius and a tangent. The angle at the intersection of the radius and the tangent is equal to 90 degrees. The second angle is also given in the problem. So the central angle is equal to 180 minus (90 plus the other angle given). In the video, the given angle is 54 degrees, making the equation = 180 - (90 + 54). Therefore the central angle is equal to 36.

In this video they are showing how to use proportions to solve word problems. In the first example they used 2/3 is equal to x/6. To solve for x, you begin by cross multiplying setting up and equation 3x=12. Next, divide 12 by 3 which equals 4. So x equals 4. In the next example, she has given a situation where she is making a ranch dip using a ranch powder and sour cream. She want to use 80oz of sour cream and she wants to know how much powder ranch she will need. She know that for 16oz of s...

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

In this tutorial, we learn how to find the interior and exterior angles of a triangle. I triangle has three angles and their measurement when added together will equal 180. For example, if one angle is 80 and another is 30, then start off saying the equation equals 180. Write in 80+30+X in front of the equals sign, then subtract the combined like terms from the 180. After this, you will have found the value of x, which will also be the measurement of the last angle. Make sure to write out the...

In this tutorial, we learn how to find abc, curve direction & y-intercept (quadratic eq). First, you need to find the a,b, and c of the equation. A will equal what the coefficient is in the equation, B will equal the second, and C will equal the third term. This tells us if the numbers are positive or negative, so so know if the parabola opens up or down. To graph C, you will know what the y-intercept is going to be, then find the matching units. After this, you will use B to shape the parabo...