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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
When your clay is too tough and not malleable beneath your fingertips, you've got trouble. Pottery, after all, requires smoothe and flexible clay that can be molded into any shape you desire.
Want to dress up like Rihanna for Halloween? Okay, we're totally kidding, but you should watch this special effects makeup tutorial if you're looking to wear a costume that requires facial scarring and bruising this Hallowen.
There are a zillion ways to make stuffing for your Thanksgiving bird, but only one way to make it Martha Stewart-style. If you're cooking for a big party this year of 20 people or more, Martha offers a delicious, buttery recipe for stuffing that'll satiate all the mouths you'll have to feed while still having leftover for casserole.
Before you know it, Valentine's Day will be here. Or your boyfriend's birthday. Or your two year anniversary. And while buying the newest techie gadget for your boy will earn you a gold star on your head, you can truly get his heart racing by making him a pair personalized boxer shorts.
It's time to teach your kids about animals! To get your little one thinking like an animal, why not help them look like one? In this tutorial, featuring John Lithgow, learn how to turn common household items like paper plates and paints to create fun, realistic looking animal masks with your kids! You will also learn how to make special doggy treats and bird feeders so that you can really get on all fours with your animal buddies! Have fun!
You don't want to look back at your prom photos going, "ugh, I wore that?!" or "oh my god, I look like I have a dead skunk on my head," do you?
Get ready for Teacher's Day or simply show your teacher how much you care by making one of these cute as a button grannysmith apples. Apple-shaped pencil holders and notepads are sweet, but these origami apples show you took a bit of time out of your busy day to really make something special.
This is a fun trick to perform on your friends, anywhere. First, explain to your buddies that your deck of cards is special and acts just like an ATM. They'll naturally be confused and ask you to prove it. That is when you take a low number card from your deck, swipe it, and turn it into a card worth twice as much!
Remember those little tricks your Dad played on you as a kid? Like the old "penny behind your ear" trick? Well, in this tutorial, learn how he did his famous "detached finger" bit.
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 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special values.
Learn from Betty Crocker Kitchens, how to easily and quickly make a dinosaur birthday cake. You do not need a special cake pan for this recipe. She uses two 9" round cakes, to cut all the shapes you need to make the dinosaur. It is only required to cut out 3 shapes, and you can print the templates from their website. After the shapes are cut, you use the frosting to "glue" the cake to the platter you are working on and then spread a thin layer of the frosting all over the cake to seal in the ...
In this video from RadioLynxContent we learn how to make a cucumber mojito, which is a local special in Whistler, Canada. For this you use fresh mint and a couple of slices of cucumber. Place in a glass and press down on the mint leaves and cucumber while they're in the glass. Next add 2 shots of Bacardi White. Then next add simple syrup which is half sugar, half water. Add 1 oz of that. Then add a bit of fresh lime juice and pomegranate juice. Top it with ice and give it a good strong shake....
In this fascinating "how to" video, you will see how a simple process creates the illusion of ice that is burning. Only a few items are needed to enact this scientific experiment. As the narrator describes, "Calcium carbide reacts with water to form acetylene gas." To illustrate, the video shows a bowl of ice cubes, to which the special ingredient is added. As the ice melts into water, it reacts with the calcium carbide, forming the high flammable acetylene gas, which is often used in welding...
Curtis Smith, an extension horticulturist talks about using cages for your tomato plants. He says that some people like to stake tomatoes, some like to cage them and some even just let their tomato plants sprawl. He talks to a local gardener who has built his own tomato cages out of concrete wire. The gardener shows his cages, which he built 10 years ago and they still look sturdy today. Curtis gives a few tips like wrapping the cages with a special fabric that lets air and light through, but...
When entertaining, it's great to have fun, colorful ideas to make drinks feel special. By adding a simple slice of fruit or vegetable to a glass of water can impress your friends and make you feel like you're at the spa. It is very important to drink water, and flavoring it with lemon makes it easier if you're not a water drinker. The host cuts slices of lemon and lays them on top of the water or the side of the glass to garnish, and squeezes the rest of the juice into the water. It can be ma...
Modern Warfare 2 Look Ma Two Hands Trophy Guide Video. The Akimbo weapons in two hands and the trophy associates the guide during rushing in bomb squad and the gun has 10 rounds after that press and hold a control key for a new automatic weapon. The Akimbo hand guns really prevent and protect to move forward and the options will automatically ask for the good pistols and weapons. Machine guns and sound are added to the special effects for this trophy warfare game. Finally this game must provi...
Skip Steele and Terry Black of the award winning Super Smokers BBQ Team share their method for making championship barbecue ribs.
Make the perfect cake for any little boy or girl with Sesame Street character cake toppers! In this two-part video tutorial, learn how to make a baby-version of the Cookie Monster out of fondant icing and gumpaste. To make Elmo, carry out the same technique & instructions but with red icing. Give that little special someone in your life a cake they will cherish!
Learn how to use the navigation system in a new 2010 Toyota Prius in simple steps. It has DVD based navigation system with easy to use touch screen display. All the navigation routes of USA, Hawaii and parts of Canada are available in it supporting English, French and Spanish languages. When you start the car it opens the map and you can input the destination using voice command or entering text. You can also input your home address and five other special location address.
This three and a half minute video talks through the basics of hand massage. With close-ups of the action, the instructor talks through the basic technique and progression for hand massage, providing details and emphasis. All the various strokes are covered: stretching strokes, circular compression, squeezing and kneading. There's no lotion or special materials you need - just your hands, and the hands of a lucky subject. If you want to learn a new way to please your friends or partner, take ...
The Video On Demand highlights how amazing backgrounds are inserted behind characters and will show you how to composite video so your characters can seamlessly move in front of these images. Computer generated video objects may be superimposed over a background video image so as to create the illusion of a single composite scene. The leading edge of an object is detected and for a period of time the object and background video signals are mixed. After that period, only the object video is tr...
Rick Vanman reveals the secrets to professional video effects using your own computer software. Position your model houses into a setup of your liking. Take a picture of the houses with a digital camera using the macro setting. Edit your picture in Photoshop. Disguise any unwanted objects with the cloning tool. Separate the foreground and the background of the picture into 2 different layers. Film yourself in front of a green screen. Key out the green with your video editing software. Using y...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
Being able to create documents that stand out and impress is the theme of this how-to video on creating 3D text. Using an open Photoshop window, the pleasant sounding narrator guides you through the process of turning regular text into 3D. The narrator also supplies helpful tips to further enhance 3D text by adding color, glow and special effects like reflection. If you're a visual learner, you will appreciate this straight forward, clear and detailed how to video on creating 3D text.
Would you like to craft perfect 3D origami works of art? In this helpful tutorial, Jewellia7777 demonstrates how to use recycled paper to create your own elegant "green" works of art in no time. Learn to easily construct a stunning table centerpiece of paper that would let you contribute your own artistic touch to any special event, formal or informal. This great video will have you stunning your guests in no time with the impossibly beautiful flair of this fun project.
Your wedding day is vastly important and every bride would like the wedding pictures to reflect how beautiful they felt that day. In this tutorial presented by Smashbox Cosmetics, learn how to get the perfect camera-ready makeup look, perfect for your special occasion.
Steal this look: The metallic smoky eye! With the help of Smashbox Cosmetics, this video goes through the step-by-step process of taking this look into your own home and making it your own. Using Smoke Box from Smash Box, a metallic smoky is born that will leave you look sultry and sexy for your next special event.
What's a proton pack without a ghost trap? Useless, that's what. Don't pay megabucks for some fake Ghostbusters costume when you can build your own with household materials.
Home security is as important as having a job. You have to protect your family and your valuables. If you can't afford a high tech security system, then maybe a fake security camera will do the trick. This security camera dud is also a cheap alternative for a film prop. Watch this video tutorial to learn how to build a fake cardboard security camera.
If you have questions, Redbook Magazine has answers. "Love your life." Redbook is for the woman juggling family, career, and her own own needs.
Street Fighter IV : Blanka, the Brazilian Beast unleashes havoc upon the World Warriors once again. Street Fighter IV is a 2008 fighting game produced by Capcom. Street Fighter IV is currently released for PlayStation 3 and Xbox 360, with a Microsoft Windows version in the works as well.
Street Fighter IV : Vega, the beautiful Spaniard delivers gruesome damage. Street Fighter IV is a 2008 fighting game produced by Capcom. Street Fighter IV is currently released for PlayStation 3 and Xbox 360, with a Microsoft Windows version in the works as well.
This instructional video, produced by Jewish Pathways, demonstrates how to perform Havdallah after Shabbat ends. Hadvallah is a Jewish religious ceremony that marks the symbolic end of Shabbat and holidays, ushering in the new week.
This instructional video, produced by Jewish Pathways, demonstrates how to put on a tallit for Jewish prayers. The tallit (or tallis or tallith) is shawl used for Jewish prayer, worn while reciting morning blessings and well as in the synagogue on Sabbath and holidays.
This instructional video, produced by Jewish Pathways, demonstrates how to light the Shabbat candles. The lighting of Shabbat candles not only ushers in the Holy Day, but is also a special time of spiritual contemplation for Judaists. It is the pivotal moment when we cross over from the weekday into the holiness of Shabbat (or Shabbos, the Jewish Sabbath).
This homemade cake mix can turn your least kitchen-savvy friend into a star baker. And you’ve done 90 percent of the work, which is the greatest gift of all.
They don't call them salad days for nothing; you probably can't afford to eat anything else. But there are ways to trim your food budget—and they're even good for you. Learn how to eat cheaply on a budget.
Have you ever wondered what your DNA looks like? You have probably heard that DNA is a double helix, which is a pair of parallel helices intertwined about a common axis, but how do we know that? How can people look at DNA?
