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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
In this video tutorial, viewers learn how to make a tea bag fly with a home experiment. Viewers learn how to make a tea bag fly using convection. The materials required for this experiment are: tea bags, matches, tin foil and scissors. Begin by cutting the top of the tea bag and open it. Empty out the tea. The tea bag should be a cylinder shape. Place the tea bag on top of a piece of tinfoil and use your matches to light the top of the tea bag. This video will benefit those viewers who enjoy ...
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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
In this tutorial, Kandee shows us how to tie a wrist bandanna. First, roll up your bandanna and lay it on your hand. Wrap it around your wrist several times and tie at the bottom of your wrist! This is not only a cute way to make a fashion statement, it can also be used for when you're doing your makeup! If you mess up, it's an easy way to clean up any messes. You can choose different colors and designs for your bandanna and match them to your different outfits. You can also wear bracelets an...
Martha Stewart has been showing viewers her way of cooking for years. In this video, see how the home and kitchen icon prepares ribs, chicken, and plenty of side dishes to make for some delicious home cooked BBQ.
This video explains how to properly fold fitted sheets. The first step is hold the sheet with the pattern, outer side closest to you and put your left hand into the first pocket and your right hand to the second pocket. Put your right hand over your left hand and flip the sheet on top of itself. Keep your hand on the top sheet and follow the edge all the way down to the third pocket. Place your hand on the underside (non-patterned part) and match it to the first two pockets, and then flip it ...
This video teaches you how to become a DJ. In this session we can learn how to keep the beat off beat by keeping the timing of the beats the same. This video shows the specific way of increasing the beats and decreasing the beats according to the tracks that are played. This tutorial also has a live sample of how a beat can be matched off and a how to maintain a constant interval between the beats. It also has some specific instructions on how to maintain a constant interval between the track...
Step by step guide to preparing a raw artichoke for cooking. Using a knife, take a washed artichoke and trim the top part and stem around 1 inch up from each side. Using a kitchen scissors, trim the leaves. Rub some lemon juice onto the leaves and stem to prevent it from turning brown. The artichoke is now ready to be cooked.
In this video Threadbanger Projects shows how Anne made her nightdress out of a pillow case to match panties up loader Clare Bear showed how to previously for Valentines Day. Materials needed are a pillowcase to match the frilly panties, elastic, ribbon, scissors, and a sewing machine. She explains how to measure elastic points using your body and shows how to attach the elastic using pins and a sewing machine. She finishes the nightdress with ribbon for the straps and a bow on the back.
In this video the author shows how to find out if a Point lies on a Line in Slope Intercept Form. He shows it by an example where he takes a point, which is an ordered pair in the form (x, y) and a line, which is an first degree equation. Now he substitutes the values of x and y in the equation and checks if both the sides of the equation match. If it matches we can conclude that the point lies on the line. By following the method given in this tutorial you can find out if a given point lies ...
Did you know you could create a battery by using a few items from around the house? Get you and your family "Hooked on Science." You need two electrodes, some wire and some lemons.
Did you know the dollar in your pocket is magnetic? The strip inside the bill is magnetically charged. Check out this demonstration from Hooked On Science to learn more about science firsthand. Bring science right to your kitchen with these creative ways to demonstrate chemistry, physics and earth science to your kids.
It's very important to clean your make-up brushes so now and then. This video shows you how. Every day- wipe makeup brushes off on clean old towel
A below elbow arm amputee demonstrates how to open a jar with his prosthetic hook. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. The prosthetic arm outfitted with a hook or hand can be body powered or myoelectric. The operation is important to ensure healthy living and daily tasks like opening jars, bottles and lids in the kitchen.
In this cooking how-to video, Dave moves into the kitchen to show you how to make sun dried tomatoes from plum tomatoes. Follow along and learn how make tomatoes that will last you all winter long. Making these sun-dried tomatoes doesn't require you to lay them out in the sun, just dry them in your oven. Before you know it you'll have tasty sun-dried tomatoes.
Good news for egg lovers: You don't need a drop of oil or butter for this preparation, which makes poaching one of the healthiest ways to put a protein powerhouse on your plate. You will need water, a skillet, white or cider vinegar, a stove top, an egg, a small bowl, a slotted spoon, and a kitchen towel. Watch this video cooking tutorial and learn how to make a poached egg.
Strops aren't just for barbers; they're a simple and easy way of gently sharpening any blade edge from the toolbox to the kitchen or bathroom. Learn how to make a leather strop at home by following along with this informative video tutorial.
Chef Tony Miller walks us through making his Seared Jumbo Sea Scallops with Black Thai Rice, Spinach, Mushrooms, in a Coconut Curry Sauce in the kitchen at Latitude 41 in downtown Columbus, Ohio.
Anyone who has been to Burning Man before can tell you that it is an extremely harsh and challenging environment physically, emotionally, and culinarily! Come hear two veteran burners/culinary team members talk about the best ways to set up your Burning Man kitchen/food plan. You'll come away with some useful recipes and vital Burning Man tips & tricks. Who knows, you may even find your playa carpool buddy!
This shows you how to make home made raviolis, how to make semolina dough in Grandma Rosa's Italian kitchen , using ricotta and an Atlas pasta maker. Music by Dean Martin.
Kipkay demonstrates how to extract the laser from a DVD burner and mount it in a small flashlight to create a handheld laser burner that can light matches and burst balloons, all in this how-to video. All you need is a 16x DVD burner, a laser housing, and a flashlight. Watch this video tutorial and learn how to modify a flashlight into a relatively strong laser.
Fromage blanc cheese is something every cook should experience in the kitchen. To consider yourself a real chef, you need to grab the cheesecloth and dip your hands in the cow's milk, because making cheese is a culinary experience like no other.
There aren't a lot of games with 3D maps where you can't break out of the levels in some way, and Black Ops is not different. This video will teach you a barrier breaker that you can use to get out of every multiplayer map in the game. Only use this in private matches unless you want it to go away!
The best part of science class for many was the awesome demonstrations and experiments teachers use to demonstrate scientific principles. This video will teach you how to capture some of that magic by performing ten awesome science party / magic tricks, like relighting a match with smoke and rolling a can around on it's rim.
Being more physically gifted than your opponent is only part of successful tennis. You have to have a keen mind well versed in the tactics of the game as well. This video will teach you some basic tactics for singles tennis that will help you win matches you would have lost otherwise.
In FIFA 11 there's a feature that's a first for the series called "Be The Goalkeeper" which allows you play an entire match as the keeper, all 90 minutes of it! You can do things such as call out plays and also defend the goal and perform various goalkeeping techniques. In this video you will get a basic overview of how to play the mode and what you can do in it.
Want to add an avian specimen to your paper menagerie? Have extra paper and time to match? This video tutorial presents a complete, step-by-step overview of how to make a crane using origami, the traditional Japanese folk art of paper folding. For more information, and to get started making your own paper birds, watch this arts-and-crafts guide.
This video shows you how to make non-toxic blue goo in your kitchen. You will need 3 eggs, two bowls, milk, coconut or vegetable oils and a spoon. First break the eggs and pour them carefully into the spoon to ensure that you can dispose the egg yellow as you will not need it. Repeat this for each of the three eggs. Then mix up the egg whites, ensuring that you do not beat the egg whites too much. Then add around four tablespoons of oil into the eggs and mix it up once more. As the egg whites...
Is it magic or is it an illusion? See for yourself when you watch this video tutorial on how to make a matchstick stand up on its head. There's an easy solution to this magic trick, easier than you think. You don't need to be a magician to perform this match standing on its head trick. Anyone can do it!
Petrilude brings you this Halloween makeup tutorial on how to create a look based on Tim Burton's movie 'The Corpse Bride'. Petrilude only did her face, but he HIGHLY suggests if you do this Halloween Corpse bride look, that all exposed skin is painted to match the face! Corpse bride is a hot look for your Halloween party.
This may/will take some practice to do but the risk makes the glory. You simply put a match in your mouth and inhale. Yes, that simple...or so you think.
Need to make a survival fire, but don't have any matches and your lighter is out of fluid. Fear not, this how-to video can help. An empty flintwheel lighter can save the day when you need a fire. Dandelion seed puffs can be the perfect tinder for your spark. Watch this video tutorial to see how it works & learn a great survival tip.
Watch Ray Mears from the BBC give you a how-to guide for making fire in the desert. (You don't even have to carry matches!) Put on your gloves to handle the fauna for cutting wood. Make a notch in the wood--good luck trying to make fire by friction!
Are you so hot you're smokin'? Well you will be if you can pull the magic trick in this how-to video off! Watch this instructional video and see just how to make your fingers smoke. This trick can be tried out any time you've got a box of matches and a water faucet handy.
Shapr is a new networking app that aims to help professionals connect more efficiently, and draws much of its format from dating-focused social networking apps. Shapr could be especially useful for those who have recently moved into their industry or location, and for those seeking employers or employees. For example, the app already has 65,000 users just in New York City alone.
The modern age of techno-dating has made an interesting landscape for social interactions when there is some modicum of romance (or lust). For those of us born before the internet evolved into the prolific monster it has become, we first met our love interests face to face. Today, however, apps like Tinder have changed the introductory stage, for better or worse.
We're all familiar with the sinking feeling that happens when you cruise through a recipe, only to arrive at an instruction that calls for a tool you don't have. Some of the best food hacks (and my personal favorites) exist to combat that problem. Why spend money on a kitchen tool—or worse, avoid a recipe altogether—when you could find a new way to achieve the same result?
Make popcorn the way your grandparents made it! This is a healthier alternative to microwave popcorn, and also lets you decide what flavors you want to add. You can make a traditional popcorn the old fashioned way using your kitchen stove.
Teacup candles are a beautiful variation on candles. You will need soy wax, clean tea cups, wicking, your preferred candle dye and essential oils, a wick pin and a method for heating and melting your candle wax (a kitchen stove is generally good enough).
In this video, we learn how to get the Megan Fox retro pinup look. First, apply a white shadow all over the lid and underneath the eyebrows. From here, brush a tan color over the top and then take a color that matches your hair color and brush it into your brows to match the color. After this, apply a gray eyeliner to the waterline on the top of the eye. Next, brush a darker gray color over this and flare the edges out on the sides. Brush this on the bottom lash line and then apply mascara on...