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.
In this clip, learn how to remove a radiator in your home. If you have a broken or faulty radiator that needs to be replaced or are getting rid of the thing altogether, check out this clip from the Ultimate Handyman. In this clip you will learn the essential steps you need to take to remove a radiator from a central heating system and cap off the thermostatic valve, this is important as it is often missed by some people.
Once you have removed your motor and are ready to replace it, you will need to learn how to fit it properly. In this clip, the Ultimate Handyman offers you advice and expertise on how to fit your new motor and get your washing machine up and running like new.
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.
Jennifer DiDonato gives you a delicious recipe to healthy chocolate chip cookies. Rather than taking the approach to deprive yourself until you lose control, replace your chocolate chip cookie recipe with my Double Chocolate Protein Cookies. They contain slow digesting complex carbohydrates, healthy fats, lots of protein, and minimal sugar. Watch this Made Fit TV episode to see how simple they are to bake.
Nick from Greyscale Gorilla shows you a few simple methods to replace a boring sky with one that is more visually interesting. Using various selection tools you can be your own manipulator.
In this video, learn how to crack open, dissaemble and take the back off an Apple iPhone 2G (1st generation). Advice from the Internet: Don't try this unless you have done like-attempts before successfully. It is very difficult to replace an IPhone 2G back cover with a new one, so beware!
This video tutorial from IndyMogul shows you how to build a cheap and portable green screen.
If you're fond of remote-controlled vehicles, you might appreciate this video tutorial on how to assemble a Traxxas high-current connector. To add a high-current connector to your Traxxas R/C model vehicle, you're going to need some pliers, wire strippers, flathead screwdriver, solder and a soldering iron. Replacing the old connector is easy, and will help give your hobby RTR (ready to run) nitro and electric model car or monster truck some life in needs.
This motorcycle parts tutorial shows you how remove the steering stem (fork and triple tree) on a Kawasaki KLR650 bike. If you are replacing the steering stem or just doing work on your KLR 650 and need the steering stem off, this video will show you how to remove the steering stem. Make sure the front wheel is removed before starting.
In this short video Chris Vallone shows you how to remove the generator from a vintage Volkswagen beetle with less hassle. If you own a classic VW bug and need to fix or replace the generator then this tutorial will make it go much easier.
Learn how to replace your Ford Taurus rear brake pads with this instructional video.
How to mount a motherboard into a PC case whether you're building your own computer or just replacing the motherboard.
Perhaps you want to replace the beeswax mouthpiece on your didgeridoo, or you might want to tune your didgeridoo mouthpiece to your preferred size, well here's the full information in order to do so!
Shrimp skewers are delish, and go especially well with some fresh made marinara sauce. But sometimes you want a deeper, richer flavor in the meat itself.
If your car overheats in traffic but not on the highway, you may have a broken radiator fan clutch. In this video you'll learn how to find and fix this problem on a truck, with special consideration for the massive size of such vehicles.
The patient in this auto maintenance video is an 04 Mazda van that surges at idle but works perfectly otherwise. This video will give you a quick tip on diagnosing this idle surge problem before you start replacing parts.
Changing the fuel filter on your car isn't too hard and is great way to save money for the DIY automotive enthusiast. This video will teach you how to replace the fuel filter on a Ford Escape, but these principles apply to most other cars too.
Ford Explorers have a weird problem where the lo-beam headlights won't work even after the bulbs and fuses have been replaced. This is because they draw their power from the lamp out module, and this often breaks. Learn how to fix it in this video.
Fort Triton engine offer a lot of power and value, but do have a tendency to blow out their own spark plugs. Watch this video to learn how you can use a special tool to drill out, re-trap, and install an insert that will fix your spark plugs without having to take the head off the motor.
Replacing the starter on a GM 4.2 might not sound too hard, but it is trickier than it sounds because the starter itself is hard to locate. Watch this video to learn exactly where it is and what to look for.
Everyone is looking for a way to reduce their energy bill when it comes to heating and central air conditioning. The key to a low bill is to make sure your house's system is running efficiently. Check or replace your filters, regularly clean vents and maintain your thermostat at a reasonable temperature.
Cleaning and overhauling each bike company's pedals is different. This video focuses on how to overhaul, clean, and and replace the bearing on Crank Bros bicycle brakes. It features step-by-step instructions and a demonstration, allowing you to spend less money having your bike fixed at the shop!
Misplace your Microsoft Windows Vista Recycle Bin? Looking for instructions on how to replace it? It's easy! So easy, in fact, that this free home computing how-to can present a complete (and somewhat talky) overview of the process in just under a minute's time. For specifics, and to recover your own Vista Recycle Bin, watch this PC user's guide.
Brighten skies with Adobe Photoshop. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which offers a step-by-step guide to enhancing dull skies using Photoshop's various color and contrast adjustment tools.
Spring is a great time to put down mulch. Dave Epstein helps you figure out whether yours needs replacing this spring and, if so, how much to put down. Mulch improves the look of your garden bed, keeps weeds down and keeps moisture in the soil. You want to be careful not to add too much soil as it can keep moisture out and rain or water will not be able to reach the soil.
If you need to align the transmission on your DeWalt DW987 drill, you need to get remove the transmission by taking your time to make sure it stays in one piece. Make sure you have all the gears are together. Line up the slots when replacing the transmission and pull the trigger to make sure you're getting the transmission gears where they need to go.
If your ignition coil is out on your lawn trimmer, you will probably have to replace it. You can easily test the ignition with a spark tester before removing it to see if it is indeed your ignition coil. There are a number of things that can go wrong with the ignition, it can simply just not create a spark anymore or it can be acting up where you're lucky if you get it to start up when you need it to.
If you need to get into your 2nd generation iPod to replace a part or see what is wrong with it. The best way to take it apart is to use a very thin tool, you will see how to take it apart the 2nd gen iPod using a putting knife. Make sure you release all 4 sides of the iPod before yanking it out as you can cause some damage if you do not know what is inside.
Nothing is worse than bed bugs, right? Those pesky little creatures can make you seriously uncomfortable and cost you tons of money replacing furniture. But you can treat your furniture without spending money or having to throw it out. You will need to inspect everything thoroughly and make sure to to follow every step properly. This video will show you how to treat furniture for bed bugs.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deliver a sheet tab name to a cell!
Video games can be quite expensive, especially if you're a serious gamer building up a collection. The last thing you want to do is replace games you've already paid for. Learn how to backup your games so you never have to buy a second copy. This video will show you how to copy XBox 360 games without a mod chip.
Did you know if that if you tilt your XBox machine you can seriously ruin your game discs? Tilting the console will cause grinding, which can make a huge circular scratch around the bottom of your game discs. In this tutorial, learn how to fix your games at home so that you don't have to replace them.
Are you at a Reason/Record dead-in? WonderHowTo is full of tutorials for this recording software. In this Reason tutorial, learn how to replace a drum sample within a recording.
Make a DIY wood sanding block for smooth surfacing with help from this video tutorial hosted by the can-do man, Ron Hazleton.
Mark Donovan of Home Addition Plus goes over the key features and benefits of the Rockwell reciprocating saw with active vibration canceling technology. A reciprocating saw is a type of saw in which the cutting action is achieved with a push and pull reciprocating motion on the blade. A positive feature of the Rockwell is that there are no tools needed to replace the blade and it acts great with all materials including wood, metal, plastic, and/or aluminum.
Lear how to replace your bike's inner tube! Remove wheel from bike. Quick release on front is easier. If you have wheel nuts you'll need some tools. Shift derailler to slack chain, then it's easy. Use a tire lever to take the outer tire. Feel along the tire to locate the puncture site.
Watch this video to learn a simple cheat that will make your paper longer. Good trick to know when you are in a crunch and need to stretch your class paper. You will need to use your existing term paper and either Microsoft Word or Open Office to use the Find&Replace command. Here's some forums you can post anonymously with other like-minded, less scrupulous people: http://academicdishonesty.net
This is a simple easy to follow walkthrough on replacing the Potentiometer on the old Atari 2600 paddles. This is a classic video game console from the 80s. The paddles are the old school controllers for the Atari console.
Get an instant boob job, just by putting on the right bra. Wear a white t-shirt when you go bra shopping (if your breasts look good under a white shirt, they will look good under other colored shirts as well). Learn how to calculate your correct bra size. Minimize the appearance of back fat and accentuate your cleavage. Replace your bras every six months.
