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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Here in civilization, any sign of a cold can be instantly erased with a trip to the doctor and the right medicine, but when you're stuck out in the wild without any pre-packed meds, you're in major trouble.
With stores like Lush Cosmetics and Bath and Body Works churning out soap rife with rose petals, glitter, and pretty designs, soaps are no longer just designed for getting clean.
Garlic is a delicious, salubrious and stinky vegetable. Learn how to remove its garlicky stench from your hands with this handy video tutorial, which suggets, among other things, using lemon juice to get rid of the unwanted odor. For specifics, and to get started cleaning your own hands, watch this handy how-to.
Fans of the "Twilight" sage know that Bella weds her vampire love, Edward Cullen, in the novel "Breaking Dawn". In this tutorial, learn how to create a fresh faced makeup look inspired by Bella's big day. This look takes Bella's young, clean style into account and gives it a gothic vampy twist.
Like any machine, a drill press chuck is prone to wear and tear and with repetitive usage some parts can become unaligned. If you are going to remove a drill press chuck, keep in mind that also with any machine you work with, you'll want to clean off any gunk that accumulates so you have a properly working machine.
You will to learn set up and calibrate your jointer for optimal woodworking and creating a clean and straight edge on a rough board to later use as a reference. You will also learn a system on how to set up your knives to achieve the perfect cut using a jig and how to select the best jig to work with.
Accidents will happen. This brief how-to will guide you through the process of disassembling, cleaning and reassembling a sixth-generation iPod Class (A1238) quickly and efficiently without damaging any of the components, the first necessary step of any successful repair or restoration. This tutorial will also be of use to those who wish to learn more about the guts of their iPods without actually disassembling their units.
Want to remove dried wax from a carpet? You'll need four items: a white towel, a regular electric iron, a carpet cleaning solution and a hot-water extraction machine. For a complete, step-by-step demonstration of how to remove pesky paraffin wax stains from your own carpet, watch this free housekeeping video tutorial.
Save yourself a fortune by making your very own homemade oatmeal facial mask. Place 6 teaspoons of sweet almond oil into a small bowl. Add 2 drops each of pure violet oil, lavender, neroli oil to the bowl. Add enough oatmeal to the mix and make a paste. Pat onto your face and lay down for 20 minutes. Rinse clean with warm water.
If you're a serious film buff then these glasses will totally give you a cinemagasm. This polarization filter uses a pair of 3D glasses as a base and combines the glasses with a lens cap to reduce glare and any reflections that could tamper with your viewing experience.
Dress shirts are best kept on a hanger in a closet, but if you're pressed for closet space, here's the next best way to store them. You will need a dress shirt in need of folding and a clean, flat surface. Fact: In the state of Indiana, you can make up to $17,000 a year operating a shirt folding machine, a handy device patented in the U.S. in 1989.
Keep it clean, covered, and coated, and say goodbye to that scar from the get-go. You will need running water and mild soap, self adhesive bandages, antibiotic ointment, petroleum jelly, sunblock, and silicone gel sheets. Warning: See a doctor immediately if your cut is extremely deep, won't stop bleeding, or appears infected.
This instructional video will show you how to remove the bumper sticker of a failed candidate, such as McCain/Palin. Now you can stop broadcasting failure without leaving a sticky residue.
Watch this instructional drawing video to draw and color a cartoon. Use a calligraphy pen to draw think lines and thin lines with a single pen. This allows you to draw expressions quickly and decisively. With a clean brush, dampen the paper where you want to add color. Mix marker colors with water to mix a quick watercolor palette.
This medical instructional how-to video demonstrates the proper way to perform a standard venepucture procedure on a patient. Before drawing blood from any patient it is always good to identify your patient. Wrap the band at the top of the arm and use alcohol to clean the area. Watch to learn how to perform a standard venepuncture procedure.
Interested in some good clean fun? With this hack from Japan, you'll learn to operate a Roomba vacuum cleaner remotely using a Nintendo Wii balance board with a Bluetooth serial adapter. Watch this tutorial and build your own Surfin'ba today!
Getting your pool ready for summer is very important as the water will not be circulating for a few months. This instructional how-to video shows you how to close down your in-ground pool for winter. Start by removing debris and properly cleaning the liner. Don't forget to remove any exterior accessories and equipment properly before winterizing the in ground pool.
Are you using the Queen too much, or attacking with one piece at a time, or making mostly pawn moves, or that tricky Knight obsession, or "freeing" the Rook with a side pawn, or are you being a victim of a back row checkmate? Well, watch this video to to avoid these common chess mistakes.
So the wife shows me an episode of Oprah with Dr. Oz of the You series of health books. He's showing this thing called a neti pot. It's a watering can for the nose. The thing is put into one nostril and warm salt water is poured through the nostrils cleaning out the sinuses.
This video demonstrates how to fillet the breast of a wild turkey. Technique also works on geese.
The Lab Rats, Andy Walker and Sean Carruthers, demonstrate how to wipe your computer's hard drive clean and install Windows from scratch.
Some repairs on an Xbox can be repaired with a heat gun. Turn your Xbox off first. Take it apart. Remove all of the bolts and screws. Set them aside. You will need to remember where everything goes to reassemble it. Remove all of the heat sinks. Clean off all of the paste. You will only be heating the GPU. Do not use it on the CPU. You'll need Arctic clean and a cotton swab to remove all of the paste. When it is clean, turn on your heat gun. Set it for 1000 degrees. You can test it by seeing ...
In order to make a glowing lightning bug sculpture, you will need the following: an empty pop bottle, a yellow marker, a pipe cleaner, construction paper or card stock, and glue.
This video demonstrates a great way to take rust off of metal piece that are hard to clean by hand. You will need a plastic bucket, a wire hanger, and a battery charger. In the bucket mix one gallon of water and one tablespoon of washing soda. You can make washing soda in the oven by cooking baking soda at 450 degrees for one hour. Take apart all the moving objects off the metal piece you want to clean. Prep the surface by spraying some brake fluid on it and wipe it down. In the bucket hang a...
The video is a description of how to refurbish a brass door frame, and door knob that has gone dull due to the lacquer. Purchase lacquer and metal polish at a hardware store. Before beginning work, remove the circulate at the back of the door knob with circulate pliers. Take the component parts of the door knob apart and set the spring and clip aside to be replaced later. Take a clean cloth and put metal polish on it. Using the cloth, polish the knob. It may take a while to get all the grime ...
The following are the steps to be followed to organize a linen closet: 1. First, you need to clear a work space. This works really well because you need to remove the contents from the linen closet.
Next time you don't want to make your bed, dry the dishes or clean the house there's no need to feel guilty. You may be doing yourself a favor. There are legitimate scientific reasons why some chores aren't always the best health choice.
This video is a good demonstration of how to properly clean your ear and get rid of ear wax. Understand your ear's anatomy to better maintain your aural health.
This Lowe's video shows you how to safely use a charcoal and gas grill. For gas grills you should always follow the manufactures instructions. You should keep your grilled maintained by keeping it clean. Empty the grease cup on a regular basis. A good cleaning of your grill is recommended at least once a year. All of the parts should be checked to make sure they are working properly. Make sure you use gas or propane wisely. Check for leaks. For charcoal grills you should follow the manufactur...
It is important use a 70% or 90% volume alcohol that you can find at a local pharmacy. For lipstick: Fill alcohol lid with alcohol, and dip the top part of the lipstick into the alcohol. Use a tissue to wipe off the excess alcohol on the lipstick, and its ready to use. You can throw away any leftover alcohol.
Ever wanted to know how to smell good naturally with natural elements? You can save the earth without offending those around you when you go au natural.
If you've ever eaten a thinly sliced vegatable, there's a good chance that it was cut using a mandoline slicer! Learn how to use this utility effectively.
Get your grout floors looking brand new again! With this tutorial, you'll learn how to remove stains that tend to form on grout.
Extend the life and luster of your copper pots with a few items that are probably in your kitchen. You Will Need
While drywall is an inexpensive building material, it's not the sturdiest. Luckily, repairing the inevitable holes is a quick and easy process.
Grilled pineapple makes a juicy side dish to whatever you’re barbecuing. Step 1: Clean the grill
Your skateboard takes a lot of abuse. A quick check of your board before each ride will keep it in top condition so it doesn’t send you into a “slam.”
Learn to clean your hair dryer filter. You'll extend the life of this handy tool and you'll save money.
Doing the laundry uses a lot of water and energy. Here’s how to wash your clothes with a clean conscience. This video will show you how to conserve energy when doing laundry.