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.
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...
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 ...
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.
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...
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...
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...
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 illustrates how to light a match while bartending with one hand. Take a pack of match sticks. Slide the paper over the match pointer with your thumb. Fold a match stick backwards to the pack and fold it once at the edge of the pack. A match strip is printed over the edge in pack of match sticks. Just let the match stick rub the match strip using your thumb and the match stick is lighted up. Just slide over the table. Benefit after watching this video: 1. To light a match while bart...
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.
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...
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).
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
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...
How to make your own water proof matches
Your mom probably told you not to play with matches, but now that you're a little older it's time to start breaking that rule. Watch this video to learn how to play a fun trick on / mind game with people at a bar or other social occasion using matches.
Chef Billy Parisi from Fix My Recipe responds to a request sent by one of his viewers, to "fix" a barbecue chicken skewers meal.
Check out this video tutorial on how to get many of the multiplayer achievements in Unreal Tournament III.
It's Magic 101. Can you mimic the master? This magic how-to video will show you the trick. Effect: Taking two matches from different matchbooks (one black, one brown), you cause them to visibly switch places...right under their eyes. It's demonic; it's the Quicksilver Matches.
This style of table is often only seen at restaurants, but you can easily build a set for your own home - a square, high-set pub table with four matching stools. A stylish addition to any kitchen or dining room.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.
This video shows you how to do the match back trick with wooden matches. The Street Magician shows you how to do this trick.
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.