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 332nd installment in their series of digital spreadsheet magic tricks, you'll learn how to insert text into a test string with the REPLACE function as well as how to insert a part of a product ID into a longer product ID.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
Windows 7 has an interesting new feature by which you can pin your programs to the task bar and this video shows you how to do it. In Windows 7 if you have any frequently used program you can improve its ease of access by pinning it to the task bar. Now to do this first open the start menu, go to the programs, and now browse to any program and right click it. From that menu select the Pin to task bar option. When you do this the program icon will appear on the task bar. Now the program is pin...
If your system keeps filling up and won't shut off, you will probably need to switch out your toilet's float valve. Make sure to turn off the water before making any plumbing repairs! Watch this video home improvememnt tutorial and learn how to replace the float valve in a toilet tank.
This automotive maintenance tutorial shows you how to replace worn stock pads and rotors on a 2008 or 2009 Mitsubishi Lancer with Road/Race Motorsports Lancer GTS brake pads and rotors. Whenever you change or upgrade your rotors, you should change your pads at the same time. This video shows how to replace the pads and rotors with RRM pads and rotors but the process will be the same for any brand parts you choose.
Want to fix your guitar all by yourself? Check out this tutorial on how to change an electric guitar neck plate. You can save money on labor and have the self satisfaction of replacing your electric guitar neck plate yourself.
Check out this home repair tutorial video that demonstrates how to fit and replace your Hotpoint carbon brushes in your washing machine's motor. Follow the step by step instructions in this domestic appliance repair video to remove your Hotpoint carbon brushes. Please note that all work should be performed by a qualified engineer. Make sure to take the necessary precautions to ensure a safe removal of your Hotpoint washing machine's carbon brush.
Check out this home repair tutorial video that demonstrates how to fit and replace door hinges to your oven. Follow the step by step instructions in this domestic appliance repair video to replace your cooker's door hinges. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your oven's door hinges.
Check out this home repair tutorial video that demonstrates how to replace your grill element in a Neff and Bosch cooker. Follow the step by step instructions in this domestic appliance repair video to remove your Neff or Bosch cooker's grill element. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your cooker's grill element.
Check out this home repair tutorial video that demonstrates how to replace the thermostat in your oven. Follow the step by step instructions in this domestic appliance repair video to remove your cooker's thermostat oven. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your thermostat oven.
A complete step by step automotive installation video on how to change a '79 F150 truck from drums to rear disc brakes. Disc brakes are newer technology that provide more stopping power and easier maintenance than older drum brakes. If you have a Dana 70 (1979 F150), bring it up to date and replace those old drum brakes with newer, better disc brakes. The guys at Redneck TV will make it easy for you.
This is a quirky little how to video that teaches you how to repair and replace that worn out speaker surround you wanted to toss out or just bought at a garage sale for $1. Get to that yard sale and repair those old worn out speakers and make them worth thousands again!
This tech tip shows how to replace the seat and seat post on your bike.
How to change a bike inner tube using a tire lever. Necessary to replace punctured tubes.
Worn brake pads can be dangerous, and lead to accidents. It only takes a few minutes to replace a set of brake pads on a bike, and it is very easy to do.
Frustrated with your shower's water pressure or leakage? Replace your shower head and make the necessary repairs to make it work more effectively.
Learn How to Install Replace Rear Bearings 2001-05 Honda Civic
DIY Easy ZigZag Square Knot Loops Bracelet with Button Clasp. This is a good project for children and beginners to learn one of the basic knots frequently used in Macrame.
How to Replace The Windshield Washer Bottle Honda Odyssey 99-04
How to Replace Honda Odyssey Rear Brakes 1999-04
This how-to is for those of us who frequently use Google+ to connect with others, and want to have a better looking link for our profiles.
Many people drop their phone, resulting in the dreaded cracked screen. Luckily for you, a few of those people end up replacing the screen themselves, and sometimes they even leave behind detailed instructions on how to do it.
We've all played with bubbles as kids, but I think most would agree that they're not exactly the most functional of objects. An international team of researchers made up of Yoichi Ochiai, Alexis Oyama and Keisuke Toyoshima wants to change that. They've figured out how to project both 2D and 3D images onto a micro membrane (soap bubble) using ultrasonic sound waves and a standard projector. The bubble is made of a solution of sugar, glycerin, soap, surfactant, water and milk. The glycerin and ...
Apple doesn't want you to know how to do this - at least not by yourself - because they can't earn any moolah off of it. But with just a few basic tools you probably already have lying around the house you can remove the back cover of your iPhone 4 easily and then replace the cover with another one of your choosing.
In this video, we learn how to upgrade the hard drive in a Sony PS3 Slim. First, flip the console, then pop the cover and remove the HDD screw. Next, remove the HDD cover and slide out the HDD. After this, locate and remove the four screws, then pop the HDD out of its tray. Next, replace it with a new HDD and screw back into place. Then, place the HDD tray back into its place and replace the cover back on. Screw in the original screw and replace the top back on. Now, flip your PS3 back over a...
If you've been driving a car and constantly hear squeaking all the time, you would be wise to change your brakes. Not doing so can result in more damage to your car's brake pad rotor.
In this video tutorial, learn how to open and take apart & take the back off your iPhone 2G (or, 1st generation) to replace the front screen and digitizer. This video replaces only the front glass and digitizer, while leaving the LCD because it is still functional. The reasoning behind this, is that all three (a new screen, digitizer, and LCD) costs half as less than just a screen & digitizer. This video does not show the installation of the screen & digitizer, but merely how to open the iPho...
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
If you need to repair a broken component in an HTC My Touch mobile Android phone, take a look at this guide for a walkthrough of the teardown. The tutorial specifically focuses on repairing or replacing a glass digitizer that may have cracked or broken and needs to be fixed.
Don't sit around waiting for Apple to release a white iPhone 4! You can replace the front screen and back cover of your iPhone 4 and have the best looking white iPhone before it hits the store shelves. But be careful, after all it is your iPhone.
Replace the rear shocks on a 1997-2005 Chevy Venture, Montana, Silhouette, or Pontiac Transport. Pick up a wrench and get to work, dont hand your car over to some mechanic when you could do the repairs yourself. First, learn how to do it the right way by watching this video.
Keep your car safe for road use by maintaining the brakes. The brakes are the cars most essential safety feature, so don't put off a repair if it's needed. Do it yourself, by watching this video and learning how to replace the front disc brakes on a 2000-05 Chevy Impala.
Visibility is an import part of safe driving. Make sure your car is prepared to handle even the thickest fog by replacing your fog light. Fog light bulbs burn out, the casings can be damaged, but don't let it slow you down. Repair it yourself!
A clean air filter will keep your car running smoothly and efficiently. Replace the air filter yourself after watching this helpful video. Follow the simple instructions and you'll have taken the first step to becoming a master home mechanic. Don't be intimidated by auto repair!
You need working headlights to drive safely. If the bulb in your healdlights have burnt out, or dimmed, or the headlights have been damaged then you have to replace them. You can do so safely at home and save yourself a lot of money.
The side rear view mirrors are one of the most important safety features on a car, allowing the driver to remain aware of his or her surroundings. If your side rear view window is damaged, you need to replace it. Learn how to do it yourself by watching this video.
Get under the hood and get your hands dirty with some home auto repair. This video will explain how you can remove and replace the radiator cooling fan in a 1998-2004 Dodge Intrepid. Once you've watched this do it yourself auto repair video you'll be ready to roll up your sleeves.
Brake repair bills from a mechanic can be unmanageable, so learn how to do this auto repair yourself by watching this video. Using a 2000-07 Chevy Silverado as the example, this video demonstrates how to remove and replace a truck's rear brakes.
Headlights are one of the most important safety features in any car or truck. This video shows you how to replace the headlights and bulbs in a 2002-2008 Dodge Ram truck, so that you won't be slowed down by a broken or burnt out headlight.
