Year End Search Results

How To: Reduce the frizz in your hair

Bad hair day? Is your naturally curly hair just extra frizzy today? Here's a quick tip to tame your mane - after your spray your hair with hairspray, roll the canister over your hair to smooth out the ends of the frizzies and make them lay flat

How To: Paint a Hawaiian landscape with island inhabitants

Merrill Kazanjian has this painting tutorial which shows the process of his Hawaiian landscape mixed media painting. Follow along with the video and try to learn some of the painting techniques Merrill uses. He uses acrylic paint and at the end, puts his own twist on a boring landscape painting by using PaintShop Pro to add some island inhabitants.

How To: Do the Joker's makeup from The Dark Knight

Heath Ledgers iconic portrayal of The Joker in the film The Dark Knight has made him a Hollywood legend, shoving Jack Nicholson Joker straight out of posterity. This video will teach you how to do your makeup to look like his scary makeup from the film. The end result looks really good, and is sure to intimidate your friends on Halloween or at whatever other costume soiree you wear this to.

How To: Make The X-Men character Gambit out of Legos

Gambit is one of the most popular and underutilized characters in the X-Men pantheon. Now, you can show you appreciation of this iconic anti-hero by making his likeness out of Legos. This video walks you through the process of making a Lego figure look like Gambit. The only non-Lego thing that you will need is paint, and the effect at the end is very cool.

How To: Sum year over year sales using MS Excel's SUMPRODUCT

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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.

How To: Perform a bar trick using a bandana or cloth napkin

In this tutorial, learn how to trick people in a bar or at a party. This trick requires only a small piece of cloth like a napkin or bandana. You ask an opponent to try and tie the cloth in a knot without crossing their arms or letting go of the ends of the fabric. This may sound impossible but with a simple slight of hand you'll be able to tie it and win your bet!

How To: Throw a 7 pound flowerpot with Simon Leach

Simon Leach has taught us a lot about ceramics and pottery in his many videos. In this concise one he demonstrates for all you at-home potters out there how to make a 3 kilogram (6 pound 10 ounce) flowerpot on the wheel. As you can see at the end of the video, that is a pretty large pot. If you can throw this, you are well on your way to being an advanced ceramics enthusiast.

How To: Find dates with Microsoft Excel's WORKDAY function

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 372nd installment in their series of digital spreadsheet magic tricks, you'll learn how to find the end date for a specified event with the WORKDAY function given a start date, number of workdays and non-included days.

How To: Count days excluding Sundays in Microsoft Excel

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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.

How To: Prevent external parasites like fleas and ticks

In this video you'll learn how to end the cycle of those pesky fleas and ticks. You'll learn exactly what to use and what to do to stop these external parasites from invading your home or living on your poor innocent animal. After watching this video you'll be able to enjoy a flea and tick free enviorment.

How To: Identify if you have aphids and webworms on mesquites

The video shows how to effectively be aware and get rid of possible webworms or aphids on your mesquites so they won't get damaged later. Here, John White invited Annete Peterson to show how to do so. She starts by informing from what she saw that many mesquites from her neighborhood have deformed leaves and mainly several of them have stripped branches at the tips of the trees. He explains that one of the problems is a webworm on the leaf of the mesquite, and it eats the leaves of the plant ...

How To: Tie a rising sun knot

In this beautifully crafted video by Tiat presents the keyhole weave method of tying the rising sun. Grab about a yard of smooth decorative twine and you are ready to follow along. You will end up tying both the double coin and the ring of coin knots to make create the rising sun. But, fear not, the demonstration is clear and simple to follow.

How To: Make the perfect egg omelette

Jack from "Cooking with Jack" shows you how to make the perfect omelette in this quick video. You'll learn the common problems and mistakes made when making an omelette and how to make some simple corrections. He discusses the wide variety of ingredients that you can use. Jack then shows you a new method that a viewer sent in that involves broiling the omelette in the oven to ensure you end up with a perfectly cooked omelette every time!

How To: Make a glue bottle holder

Use whole saws or drill bits larger than the necks of the glue bottle and about a ten inch 2x4 piece of wood. Drill holes for the amount of bottles you want to have. You can add feet to your rack if the necks on the bottles are too long for the rack by gluing a couple of small wood blocks underneath on both ends.

How To: Download a DSI web browser

In this video, learn how to download a web browser for your Nintendo DSI. This application was developed by Opera Software + Surprise Ending.... And for those of you who might ask: "Why can't I watch YouTube videos?" There is no Adobe flash player in this version of the browser, so YouTube videos are not available with this version. Connect your DSI to the Internet with this helpful video.

How To: Make a glitter and lace card

Cards are so meaningless these days, unless of course, you make make your own, giving it that personal and meaningful touch. Watch this video tutorial to learn how to make a glitter and lace card, with help by Barbara Trombley from Art Glitter. Barbara designed this technique for making glitter lace cards using polyester lace, glitter, and sticky paper as a template to create lace paper that sparkles to no end!

How To: Do a slant gainer/cheat gainer

In this video tutorial the performer demonstrates the slant gainer, also known as the cheat gainer. Basically, it involves hurling yourself away from the ground, spinning in the air for a while and then trying to land without busting your ankles and/or head. If accomplished successfully, it looks extremely cool. If it ends in failure, at least you might get a hit YouTube clip out of it.