The Motorola Droid is the reigning king of the Android family, but it's getting a little old and you're probably looking for a way to improve your phone's performance if you own one. Why not root the dang thing and install a custom ROM on it so it'll at least be organized the way you want it to be! This video will show you how to install custom ROM's (basically phone UI's) on a rooted Motorola Droid phone, allowing you nearly limitless customization options for your awesome phone. The ROM in ...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
First, you will need a gallon of milk that's about a quarter full. It's best if you empty out the contents, but make sure to save it though because you will be needing it later.
In a previous Nurd Rage video (here), Dr. Lithium showed you that pyrolytic graphite was diamagnetic, and that it could be stably levitated over magnets. It was repelled by a magnetic field, and this repulsion was strong enough to levitate it. In this science video tutorial, you'll learn how to levitate plain old pencil lead this time.
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
The Stirling engine is a relatively old type of external combustion engine that has never really found a niche despite its unique advantages over conventional internal combustion engines. This video for the DIY-inclined will show you how to make your very own small Stirling engine out out of a tin can and some other basic materials. It may not power your house, but you will be able to amaze and educate your friends with this awesome little device.
There's a reason witches are a timeless costume costume choice worn year after year on Halloween. They're sexier than fairy costumes and far more lurid than ketchup bottle costumes.
With thousands of beauty companies out there, we can generally find at least one lipstick shade that makes us look more dazzling than New Year's Eve. But sometimes, whether you need to match your lipstick to your dress or just can't seem to find The One, you need a specific color that no brand carries.
ThreadBanger demonstrates how to make recycled bleached skinny jeans. First, put on the jeans and if they are too big, pinch them at the back and mark them with tailor's chalk. Fold under the jeans at the bottom and mark the desired length with the chalk. Open up the seam of both pant legs with a seam ripper. Seam rip the back part of the jeans and the top band. Cut along the chalked lines. Redraw the seam and pin the pants. Sew along the chalk lines. Use pinking shears to cut away the excess...
Remember Michael Jordan? He may not be in the news as much today, but he's still one of the greatest basketball players that ever existed — nobody can doubt that. Professional basketball just isn't the same without MJ, but if you'd like to see him in action again, all you have to do is prime your pencil and pick out your paper and DRAW!
In this Music & Instruments video tutorial you will learn how to change the nylon strings on a classical guitar. Take the peg winder and unwind all the old strings. Then unravel all the strings from the bridge. Make sure the bridge doesn’t fall off. Take a new string and insert the finished end in to the sixth hole passing it from the hole of the guitar towards the end of the body. Then tie a knot and pull the string tight over the bridge as shown in the video. Now pass the unfinished end o...
Head lice can be a nasty, unwelcome visitor in your life. And if you have children, you're likely to be confronted with an infestation sooner or later. Dr. Su Laurent explains that getting rid of head lice can be a tricky undertaking, but the most important thing is to be persistent. You'll need to wash the hair with the latest lice treatment available, as the lice may adapt to chemicals from year to year. It's very important to follow up this treatment at least one more time, seven days late...
It only takes 15 minutes to install new RAM in a Macbook Pro. Before starting, remember to make sure that the power is off. Turn it over and release the latch in the left hand side. This will release the door and expose the battery. Remove the battery. With a #00 Philips screwdriver, remove 4 small screws lined up on the top of the opening. Next, remove the other 4 screws on the other side next to the hinge. When that is done, remove the cover. You will see the RAM directly in the middle. On ...
To install a hard drive in a 13" (13 inch) Macbook Pro laptop computer released in 2009 you will make sure to first transfer all data off the drive then discharge any static electricity from your hands making sure your are in a static free work environment. Next you will remove the old hard drive, to do this flip over the laptop and remove the 10 screws around the edge of the device with a #00 Phillips screwdriver starting with the three longer screws on the top right. Next, lift off the bott...
In this how-to video, you will learn how to install a hard drive into a 17" Macbook Pro. Make sure you use the proper anti-static precautions before going on with this procedure. You will need a pry tool, a Phillips screwdriver, and a T6 screwdriver. Make sure you transfer your old data into the new drive before installing. Shut down the computer and flip the laptop over. Unscrew the ten screws around the bottom. Now, remove the cover. You will see the hard drive at the lower right. Loosen th...
This video tutorial from iDeviceTutz shows how to change the SSH root password for iPhone or iPod.When iPhone or iPod is jailbroken it sets its password to default - alpine.Thus your device becomes vulnerable from a network attack that could steal your information or identity. So you need to change your password as soon as possible when your device is jailbroken.For this you'll need Mobile Terminal program on your device and SSH client (Cyberduck or WinSCP) on your computer.First download and...
This video from OWC presents how to install memory in a 17" Macbook Pro.The operation will take about 15 minutes and doesn't require an experienced user.First you need to provide all necessary anti-static precautions - discharge static electricity, use static-free surface.You'll need #00 Phillips screwdriver and nylon pry tool.You can find these in the Newer Technology 11-piece tool kit.To start, shut down the computer, close it and flip it over.You will need to remove 10 screws. Use #00 scre...
Kim Perrin a certified mechanic shows how to do your own oil change. To accomplish this, you'll need oil, an oil filter, an oil filter wrench, and a ratchet.
In this tutorial, Betty offers us the recipe for one of her favorite and healthy snacks, granola bars! Granola bars are easy to make at home and are a wonderful snack and substitute for junk food.
Wow! Watch as the talented make-up & hair extraordinaire, Kandee Johnson transforms herself into 80's rocker, Cyndi Lauper and proves that girls just want to have fun! By following this tutorial, you might just win next year's Halloween costume contest!
Is your hatchet in need of a quick tuning? Doesn't quite get the job done anymore? It's time to sharpen it. This also applies to sharpening an axe.
Systm is the Do-It-Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. They will help you avoid pitfalls and get your project up and running fast. In this DIY episode, see how to build a firewall from a junk PC to protect networks.
Grand Illusions is a site for the enquiring mind. This how to video demonstrates how to make Folded Page Art. Your wonderful & charming host represents Grand Illusions, an amazing toy, magic & illusion web shop and gallery.
Watch this video tutorial from the Polish Guy to see how to clean a car taillight with Autosol Polish. In this demonstration we use Autosol Polish to clean and restore a car tail light. The tutorial includes detailed work instructions and best practices.
This origami video tutorial shows how to make a box with a lid out of two sheets of paper. This fold makes a great gift box for small presents. This is relevant with the upcoming holidays like Christmas, Hanukkah and Valentine's Day all around us. It's also a good idea for adding a personal touch to a birthday present or to hold a first year anniversary gift... (the first year is paper guys).
Watch this video tutorial from the Polish Guy to see how to polish and restore a brass lamp font with Simichrome Polish. In this demonstration tutorial we use Simichrome to polish a piece of brass. The tutorial includes a detailed work instructions and best practices.
All you science and astronomy nuts out there, pay attention, this detailed video tutorial series will tell you everything you need to know about using the Meade EXT Premier Telescope to ogle the universe.
Take your old electronics and make them scream with glitchy goodness. This an extremely easy project and makes a great project for first-time solderers. Circuit bending involves taking electronic devices that make multiple sounds and wiring in switches to set off glitches or loops. Using an out-of-tune toy, the first part of this video series demonstrates how to apply a basic pitch bend using a potentiometer. In the second part, you'll learn how to bend the same toy by applying body contact. ...
Here is a step by step tutorial for making a swimmable mermaid tail. Check out Video #2 for a demonstration of the tail in use!
Losing your important data can be more painful than losing the hardware the data was stored on. Precious memories, files you don't often access but always want to have, there's so much you store on impermanent devices that you can't live without. Backing up your information to a secure, cloud-based location is the best way to stave off disaster here. Polar Backup Unlimited Cloud Backup Storage will give you an unlimited amount of cloud storage while making the process super easy.
The still-unfolding story of China's Nreal augmented reality startup continues to develop, with each turn uncovering another unexpected wrinkle.
For the first time in a while, the battle between Samsung and Apple is really interesting. Unlike previous years where the choice for smaller hands was limited to the Galaxy S series, this year, there's an option for Galaxy Note users. Both sides of the aisle have their best options in years with minimal sacrifices.
Samsung has just announced the Galaxy Note 10 and 10+. These are the latest and greatest from the largest smartphone OEM in the world. Plenty of numbers and specs have been thrown your way to showcase how good the Galaxy Note 10 is, but we wanted to simplify all this for you and key in on the most important things.