Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Attention advanced balloon artists! Learn how to make a one balloon horse that involves a difficult balloon shape and a tricky air bubble situation. Learn how to make this impressive balloon animal with help from one ballooning expert. Your Balloon Man, Mr. Fudge, is full of balloon tricks! Be sure to find other balloon videos on WonderHowTo from Mr. Fudge teaching everything from animals to planes! In a few twists and a few ties, you'll be an expert balloon artist in no time!
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 326th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a hyperlink from one sheet to another in the same workbook.
This video from the website What to Cook When shows us how to crack open the crab legs and get the meat out of them. Firstly starting with the cluster of legs, simply grab one of the legs and break it off of the cluster. Now simply grab the leg and starting with the joint, break it into half and pull it apart. Then take the middle section which you just broke and put your fingers right in the middle of that section, crack that one leg and then flip it over and crack it the other way. And once...
In this tutorial, we learn how to prevent a hangover while out drinking. We all know that water is the best way to hydrate and we should drink a lot of it after a night of partying. But, a great way to prevent a hangover WHILE you're out partying, is to drink water while you are at the bar. This doesn't mean mixing water in your drink, it means drinking a glass of water after each cocktail you have. Not only will this prevent a hangover the next morning, it will hydrate you and make you feel ...
This video tutorial is in the beauty and style category and it is going to show you how to tie your shoe laces with only one hand. First you need to tighten up the laces and then you will have to tie the laces with the overhand knot. Take the lace on the side of the hand and hold it between your thumb and the forefinger. The distance you go is equal to the size of the hand. Pull the lace and grab it with the first joint of the little finger. Now you got to free your thumb and the forefinger g...
If you want to accurately represent objects in three-dimensional space, then it's vital that you have a good grasp of perspective. This three-part, three-dee drawing lesson presents and overview of drawing with single-point (or one-point) perspective.
It is simple to make a booklet from one piece of paper. Take one A4 size paper then fold it to equally, then unfold it and you can fold it to right of edge and left of edges both sides are equal. Then unfold you can see like zigzag and cut it to middle point of the paper and fold it to use booklet. It is comfortable and easy to use it.
In the GetConnected TV show BlackBerry expert Darci Larocque from Swirl Solutions gives an easy tip on how to call voicemail directly with one (1) key. This option can be seen in other cell phones also, but in a BlackBerry you can set a password for this. Hold the green button or call log , go to menu - Voice Mail, set your password, click escape and save. Now when you dial No.1 or hold it down you go directly to your voicemail.
DreamWelder Productions presents this video tutorial from their show Info Tech, hosted by Jay A. Kelley. They take an exciting new look into new equipment for the film and television industry, showing you the best gear for your movies and shows.
Learn how to master the Rubik's Cube puzzle... watch this video tutorial to see how to solve the Rubik's Cube in under one minute. You don't have to be a genius to accomplish solving the 3x3 Classic Rubiks Cube.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Watch this video tutorial to learn how to perform a "one face up" false cut card flourish. A card flourish is something a magician uses, a technique for handling playing cards, mostly during magic card tricks. Is it magic though? No, just a little sleight of hand a fancy showmanship. See how to do the OFU (one face up) false cut.
Basic 1pt and 2pt perspective drawing. This is a CAD video, but it is designed to teach you how to hand draw everything. The draw three dimensions, off the paper and in the Z plane, one must have a very good idea of how the setting appears.
This video tutorial shows you how to do the one drop project yo-yo trick. The yo-yo is one of the oldest living toys around, and the modern yo-yo of today was born is Santa Barbara, California. There's a gazillion yoyo tricks that you can put in your hobby arsenal, so pay attention and learn from the best. Learn the one drop project yo-yo trick from Yuuki Spencer.
What to be a magician, but only when it comes to card tricks? Just Flourish will help you improve your magic skills with that deck of cards. This video specifically covers how to perform the one-handed revolution cut card trick. This basic "magic revealed" tutorial into the land of card tricks will show you just how to do the revolution cut.
Learn how to turn a t-shirt into a sexy one piece swimsuit. This swimwear project is cheap and easy. The sexy GiannyL demonstrates this DIY closet hack that's simple and cheap. All you need is a t-shirt, pins and a sewing machine. Cut along the pattern Gianny L has demonstrated and sew. Voila! You have a dead sexy one piece swim suit.
How to use a can opener with one hand or without a prosthesis. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. This trick is important to ensure healthy living and daily tasks like opening food in the kitchen. Live without limits!
Everybody had a yo-yo at one point in their life; some when they were just little children, some when they were bored teenagers, some when they found the kid inside of them they never knew of, and even some when they felt retirement was just not very fun. It just goes to show that the yo-yo is not going anywhere anytime soon. Who could ever believe that a toy consisting of two equal disks made of plastic, maybe even wood or metal, with an axle and string could be so damn pleasing, so much dar...
Watch this instructional video to accomplish the knitting technique: M1R / M1L: Make One Right / Left. A make one, abbreviated M1 in knitting patterns, is an increase stitch. In some instances the slant of the increase does not matter, but, when it does, it's helpful to know how to make one left-slanting and how to make one right-slanting. A make one right slanting is abbreviated M1R:
If you can rotate a hula hoop around your knees, with a little practice and balance, you can spin it around one leg. Safire, expert hula hoop dancer, walks through the simple steps of doing this stunt, breaking down each movement to exact body positions and also thoroughly explaining any of the hula hoop choreography terminology she uses. Watch this video hula hoop tutorial and learn how to perform a one-legged hula hoop move.
With iPhoto, you can add effects to your picture quickly and easily.
Check out this video for a step by step process on how to use just one piece of paper to make a book with 16 pages. (Do it the origami way!) You can even make it into a flip book later.
Gary Rosenzweig from MacMost looks at how you can sync your iPod or iPhone to multiple computers using manual settings.
How to avoid that awkward, annoying, traditional scenario due to a one night stand. Play your cards right, and s/he could be out the door in no time, 100% painless. Watch this how to video and learn how easy it is to get rid of an unwanted one night stand.
Turn a 'toy' radar gun into the real thing! Cops don't even have one like this! While this is a completely new and different design, the inspiration for this video is from an article by Ken Delahoussaye in MAKE Magazine. Just watch this video tutorial on how to hack a toy radar gun into a real one.
Kip "Kipkay" Kedersha is known for his intriguing and clever how-to and prank videos, even when he teams up with MAKE Magazine. He will show you how to tweak, hack, mod, and bend any technology to your hacking needs. No electronic device, gadget, or household item can stand the test of Kipkay's hacks and mods.
Looking to create the look of a blockbuster Sci-Fi epic, for the price of a student film? This Indy Mogul Backyard FX video will show you how to build incredible looking science fiction armor out of foam for about eighty dollars. Be sure to follow these instructions carefully and be patient.
You can't go scrub-a-dub in the tub - at least not comfortably so - if your shower faucet is leaking, or if your current tub valve is stuck and not letting any shower water come through. If your shower is broken beyond repair then your best plan of action is to take the whole thing out and reinstall your shower stall. We know this big - and potentially disasterous - procedure has been parodied many a time on popular TV sitcoms, but it's actually realizable if you're careful and follow the ste...
This is a video tutorial in the Arts & Crafts category where you are going to learn how to tie a Bowline knot with one hand. Doing this is really simple and easy and doesn't take any time at all. Hang a line from any support. Take the lower end, that is the running end in one hand and pass it around the standing end. Then take it out through the loop and pass the running end around the standing end and pull it out through the loop. Tighten the knot and it's done. It's really that simple and e...
In this tutorial, we learn how to paint a cabbage rose using the one stroke technique. Start out by mixing together white and red with your paint brush. After this, add yellow to the tip of the brush and paint it onto the paper using your hand to move the brush gently up and down. Do this in a circle to make several petals into one single flower. Then, paint on petals around the inside petals to create a larger flower. Add in additional color to the center of the flower to make it pop out mor...
Looking for a new gift idea for Valentines Day, your anniversary, or just a gift for that special someone? Well, try this great fancy balloon heart! All you will need is one of those straight balloons and a little time and patience! In this video you will get a full tutorial on how to make your own!
In this video we learn how to play "One" by Metallica on electric guitar. Start out with the beginning of the song. You will take the first finger on the second fret of the A string and your ring finger on the fourth fret of the E string. Play back and forth going between the different strings and then take your ring finger off and open up the string. As you continue to play you will begin to form the song. Go from the beginning to the middle and the end. Make sure to add in the chorus and ad...
In this tutorial, you'll learn how to move a hosted domain from one hosting service to another. It's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
Hack your remote control so you only need one battery to run it! All you need is one paper clip to let you complete the circuit between the battery and the hardware on your remote control. It'll run at a lower voltage, so you'll have to be closer to the TV, but it will still work!
Chevy Silverados and Tahoes from the year 2000 onwards have used a one-piece design for the parking brake pad shoe, and it is not a very good piece. It breaks all the time, but this video will show you how to replace it without removing the axle.
First you need to do is press the t button in your keyboard and add a new mono track. Choose mono in format and click OK.
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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
