Getting errors when trying to crunch your numbers in Windows Excel can be frustrating, but with this fun and easy to follow guide to remove the "#DIV/0!" error. When the computer thinks you're trying to divide by zero, it produces an annoying error, but by following this video guide you can be free of that irritation. He goes step by step on how to edit the formula calculator so that it no longer produces the error, and even explains in detail why this is solving the error problem. You don't ...
Learn to solve a Rubik's Cube in no time flat with these easy algorithms to fix those puzzling problems. Whether you have a color that just needs to move a few spots or the proper placement is just a few places off, you can follow these step by step turns of the cube done slowly enough to follow along. The algorithm is even displayed on the bottom of the screen for people savvy in Rubik's Cube terminology. He explains several issues and scenarios that most people encounter when trying to solv...
Many times, the task bar and some of the desktop icons on your computer disappear. This being a common PC problem, the fun video has shown three different ways of solving the problem. The presenter has done a good job by enlarging the key images at most critical points in the presentation. He has also provided more than one way, in fact three ways of solving the problem. There are multiple solutions available with Windows but a very few presenters offer more than one solution. Each proposed s...
Simple instructions for doing a simple bike repair when you are on the road and don't have your tools. This vide shows how to take the tire off your bike rim without using tire levers. Our host demonstrates on a completely flat tire, and shows us how to leverage off the beads of the tire using only brute strength - the leverage of your hands. He then demonstrates how to put the tire back on. The final small section of bead is pushed on using his body strength. This technique is less likely to...
Have a hard time figuring out what a geometric sequence is? This video will help you to identify different geometric sequences as well as determining its nth term. A geometric sequence is a group of numbers that follow a certain pattern of multiplying a fixed number from one term to another. The tutorial uses 4 different examples of geometric sequences and also shows you how to solve each of these sequences as well. Take some time to watch this video if you are a pre-algebra student, it is a ...
Jill Jaxx teaches some simple techniques you can use to improve your singing voice. These techniques are easy enough that you can practice them at home. The main focus is focusing on your breathing but includes some great (and funny) tips including holding your tongue! The student featured in this demonstration has a retainer and Jill helps her to not only relax her breathing to sing better, but to control her tongue to help get her notes and voice out the way she wants it!
In a fraction where the bottom number, the denominator, is smaller than the top number, the numerator, it is called an improper fraction. Because it is improper, you'll want to fix it by turning it into a mixed number.
Ron Hazelton shows you how to fix a hole in a hollow core door in less than an hour. 1) Make a bevel around the hole.
Shape your brows the quick and easy way Follow this quick and simple tutorial to learn how to shape your brows.
Do you have a stubborn sliding door? Does it stick or get off track often? Learn how to fix your sliding door problem with help from this video which teaches how to repair and adjust a sliding patio door for smooth operation.
This video tutorial shows you how to jailbreak and unlock your iPhone 2G, iPhone 3G, and iPhone 3GS on firmware version 3.0.1 with Redsn0w and Ultrasn0w.
This video will help you diagnose and troubleshoot on a basic level, your electric kit. I get asked alot "please fix my rc" and the main issue is that people do not understand how their rc works. While using a multimeter, I will show you how to diagnose battery batteries bars, esc, receiver, antenna, radio on crystals 2.4ghz synthesized modulation motor brushless bl brush less brushed transmission slipper gears pinions cvd dogbones dog bone wheels pins hex and other aspects that will not allo...
This video is about how to overcome speech anxiety. Anyone can be a calm speaker with these tips. You will need a video camera and time to rehearse. The first step is to tape yourself rehearsing your speech, so that if you feel you look foolish you can fix your mistakes. another step is to stand up a few moments before you take your stage that way your blood pressure can be regulated. Step 3 is to count backwards from 100 by 7 so that your left side of your brain works and turns off the right...
Electric garage doors are a great convenience -- until, of course, they break. The bad news: a dozen things could be to blame. The good news: many are easy to fix yourself. Watch this video to learn how to repair your garage door opener.
Go beyond the traditional 3D workflow to an immersive creative experience with the software Modo, created by Luxology. Modo is the next evolution of 3D modeling, painting and rendering for Mac and PC. Modo includes 3D sculpting tools, animation and network rendering, and advanced features such as n-gons and edge weighting.
When you're flying your model airplanes, it's inevitable that it will eventually suffer some minor damages, like scuffs, breaks and bends. This video tutorial will help you alleviate and repair any damages to your flying model airplane to get you back in the skies again.
This how-to video shows a way to create a pretty fairy look to use as part of a Halloween costume. The demonstrator used these cosmetics: Mac Studio Fix Fluid Foundation, Makeup Forever HD Powder, Mac Emote Blush, Airbrush Stencils, 88 Shimmer Palette, Flat Head Stippling Brush, Ben Nye Final Seal, Benefit Lemon-aid, 88 Shimmer Palette, Mac Uppity Fluidline, Mac Blacktrack Fluidline, Urban Decay 24/7 Eyeliner in "Zero," Ardell Enchanting Lashes, Duo Lash Adhesive, NYX Lipliner in "Rose," and ...
It's true, Halloween is basically the time for girls to dress slutty. Check out this how-to video for a sexy pirate look. The demonstrator used these cosmetics: Mac Studio Fix Fluid Foundation, Mineral Veil, Nars Laguna Bronzer, True Gold e/s, Mac Blackground Paintpot, Black Ruby e/s, Rapture e/s, True Gold e/s, Retro e/s, Mac Gesso e/s, Mac Blacktrack Fluidline, Diorshow Mascara, Urban Decay 24/7 Eyeliner in "Zero," Mac Quartz Lipliner, Mac Viva Glam I Lipstick, and Mac Cult of Cherry Lipgla...
Ever wonder what basic tools you should have for all your bicycling needs? This how-to video covers some basic gear that will help you with frequent bike repairs. Tire levers will help change any flats. A multi-tool will keep you from needing to buy several different Allen keys. A bike pump will keep the tires inflated. A spare tube and a puncture repair kits can fix emergency flats. Oil will keep the chain running smoothly. Watch this video cycling tutorial and learn how to stock a bike repa...
A quick and easy way to whip up gourmet spinach fettuccine. Follow along and learn how to make this vegetable and pasta dish. This cooking how-to video is part of Quick Fix Meals with Robin Miller show hosted by Robin Miller. Busy people everywhere face the same dilemma, how to get healthy weeknight dinners on the table when you've only got minutes to spare. Cookbook author, nutritionist and food journalist Robin Miller guides you through the landmines of getting food on the table nightly wit...
Make easy zucchini boats for a delicious weeknight meal. This cooking how-to video is part of Quick Fix Meals with Robin Miller show hosted by Robin Miller. Busy people everywhere face the same dilemma, how to get healthy weeknight dinners on the table when you've only got minutes to spare. Cookbook author, nutritionist and food journalist Robin Miller guides you through the landmines of getting food on the table nightly with her stress-free meal planning strategies. Her easy, day by day plan...
This After Effects tutorial gives a basic overview of how to create the tongue effect as seen in the show Kung Pow. You want your actor to move as little as they can, or you will have to fix the footage by motion tracking, which isn't covered in this tutorial.
This how-to video from makeup master Judy demonstrates a pretty bridal look inspired by Carried Underwood. She used mostly MAC cosmetics, specifically URBAN DECAY primer potion, MAC "girl friendly" paint pot, MAC "shore leave" E/S, MAC "cork" E/S, MAC "handwritten" E/S, MAC "rice paper" E/S, LOREAL intense liner, REVLON "frilly white" colorstay pencil eyeliner, RIMMEL waterproof mascara, FACEFRONT COSMETICS survival paint primer, MAC "handwritten" E/S, BEAUTIQUE "natural" lip liner, MAC "2N" ...
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how to plug the EFX-1000 into a mixer without a send or return. The mixer in the video is the American Audio QS-D.
Not all Halloween costumes have to be grotesque. This look is a pretty, nature inspired peacock feather eye, that can even be worn in a non-costume way. To create this look, use these MAC cosmetic products Studio Fix Fluid Foundation, BE Mineral Foundation, Mineralize Skinfinish Duo in "Medium Dark," NYX Pinky Blush, Bobbi Brown Shimmerbrick in "Gold," Blackground Paintpot, Mutiny Pigment, Teal Pigment, Black Tied e/s, Woodwinked e/s, Blacktrack Fluidline, Urban Decay 24/7 Eyeliner in "Zero,"...
This how-to video demonstrates a stumper of a puzzle‚ using only 4th grade math.
Have a Rubik's Magic Puzzle that's been failing you? It needs a little adjustment, doesn't it? Well, this four-part video tutorial will show you how to fix it, by restringing the puzzle.
This makeup style is perfect for an Indian wedding or for a Bollywood style costume party. Watch this instructional cosemtics video to apply flashy Indian eye makeup.
This makeup how-to video demonstrates a pretty soft purple eye look, designed to define and emphasize the natural shape of Asian eyes, that typically don't have a crease. The cosmetics used to create this look are MAC Shadestick in Overcast, NYX Purple, NYX Deep Purple, NYX Baby Pink, NYX Golden, Black eyeliner, Shiseido Lasting Lift Mascara, L'oreal Color Rich lipstick in Amber, MAC C25 Studio Fix Powder, and MAC Sheertones Pinch Me Blush. Watch this video makeup application tutorial and lea...
This makeup how-to video tweaks the smoky grey look oft seen on the likes of Kim Kardashian into something that suits Asian and monolid eyes. The cosmetic products used to create this look are a black pencil eyeliner, dark grey eyeshadow, light silver eyeshadow, ivory eyeshadow, black eyeshadow, mascara, ELF lip gloss in Baby lips, MAC Studio Fix powder in NC25, and Milani Bronzer. Watch this video makeup application tutorial and learn how to create a Kim Kardashian inspired smoky grey eye ma...
This makeup how-to video shows a pretty and feminine eye look, with Asian eyes, monolids, or any eye with small or no eye creases, in mind. The cosmetic products used to create this look are MAC Bare Study Paint Pot, MAC Sketch, NYX Prune, MAC Goldmine, Lancome Daylight, HIP cream eyeliner in Eggplant, MAC Beauty Marked, Shiseido Mascara Base, Shu Uemura Fibre Extension, Shiseido Lasting Lift, MAC lip conditioner in Petting Pink, MAC Studio Fix powder in Nc25, and Nars Orgasm Blush. Watch thi...
Triceps tendon ruptures are not very common, but they are a debilitating injury. A triceps tendon rupture may require surgery. Learn how to treat sports injuries in this how-to video on health and rehab.
LCL stand for lateral collateral ligament, and it is a ligament of the knee. Rehabbing a torn LCL after surgery can be an involved process. Learn how to treat sports injuries in this how-to video on health and rehab.
Don't have much time in the morning? This makeup how-to video demonstrates a 5 minute minimal day look that's designed specifically for Asian eyes with monolids, or undefined creases. The cosmetics used to create this look are MAC Studio Fix NC25, Sephora Blushes from palette, The Makeup Store Eyeliner in Black, Shiseido Lasting Lift Mascara, and MAC Impassioned Lipstick. Watch this video makeup application tutorial and learn how to do a quick, daily makeup look for Asian monolid eyes.
For all the lovely ladies who are starting to be more adventurous with colors, here's a way to go. Start with gorgeous neutral tones in deeper bronze colors to make your eyes pop! The look designed in this makeup how-to video was specifically created with Asian eyes in mind, to enhance the shape and natural beauty of monolids or eyes with small creases. The cosmetics used to create this look are Smashbox Photo Finish Primer, MAC Studio Fix Powder in NC25, The Make Up Store Microshadow in Ruby...
Cindy Crawford once said, "Even I don't look like Cindy Crawford when I wake up in the morning." If you're like most girls, mornings are not your most glamorous time. And hair? Blech. Cowlicks, frizz, funky bumps from sleeping on your side. All these and more need to be fixed, and using a straightening iron is one of the best ways to do so.
Check out this home repair tutorial video that demonstrates how to repair a lead on a Dyson vacuum cleaner. After a long period of time, the lead will get metal fatigue within it and the machine will work intermittently. Follow the step by step instructions in this domestic appliance repair video to properly troubleshoot the Dyson vacuum's switch unit. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe repair of yo...
This copper and bronze eye makeup look is great for the fall, and really adds focus and drama to the eyes. The cosmetic products used to create this look are Studio Fix Fluid Foundation, Make Up For Ever HD Powder, Emote blush, Nars Orgasm blush, Cream Color Base in “Pearl,” Painterly Paintpot, Deep Damson e/s, Coppering e/s, Black Tied e/s, Brule, Shroom e/s, Blacktrack Fluidline, Urban Decay 24/7 Eyeliner in “Zero,” Loreal Voluminous Mascara, Fleshpot Lipstick, and Bare Necessity Dazzleglas...
Are you a scientist in need of a method distinguishing bacterial species into groups based on the chemical and physical properties of their cell walls? Well, that's where a Gram staining procedure comes into play.
In this automotive repair tutorial you will learn how to do your own body work on rusted door panels. This particular tutorial shows you how to remove rust, fix dents and repaint the door skins on a 1999 Dodge Ram 4x4 but you can apply these body work principles to any similar car or truck. If you have rust, or scraped up door panels watch this video and learn how to repair them.