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.
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.
There are things that you should keep in mind, if you want to learn to milk cows. Clean the teats, before you begin. To milk the cow manually, squeeze the teats and draw your hand downward, at the same time. Squeeze and pull down, until there is no more milk. Cows have to be milked at least a couple of times a day.
Go thrifty! Go vintage! Go second hand. With the right approach and an open mind, a trip to your local thrift store can yield some fashionable bargains. Buying used is a smart solution to this economy, and gives you a smart sense of fashion.
Though you may scrub every inch of your kitchen, there are plenty of trouble areas that are nearly impossible to get clean: gunked-up tile grout, rust in the sink, and caked-on burners and grates on the stove. As far as burners and grates go, you're in luck, because there's a simple solution to returning even the grossest ones back to their original shine. The Key Is Ammonia
A lot of things come into contact with our keyboards throughout the day: dirty fingers, food, beverages, dust..they are full of germs and crumbs of who knows what. In this 4 part tutorial, learn how to take your keyboard apart and clean it completely. This process should bring your keyboard back to its original glory. So, follow along and clean up your workspace.
Babies are pretty adorable, but the many disgusting fluids they intake and excrete make cleaning up after them a nightmare. If you're a new parent, watch this video. It will show you how to use all sorts of cleaning products to clean up different kinds of baby stains, from drool to baby formula to "mystery stains".
Microwaves have the annoying tendency to absorb the smell of the foods that are cooked in them. Although most people do not mind this on the day of the cooking, after a week of the smell, it begins to get old. If you want to remove that fishy odor, just follow these simple steps. First of all, make sure that the microwave is as clean as you can get it with regular cleaning supplies. Getting rid of the smell will be so much easier if there are no splatters covering the inside of the microwave.
Riding a skateboard can be a blast, but not when your skateboard gets hard to handle because of dirty bearings. Here's how to keep them clean. Watch this video to learn how to clean skateboard bearings.
Watch as a window-cleaning professional demonstrates how to clean your exterior windows, including how to prepare and effectively use your squeegee, in this free online video about window maintenance.
The basic idea of cleaning laminate floors is to use a dry or damp mop or cleaner for cleaning spills and as little moisture as possible. Laminate floors are resistant products and are made to last, but they also are sensible to moisture and thus it can produce damage. Also very important for defending against stains like tomato sauce and red wine is to be vigilant and clean them immediately. The longer a stain like that sits, the longer it is the probability of being permanent, so the best a...
Spills happen in the kitchen, and while every good cook knows to clean as you go, not every cook has an endless supply of cleaning materials. Besides, one spill can exhaust your entire stockpile of sponges, paper towels, and rags in a matter of minutes. Particularly egregious mishaps can make everything they touch feel sticky and gross.
It's very important to clean your make-up brushes so now and then. This video shows you how. Every day- wipe makeup brushes off on clean old towel
If you are looking for professional window cleaning tips for residential window washing, our expert is here to show you how to wash windows in this free house cleaning video series.
Cleaning and repairing clothing by hand is a great way to save money and keep clothes lasting longer. Learn how to clean clothing and sew basic clothing repairs with tips from a tailor in this free clothes care video.
Dry cleaning is an easy and convenient way to get your suits and dress clothes clean. Learn how your high end garments get cleaned from a dry cleaning specialist in this free dry cleaning video series.
Non-stick cookware is a great way to cook and not have to deal with foods that stick to regular pans or deal with the cleaning up after cooking. A few rules to keep in mind are to not preheat a non-stick pan and do not use a heat level above medium. If you break or damage the surface of the pan, it could cause more damage than you think. There have been reports where you could develop flu-like symptoms just from cooking with a bad pan.
In this how-to video, you will learn how to divide and re-plant irises in your garden. First, dig out the iris. Clean out the old, dead leaves and take the dirt off. Trim the leaves off as well. Break off the pieces, as these can become a new plant to grow. Several pieces can be broken off, allowing you to grow even more irises. Discard the part that is left over. You can save the pieces for a little while, but it is better to plant them soon. Irises do not require a rich soil to grow, so kee...
This how to video, made by Teddy Bear Pools & Spas, demonstrates how to clean in-ground pool DE filters. Cleaning the DE filter on your in-ground pool helps your pool run more efficiently during those long summer months. Watch and learn how easy it is to clean the filter with water and cleaning solution.
This how to video, made by Teddy Bear Pools & Spas, demonstrates how to clean above ground pool DE filters. Cleaning the DE filter on your above ground pool helps your pool run more efficiently during those long summer months. Watch and learn how easy it is to clean the filter with water and cleaning solution.
This is a great tutorial on how to use Sensor-Film to clean a DSLR camera's sensor. You won't believe how easy it is and how clean the sensor gets. Everyone should do this for clear and pristine photos.
If you don't spend the time cleaning your house regularly to keep it within reach of clean all the time and you need it to be clean fast, watch this video. It will teach you how to quickly and effectively fake clean a house if your parents, significant other, or other figure your want to impress is coming over.
Keyboards get really dirty from your hands, food, spilled drinks, pens, pencils and everything else that winds up on your desk. This video will show you a great way to clean you white Apple keyboard (wireless or wired) so that it shines like you just bought it. All you need is a handy cleaning product called Mr. Clean Magic Eraser. This will get all of the dirt off of your white keys that come with Mac computers. Make sure to clean the keys and the inside between all of these keys as well. Ma...
Tidy desktop, tidy mind. Wish your Apple Mac OS X desktop were cleaner than it presently is? Straighten things out with this guide. It's easy! So easy, in fact, that this home-computing how-to from the folks at Butterscotch can present a complete, step-by-step overview of a number of different housekeeping methods in just over two minutes' time. For detailed instructions, and to get started tidying your own Mac OS X desktop, watch this free video tutorial.
You can clean your laptop or computer screen in under a minute with no problem. To clean your screen you will need some anti-static cleaning spray to clean the screen. This spray doesn't cost very much. Spray some of the cleaning spray onto the screen. Use a clean soft cloth to wipe the screen dry and get all the dirt and grim off of the computer screen. When you wipe it down make sure that you are very gentle. It doesn't take much pressure to get the screen clean.
This how-to video is about how to speed up the computer by cleaning the fan.
Planning a hunting trip sometime soon? Become a hardcore hunter by killing & cleaning your game out in the wild. In this two-part tutorial, learn how to clean (or butcher) a deer when camping outdoors.
Learn how to clean a cassette player. Cassette players may be outdated, but if you've still got tapes, you're going to want to keep them in good condition.
Despite your best efforts, do your paintbrushes always end up too stiff to reuse? Keep them forever with these cleaning tips. You will need water, a clean rag, a paintbrush comb, a clean container, liquid fabric softener, a rubber band, and a ruler. Watch this video interior design tutorial and learn how to clean latex paint off paintbrushes.
This eleven-part video tutorial discusses how to drain and clean a hot tub spa. It goes over the process step-by-step from turning off the circuit breaker to restarting the spa. It also gives helpful tips on cleaning the tub, working with spa chemicals and avoiding air locks that will make the process a lot more smooth sailing even for a novice spa cleaner.
Are you sick of spending a ton of money on not so great cleaning supplies? Well, if cleaning the screens around your home are the problem, check out this tutorial. In this video you will learn how to make a super effective cleaning solution for your TV, PC, laptop, iPod screens, etc for about a dollar! This couldn't be easier to do, and your screens will be clear and shiny in no time.
To follow along with this video, you will need a few supplies: a spray bottle filled with lukewarm water, a couple of clean white blotting towels, and a product called Legacy of Clean. To remove the stain you begin by applying a few drops of Legacy of Clean onto the stain. Use the blotting cloth to agitate the product into the carpet fibers by rubbing it a bit. Then find a new clean spot on the towel, place it over the stain and apply pressure from your fist to blot the stain. You will see th...
In order to clean your fish tank, you will need the following: a bucket, water conditioner, aquarium salt, a clean filter, a suction tube, and clean fresh water.
We all want to spic and span our kitchen countertops, our tile floors, and our bathrooms. But for the most part we can bet you've been unwittingly using storebought detergent cleaners or bleach. While these cleaners are in fact excellent at removing grime and buffing your dirty floors to a Midas touch perfection, they also come filled to the brim with known cancer-causing agents, synthetic chemicals, and other gnarly, hard to pronounce crap.
This video shows you exactly how and what you need to know to clean your vintage moped carburetor. You'll get a quick overview of the mopeds workings, everything you need to do to make sure you keep your moped in take and give it the proper maintence it needs. Vintage bikes tend to build rust and water which you'll need to clean out to make sure your bike runs perfectly. This is an quick and easy fix to upkeep your bike and make sure it remains nice and clean.
It's time to lubricate your Rubik's puzzle, so how do you do it? Erno Rubik designed these puzzles to be solved, but every once in a while it is necessary to take them apart, either for cleaning, lubricating or for replacing game parts.
Paintball gets messy. Keep your gun clean, and you'll have a better chance of staying clean yourself, because a clean gun means a more effective gun. This video will show you how to take your paintball gun apart, clean each piece, and put it back together.
In this how-to video, you will learn how to clean your car paint with a clay bar. This will help you clean contaminants, bug parts, and other debris from your paint. First, you will need a car to clean, a clay bar, and a lubricant for the clay. Split the clay into a smaller piece and mold into a bottle. Spray the lubricant on the area you are going to clean. Move from left to right and up and down over the section two or three times with the clay. Once this is done, wipe off the lubricant wit...
Are you sick of your dogs bad behavior? Such as chewing your furniture, bothering you while eating dinner, barking incessantly, and even stealing your slippers! Dee Hoult shows us how to properly use the 'Kong' toy to prevent all this undesirable behavior. It's simple, you just fill the toy with your dogs regular dog food, soak it with water, and put it in the freezer for 1 hour! Then you give your "Kong Pupsicle" to your dog, who will play with it for 30-45 minutes, getting the food out of t...
Maybe one of the hardest jobs you can do around the house is cleaning the gutters. When cleaning the gutters by hand, you have to constantly keep moving the ladder to get to the various spots of the gutter which contain a mess. If not done properly, the gutters can get clogged, which will not help the appeal of your home. This video explains a simple and easy way to clean the hassle-prone gutters. The powerful leaf blower makes cleaning the gutters simple and easy. Just make sure to keep your...
