Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.
Gardening can be relaxing in the summertime. The sun is shining, the flowers smell delicious and it can be great exercise..it would be absolutely perfect if it weren't for all those pesky bugs.
This video basically shows you a set of minor hand techniques (cues) that might help you when you are dancing salsa.
Don't know how to seed a pomegranate the easy way? Make a mess every time? It's okay, you're one of many—you're not alone. In this how-to from Food Wishes, learn a secret trick that's well known in the restaurant biz to get those seeds out easily.
PixelPerfect teaches you everything you need to know about being a digital artist. Learn tips and tricks to turn your regular vacation photos into works of art worthy of museums.
MatttChapman shows you how to build a guerilla-style camera dolly to add to your filmmaking bag of tricks. This guerilla dolly is so simple, made with a rain gutter and cover from a local hardware store. This is ingenuity at its best. Don't spend a ton of money for a dolly to simply pan, build this rain gutter dolly!
Freelance web developer and Internet marketer David Frosdick offers some tips and tricks in this video tutorial on how to get the best Camtasia settings for YouTube widescreen.
Get all of the makeup and hair tutorials you need from Pursebuzz.com. In this video tutorial, you'll learn how to eliminate panty lines. This is the perfect tip for shedding those panty lines. Those panties don't have to be seen through your clothes. See the trick!
Katinthehat4883 from YouTube shows you how to achieve great filled-in eyebrows using Brow Express by Anastasia $35 at Sephora. If it's perfect eyebrows you want, then this makeup video tutorial on how to fill in your eyebrows with Anastasia's Brow Express will do the trick.
Without Tools, Crack a Combination lock! Meant to break into your own lock in case you forgot the combination. Learn how to reduce possible combinations from 64,000 to 100. This lock cracking trick will help you next time you need to pick a combination lock.
Learn how to cheat like hell to produce realistic sounding piano flourishes, amazing rolls, and perfectly harmonious music in FL Studio. This tutorial uses examples from other FL tutorials on this site so you may have to watch more than just one. Check out this advanced music theory tutorial and get some great cheating tricks to help your music production in FL Studo.
Train your pet rat to shoot hoops! This rat training instructional video demonstrates the steps you need to teach your pet rat this fun trick. All you need is a "basketball hoop", rat treats, a ping pong ball and an inquisitive pet rat.
Make your harmonica talk. In this instructional video, you'll learn how to perform what can only be described as "that vocal harp thing" on your harmonica. The trick, as you'll learn, requires octave playing, using the second and fifth blow holes simultaneously while blocking the third and fourth.
In this how-to We learn how to make a molecular whiskey cola cocktail using liquid nitrogen. This can be a very cool party trick, or even just something to impress your friends with.
CaptainDisillusion challenges the urban legend of a gas station ghost that's talked about by newcasts across the country. Find out the tricks or illusions of low quality video footage.
Learn the savvy trick in this how-to video for closing chip bags. It's as simple as it sounds and will save you from wasting money on those chip clips that get lost anyway. Even better, your chips will stay fresh. Check out this quick instructional video and learn how to properly seal a bag of chips.
You can learn a magic trick that will make an empty can full again, just watch this how-to video. You need a can of soda, piece of paper, black texta, scissors, and a marker. You trim the paper to best fit the can's mouth, insert a hole behind the can's mouth, and squeeze about 2/3 of the can out. Check out this video magic tutorial and learn how to create the illusion of filling up an empty can.
No AC? Before you die of heatstroke, try these cool tricks. Use spicy food and wrist bands.
See this amazing math trick to help you multiply the number nine. It so easy, you won't believe it! Who needs multiplication tables anyway?
This video will show you how to always win in a very simple bar game called Nim. Trick your friends into betting on it then always getting a free drink or a couple of bucks! (Please drink responsibly.)
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.
Learn how to Beat Super Mario Bros. on the NES in 5 minutes 10 seconds. The trick is to find all the right warp rooms to skip past most of the levels.
We know that April Fool's has just passed, but that doesn't mean you can't still prank your friends and family in the most satisfying way possible (satisfying for you, of course, because it'll suck for them).
We're experiencing a Lipstick Renaissance. Rich, defined lips ruled the fall runways, cementing the return to old school glamour and the ladylike lipstick that comes with it. Here, Sephora Pro Beauty Team member Vanessa Dunn helps you sort through the new crop of creamies. Learn a trick for finding your undertone, instantly!
Eve takes us step by step through a full make-up application and is specific about the brushes and techniques that she uses.
In 2 minutes you can make a stove from household materials that you probably already have. Learn this great survival trick by watching this how-to video. You will need rubbing alcohol, a soda can, a sharp knife, and a food tin. Watch this video tutorial and learn how to build a survival stove out of an aluminum can.
Create your own head turning magic by creating the easy to make paper toy in this how-to video. Make two paper dunce caps, cut out face holes, and stick the prop onto an assistant for this trick. Spinning the paper hats around creates a creepy illusion that the assistant's head is spinning around on their neck like magic. Check out this instructional video and learn how to perform this head-turning illusion.
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!
Effect: Your friend beats his head on the bar repeatedly, to everyone's delight. All you need is a quarter or other coin and some good acting skills. Cool prank.
Levitating has always been one of the most difficult and expensive magic tricks, usually involving a harness and rig. Thanks to the Balducci technique, it’s now one of the easiest and cheapest.
Learn easily how to make this amazing and funny prank. Non-toxic, but can stain your skin for about 3-4 days. It's time to take your revenge!! Use this as inspiration for one of your April Fools Day pranks!
A Ford Puma is used to instruct some cool moves. Learn the handbrake turn, 90 degree turn, reverse flip, Scandinavian flick with liftoff oversteer (similar to power slides). It's like drifting.
The guys at Indy Mogul show you how to make a trick barber's chair like Johnny Depp's, as seen in the Tim Burton movie Sweeney Todd.
Interested in getting 1.5-volt button cell batteries for pennies on the dollar? Kip Kay, of Make Magazine, is here to show you how. The trick is to buy Energizer A23s, each of which contains 8 1.5-volt button cells. For detailed instructions on this straightforward money-saving hack, take a look!
This is a cool video tutorial teaching you different ways for how to spin a pencil/pen on your fingers. By using your thumb, index finger, and middle finger, while keeping in mind the weight balance, you will be able to learn how to do this trick with the easy steps that he provides. And with these techniques you can even twirl a banana or a screwdriver. Watch this video tutorial and learn how to spin a pencil.
One of the most soothing card trick videos we've seen yet, follow along and try your skill at Tenkai palming. Learn how to use the palm to vanish cards (or credit cards, when you get good enough). You might have to crank the volume all the way up on your speakers, but it's worth it.
Ever wonder how a tree gets water all the way up to the top? Ever thought about how a stream of air can hold a ping pong ball in place? This simple how-to shows you a few experiments to try with air and water.
In this video from ViralVideoJunkies we learn the magic trick where you pass a coin through a handkerchief. Take the coin and place it underneath the scarf. Hold it by the coin and pinch it so you have a bit of material in between the coin and your other finger. When you make the move to put the coin back in the scarf you are actually not just covering the quarter back up, but you are taking both sides of the scarf and flipping it. Now you have a firm grip with your thumb and finger on the co...
How cool would it be if you could become invisible? While this video won't show you quite how to do that, it will teach you how to make a coin disappear into thin air. Which, by our standards, is still pretty awesome.
In this tutorial we learn four tricks to make your eyes look bigger. The first tip is to layer on a shimmery light shadow to the eyes and then add on a darker color to the crease of the eye. Curl the lashes and then apply mascara to the eyes after clamping and working up the eye. Next, take some false lashes and apply these to the outer edge of the eye. The lashes will give you a thick and luxurious look. Later when you go to take these off you just need to use simple eye makeup remover. Any ...
