Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assign the macro to a form button. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
If you are looking to purchase a new pair of pants or suit, you will need to know how to measure your waist size. In this quick tutorial, learn exactly how to use a piece of measuring tape to take your measurements and ensure your new outfit fits you perfectly.
In this CHOW episode, learn how to roast delicious vegetables with Lisa Jervis, cofounder of Bitch magazine and author of "Cook Food: A Manualfesto for Easy, Healthy, Local Eating". Learn how NOT to roast your vegetables to get a dish full of mushy veggies that taste more steamed than roasted.
Do you not have a steamer? Or time to wait as your vegetables steam? In this video you'll learn how to steam your broccoli in the microwave. Quick and easy in the microwave to immediately serve and enjoy on their own or with any meal. Yes, the microwave will produce some perfectly steamed greens, with a pinch of salt and maybe some butter.
Having a hard time getting your broccoli steam just as you please. This video shows you how to steam your broccoli just right and perfectly soft to enjoy with your meal or on there own. You'll see exactly what you've been doing wrong and how to fix it to enjoy your steamy greens.
This video walks your through the quick and easy steps of caramelized grilled onions. These delicious sweet onions go so perfectly on any burger, fries, and of course a juicy steak. Here you'll learn exactly what you need to do to master the art of caramelized grilled onions for the whole family.
Dummy cakes are for stores & cake decorators to show off their designs without the worry of a falling cake or cake spoil. In this tutorial, learn how to perfectly cover a dummy cake (made of styrofoam) with sugarpaste or fondant icing. With a little practice, you'll be covering your cake with no wrinkles or tares in no time! Follow these simple steps to get this practice down.
More often that not, beginner harmonica players will have to be told the key to use during a jam session. It's perfectly reasonable to ask the key, so long as it's before the song starts that you're asking. But if the answer is obvious, you're better off knowing than asking. You don't want to look silly by asking obvious questions. This video will show you to know the key without asking.
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.
Tips and tricks to cross style French braids. Starting with making sure that you get hair damp and as close to perfectly straight to make sure the French braids come out as well as possible. This step by step instructional video shows you how to part and braid the hair on another person to help them create this style of braided hair. After watching this video you would be able to create the style of crossed French braids with perfect precision.
Corinne Trang, author of Noodles Every Day, offers a helpful tip on how to easily get the seeds out of a chili pod and still be able to get perfectly round, thin slices.
Driving through thick fog can sometimes be intensely scray. Luskily we have a how to video for how to deal with situations like these. When you run into fog on the road, keep your head and follow these simple tips to stay safe.
While the snow-covered mountains can be exhilarating, they can also be dangerous. Here's what to do to stay safe.
A riptide can be terrifying. But if you keep your cool and know what to do, you'll stay safe. You Will Need
Don't use a perfectly good DVD burner to get your laser that will pop balloons, light matches, and burn stuff. Just buy a laser diode at mfgcn.com and also a laser housing, and you won't be tearing a computer DVD player apart. This is the easy way to make a 200mW burning DVD laser. Use a Mini Maglite and some rechargeable batteries so you don't burn out the laser.
It's Christmastime, which means presents! Not only are you going to unwrap gifts under the Christmas tree this holiday season, but you'll probably have to wrap a few for others.
Think every model you see in a magazine has perfectly smooth skin? Sure, but don't worry, it's not natural! You can do the exact same thing in Photoshop with this tutorial. Watch and learn how to smooth skin by retouching portraits with blur tools in Photoshop CS3.
Watch this instructional video on how to coat detail work around boxes and pipes with joint compound. Spackling drywall is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of spackle. Learn how to lay dow thin coats of putty around details and box shapes to avoid heavy sanding in the second stage of prepping a room for painting.
Watch this instructional video on how to coat butt joints with joint compound. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of spackle. Rock the putty knife back and forth to coat a butt joint with joint compound. Once you are ready, try out to bonus trick for spackling masters.
This instructional video demonstrates how to coat ceilings with joint compound, without dripping mud on your face. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of joint compound. Spackling ceilings is one of the more difficult tasks in prepping a room for painting, but this video provides tips on how to lay down thin layers of putty to avoid heavy sanding after the spackle dries.
This is a video demonstration on how to coat cornerbeads with join compound. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a bucket of fresh joint compound. Learn how to spackle a corner in thin coats to avoid heavy sanding in the second stage of prepping a room for painting.
Here's a way to make your drywall project perfect. Mix up some thin joint compound, using more water than normally required for spackling holes in the wall. You can roll the putty onto the wall with a think rolling brush. After the joint compound dries, it only requires a light sanding. Watch this instructional video to create perfectly smooth drywall surfaces with liquid spackle.
The Perfection Loop is a great knot for tying a small loop at the end of the line. The Perfection Loop is perfectly in line with the standing part of the leader and it is both quick and easy to tie. Follow along with this how to video to learn how to tie the perfection loop for fishing.
Learning how to draw is a very much about learning how to see. Watch this instructional drawing video to begin to draw the illusion of depth on a flat surface. Most people can see perfectly fine and understand the concept of depth in space. However, drawing becomes tricky when you must translate a moving object onto a piece of paper. Learn to draw in the page, rather than on the page.
Learn how to tie a tie in many different ways with this tutorial. This how to video teaches you the Four in Hand knot, Windsor knot, Half Windsor and Pratt knot. With the steps in this video you will be tying your ties perfectly in no time.
This tutorial video will teach you how to hack a sealed envelope to open it and re-seal it perfectly. This is great for anyone looking to snoop through someone else's mail. But that is illegal, of course.
This method rarely works perfectly but when it does work, oh man does it do a good job. The video shows a nearly perfect example, so don't be discouraged if you don't get great results every time. Check it out and learn how to use inversion to create an acapella sample in Adobe Audition.
The side leg lift series is part of the classical Pilates repertoire and the circles strengthen the core, flatten the abdominal muscles and tone the inner and outer thighs. If you feel strain in your lower back, bring your legs slightly forward of your body, but for a real challenge, maintain a perfectly straight line and bring your top hand to your hip. Watch this fitness how to video and you'll be strengthening your body with pilates in no time.
Wish you could get that salon perfect blowout at home? This hair styling how to video, brought to you by ELLEgirl, shows you how you can blow dry your hair perfectly yourself.
Does your budding athlete want to try out for the basketball team? Before that first practice, watch how to properly shoot a basketball.
You can't make great sushi without perfectly cooked sushi rice. See how to prep, cook, season, and cool sushi rice, and you'll be rolling in no time!
Learn how to pick out that perfectly ripe avocado and find out how to avoid the bad ones. You don't want to get home with an old avocado or one that isn't ready to use in time for that party.
Watch this video to learn how to fold fitted sheets without any puffy wads. Unitl I saw this video, I didn't know it could be done
Set a perfectly beautiful Thanksgiving Table! This step-by-step guide from Julie Mulligan shows you just what to do to create an unforgettable table this Thanksgiving Day! In this video, Julie teaches how to create beautiful placemats using fresh flowers.
Set a perfectly beautiful Thanksgiving Table! This step-by-step guide from Julie Mulligan shows you just what to do to create an unforgettable table this Thanksgiving Day! In this video, Julie teaches how to create candle holders using sunflowers and fruit.
The key to the perfect fluffy omelette is a perfectly hot pan. Watch this how to video to get more tips on how to make an omelette worthy of Michelin Stars.
A perfectly trussed chicken makes one neat, tidy, and tasty package! Wrap it up and roast away, watch and learn how.
Here's a great tutorial on how to apply liquid liner perfectly, even if you have shaky hands.
