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...
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 ...
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...
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.
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.
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 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 tutorial video will teach you to make Shabu-Shabu. Shabu-Shabu is a Japanese beef hot pot served with porridge.
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.
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).
If you prefer glow sticks over candles during a power outage, then this how-to is for you! Although glow sticks are used as temporary light sources, there are other applications for them. Divers use them for night diving, fisherman use them to catch swordfish, and the military uses them for light markers, along with infrared versions used in conjunction with night vision devices. But with all these handy uses for glow sticks, the most popular is — recreational use, like dancing at raves, some...
This video shows you how to make a single serving of Chex Mix for a snack in the microwave. Of course, if you're making snacks for a party, just increase the quantities of all the ingredients. Delicious, quick and easy!
The Numeric Stepper component in Adobe Flash CS 4 is a small but very useful feature which allows users to select any number in a particular quantity - such as giving a birthday or indicating how many of a particular product they want to buy. Watch this tutorial to learn how you can use the Numeric Stepper component for your own projects.
A numeric stepper component is one which you can add to your website to allow users to select numbers or from a list of avaiable items - useful, for instance, if you wanted a webstore which allowed for a quantity function. This Adobe Flash CS3 tutorial shows you how to create and use a numeric stepper component.
This is a video tutorial on how to assemble K'Nex quad or ATV vehicle. He gives you the list of different Knex parts you need with quantities. This is a simple assembly, with a time lapse of how to put each piece together.
This instructional knitting video demonstrates how to use a yarn ball winder and umbrella swift. Use the umbrella swift to wind balls of yarn onto a ball winder. Never let a quantity of yarn go to waste from being tangled up. If you are a devout knitter, you will want to have one of these around.
Watch this instructional drawing video to begin drawing forms using contrast. Contrast is only the concept of things being different from each other. Creating an interesting composition is all about drawing creating a happy imbalance of. Play with this drawing concept using color, shadow, and quantity of objects.
This thick and tasty tomato-based barbecue sauce recipe for dippin' and moppin' goes real well with most anything barbecued. Start with this basic BBQ sauce recipe and then adjust the ingredients and quantities to make it your own special sauce! It's real easy to do as demonstrated in this how to video by the BBQ Pit Boys.
Here is a basic BBQ sauce that's quick and easy to make, and goes real well with most kinds of BBQ. Start with this recipe and then make it your own "secret sauce" by adjusting the ingredients and quantities. That's what BBQ is all about. Watch this how to video and let the BBQ Pit boys show you how to make this homemade barbecue sauce.
This basic BBQ dry rub recipe for barbecue ribs is quick and simple to make. Use this BBQ Pit Boys recipe, and then adjust the spices and quantities to make it your own special BBQ Rib Rub! That's what Barbecue is all about.
Singing and playing together helps open and resonate the sound, place the embouchure, and control the air quantity. It can be used as a warm up or extended technique
In this Arts & Crafts video tutorial you will learn how to use ICE Resin to make resin jewelry. ICE resin should be used in a well ventilated room and be sure to follow manufacturer's recommendations. The kit comes with mixing cups and sticks. Additionally you will need a paint brush, scissors, sponge and needles. Once you mix the resin and the hardener, you got to use it within 30 minutes. Curing time is 24 hours at 72 degrees Fahrenheit, which is the room temperature. You can make it faster...
This video tutorial is in the Fine Art category where you will learn how to make a hat out of felt. You will need glue, silver wrap, a plastic bowl, pins, felt and a mold of the head. Take a red felt and cut out a big square piece, a small triangular piece and four curved shapes as shown in the video. Now cut four curved strips from each of pink, light green and dark green felt. Pour glue in the plastic bowl, add equal quantity of water and mix well. Take the square piece of felt and dip it i...
Chef Billy Parisi from Fix My Recipe responds to a request sent by one of his viewers, to "fix" a barbecue chicken skewers meal.
This video archery tutorial offers some tips for how to maximize the results of even small amounts of practice time. Quality not quantity is as golden for archery practice as any other part of life. It's important to remember to practice in the same kind of clothing the archery hunting would be occurring in. Watch this instructional video and learn how to make the most of limited archery practice.
What's an LED Throwie? Watch this video and find out how to light up your neighborhood using colorful LED's and magnets! Yet another great idea for creating neighborhood art from Graffiti Research Lab.
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...
