Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
Get in shape and tone your body by getting in that pool for a swim! There's nothing better for your body than swimming and there are numerous techniques and avenues for the swimmer who wants to get in better shape. In this video, get expert tips and advice on how to get in shape with the help of swimming!
Nobody likes having bad breath. Not only does it leave you with a bad taste and scare away potential suitors, it can be a signal of more serious dental issues. This helpful video from Colgate offers up some tips you can use to cure your bad breath and improve your overall health.
Talking on the phone with a girl you like for the first time can be nerve wracking. Luckily, The Wing Girls are here to help with their honest and earnest dating & relationship advice. Learn how to get past that first phone call and get comfortable on the phone with your crush with tips & tricks given here!
Marty Schwartz leads you through the basic chords for Weezer's Sweater Song. If you are looking to learn how to play the electric guitar, he gives a simple, easy, effective lesson that anyone can follow. The tips are shown visually, making the lesson easy to comprehend. He goes on to play the chords taught during the lesson, giving an audio reference to how your playing should sound, something I found to be very helpful.
Want a quick meal, but the jar won't open? Here are some tips: try slamming it on your kitchen counter-top upside down, but not with enough pressure to break the jar. Another option is running hot water over the lid of the jar, to loosen it up. You can wear rubber gloves to give yourself a better grip, as well. This should solve any hurdles in the way of last-minute dinner preparations.
If you want to house train your puppy or dog by yourself, this video is for you! It will show you the best tips to make your puppy learn how to live in your house without creating any problems!
In the video Boiling Pasta we are taught that there is actually a recipe for how much water to boil per pasta being prepared--1 liter per 100gm--and also what amount of salt--10gm salt to 100gm pasta, after boil. Most people preparing pasta may not know that adding oil while pasta is being boiled will cause it to not adhere to sauce. The video provides many useful tips in preparing pasta, most important of all when it is done just right.
Thread and clothing designer, Kenneth D. King, give quick instruction to us on the importance of our cutting tools, more especially the serrated scissors. Here we learn what makes this particular style of scissors so efficient and necessary to our sewing work, as well as what types of materials they ought to be used on. He also gives warning that we should never use our fabric scissors on paper. Great tips for the beginning designer in us all.
This Photoshop tutorial video teaches you how to make any photo look like it was hand drawn. The image selected should have a relatively simple background, because a too detailed image will not turn out properly. Use the high pass tool and the sketch paper tool and you pretty much have your hand drawn image. Follow this video for extra tips on how to get your image to look like hand drawn perfection.
If you use these tips, you can help your nails grow faster as well as look longer.
L.A. Lakers superstar Kobe Bryant shares some tips with TIME Magazine's Sean Gregory on how he puts his best foot forward everytime he steps onto the court. Areas gone over in this video include: The proper grip & shooting form, attack the foot & sell the fake, the pull-up jumpshot, the art of the foul shot, playing to the opponent's weaknesses, getting in character, and stretching.
Attention aspiring horror movie makers! Have an interest in making fake heads to use as your gory extras? BITY Mold Supply has supplied the world with this great tutorial on how to cast a silicone head or face from Gel-10 and Polyfoam. In the later half of this video, BITY lends great tips on how to paint your finished silicone face for a realistic look.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Pamela Anderson's makeup look, easy at home. Fun celebrity style tips. This Pamela Anderson look is sexy and fun.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Angelina Jolie's makeup look, easy at home. Fun celebrity styling tips. This Angelina Jolie look is classic and stunning.
An easy makeup tutorial to look fresh, youthful and effortless. This makeup routine takes me 5 minutes tops! It's all about minimal eye makeup and giving your lips and blushing skin the attention.
In this tutorial Cy starts out a human figure from above in 3/4 view. Some tips for putting the horizon line on the page.
Here is a Harper Point Photography video on gobos for fashion photography. Nathan gives a simple but effective photo tip for creating dynamic light with a cardboard 'go-bo.' The gobo is a lighting element that texturizes lighting by blocking in strategically. Apply these directly to a light to shine texture or to light with words as a projector would.
The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch this video to learn how to open a bottle of champagne.
No coffeehouse or cappuccino maker in sight? Whip up a tasty instant version with a little ingenuity and some common ingredients. You will need:
The Pilates Stomach Series is also known as the “fabulous five,” because of the wonderful way the five movements tone the tummy. You will need a mat, floor space, and some flexibility. Pilates tip: If at any time your lower back comes off the mat, bring your legs higher as you extend. If your neck begins to hurt at any point during these exercises, simply lower it to the mat.
Hang on to your hat! This hurricane will bowl you over -- in a good way. Learn how to mix a Hurricane.
Everyone's talking about the switch to digital broadcasting, but what does it mean for you, your TV, and your old rabbit-ear antenna? You will need a digital-to-analog converter box, a pay TV service or a TV with a built-in digital tuner. Tip: Government issued coupons for digital converters are available online at dtv2009.gov.
Make sure this year’s live holiday Christmas tree is not only pretty, but safe, too. Here's how to safely put up a real, live Christmas tree. You will need:
This how to video installment explains a basic autoharp melody playing technique called "pinching". Playing melody on the autoharp is not as difficult as it may first appear. There are an awful lot of strings, but finding a melody note and playing it clearly isn't as hard as it seems. Pay attention to these harp playing tips.
You’ve decided to protest an unjust political system or organization. Make the most impact with these tips. Protest with courage, communicate with exiles and know your rights. If you disagree with a political system, concentrate your beliefs and opinion. Study famous dissidents like Ghandi and Martin Luther King.
This is a short instructional video on how to clean your NES games. The ever famous flashing blue screen and the blow to the game cartridge doesn't always work! Conventiently clean your NES games with Windex or glass cleaner and Q Tips. Swab the game cartridges and the console.
With the average woman a 36C, it can suck being the flattest girl in the room. Here’s how to make the most of what you’ve got! You will need better posture, the right clothes, the right bra, exercise and eye shadow. Small breasts age better, so don't feel bad about your flatter chest. Use these tips to enhance your natural flat chest.
Want to learn how to paint your nails flawlessly & create beautiful nail art? Watch this manicure instructional video to create this brick motif. May Paris gives helpful nail polish tips on creating this beautiful design. Be creative! Have some fun & learn how to give yourself a pretty manicure with this nail tutorial.
Want to learn how to paint your nails flawlessly? Watch this manicure instructional video to create this double fading style look. May Paris gives helpful nail polish tips on creating this beautiful design. Be creative! Have some fun & learn how to give yourself a pretty manicure.
Figure drawing is the basis of fine arts education, so watch this how to video on drawing the human neck. To draw the human neck, pay attention to the muscles and bones that represent its shape. Draw an anatomical human neck with tips from a professional illustrator in this free instructional video on drawing.
Are you in medical school an planning to be a surgeon? Then here is a how-to video with various different surgical knot tips. The UT Huston Student Surgical Association (SSA) has put together this surgical knot tying online tutorial. Watch as Dr. John R. Potts, MD. demonstrates the two handed square knot. Practice the two handed square knot surgical suture before going into your surgical rotation.
You bought a whole bunch of strawberries on sale, but you don't want them to go bad. CHOW contributor Daniel Duane shares his trick for keeping farmers’ market strawberries fresh and making them last longer. Just follow this cooking how to video for great tips on keep fresh fruit longer.
No wonder iPod earbuds get grimy—they're in your ears every day. Now that we've grossed you out, here’s how to clean them. This how-to video offers some tips for making sure those headphones stay spotless. It'll keep you healthy, and extend the life of the earbuds. Watch this video electronics tutorial and learn how to clean the earbud headphones on your iPod.
Studying to be a nurse? Then here is a nursing how-to video that teaches you how to collect and label a urine specimen. Every nurse should know the basics of this technique, follow along and see how easy it is to do a urine collection and label it properly. These medical tips are sure to help you pass your nursing exam with flying colors.
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
This brief video tutorial will give you the tips on how to fix your V-Cube 6 puzzle pieces that mysteriously pop out. For some pieces on the Rubik's Cube-like puzzle, it's as easy as simply popping them back into place, but when more of those V-Cube pieces fall off, you might have your hands full... of puzzle pieces.
Should you fold your hand or chase the draw when playing Texas Hold'em after the flop? The first three community cards that are dealt are called the flop. This how to video addresses different situations that can occur after the flop. You will learn what hands you should chase and what hands to fold determined by your position. You can play smarter Texas Hold'em poker with these great tips.
This music production software tutorial gives tips and demonstration for effective use of Equalizers, Shelving and Parametric in Reason. These concepts apply well to any software package that utilizes EQ. EQ like a master after learning these techniques.
This Reason 3.0 tutorial explains use of the Import Midi function and some of ways to use it for practice or remixing a popular song. Also, get tips on spicing up flat MIDI files while learning MIDI remixing and EQing in Reason 3.0
