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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.
In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...
Ever wonder how to make your very own faux night vision goggles? Well, Mr. G shows you exactly how to make your own night vision "glasses". Step by step, soley using household products. This experiment is just too good to be true. A foolishly easy experiment that will make you laugh and cry at the same time. This video is just for fun, don't let it fool you!
Watch this video to learn how to make glow in the dark goo with household products. Add 1 teaspoon of Borax to 1 cup of warm water. Add 1/2 tablespoon of Glow powder and mix for 30 seconds. Pour the contents of a 4 ounce bottle of glue into a measuring cup, fill the container with water to get all of the glue out until you have 1 cup of water and glue, then mix with a whisk. Add the Borax to the mixture and add color mixture (any) too. Play with the goo to mix the color and add to a light to ...
Here is a series of hot and complex sexy salsa dance patterns. This is a more complicated salsa pattern. It is a very long pattern, so take it in strides and small bites. We have named the individual moves to help you piece the entire salsa combination together.
Do Try This at Home brings us video on how to create a cloud in a container. With just a few simple items household items we can create a cloud. He explains to us the science behind what he is doing and why is works the way it does. After that he demonstrates how to create the cloud with quite amazing results. He easily has created a cloud and suggests that we try this at home because it much easier to see and enjoy in person.
This video explains how to keep a dog calm and to be less reactive to objects that it is not used to including baby strollers, hats, canes, and a few other items. Starting with a few tips on how to get a dog used to the item in question such as keeping a leash on the dog and far enough away from a person the dog trusts and loves so that the dog will associate the object with a person. There are many aspects when training a dog in this way and each method can be tried if one does not work. Aft...
Perhaps you've already learned how to make the standard origami ninja throwing star, and you want to take it to the next level. You want something that really flies, and has enough heft to knock over lamps in your living room and cause other sorts of property damage. Well, the ninja star frisbee - or super shuriken - is the project for you. Made of six small throwing stars folded together into one big flying lump, the super shuriken is origami with a bad attitude. It is also potentially dange...
What's a proton pack without a ghost trap? Useless, that's what. Don't pay megabucks for some fake Ghostbusters costume when you can build your own with household materials.
Liven up your parties by making your own fog machine, using items that you can find around the house.
How to use a can opener with one hand or without a prosthesis. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. This trick is important to ensure healthy living and daily tasks like opening food in the kitchen. Live without limits!
A below elbow arm amputee demonstrates how to tie a shoe with his prosthetic hook. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. The prosthetic arm outfitted with a hook or hand can be body powered or myoelectric. The operation is important to ensure healthy living and daily tasks like dressing yourself.
A below elbow arm amputee demonstrates how to turn a car key with his body powered prosthetic hook. This adapted equipment video is helpful for handicapped, disabled or individuals whom have lost limbs due to amputation. He's using a prosthetic arm outfitted with a hook to start the ignition of his car.
A below elbow arm amputee demonstrates how to hold and use a knife with his prosthetic hook. This is an adaptive living video that helps handicapped, disabled or individuals that have lost a limb due to amputation. Using a prosthetic hand or hook can be challenging in the kitchen. Using a hook to hold and use a knife is an important skill to learn when using prosthetic limb adaptive equipment.
Craving authentic Indian food? Then tune into this cooking how-to video with Manjula. Follow along with this Indian cooking video lesson as Manjula shows you how to make besan ladoo. Besan ladoo are traditionally served as cookies in Indian households. Try making these cookies at home.
This audio editing software tutorial will show you two different types of editing in Logic Pro. First, Connor Smith shows how to edit multitrack drums in a group (to fix timing of hits) in Logic Pro. Then he covers how to ungroup your drums and take out pops, clicks (etc.) on individual drum tracks in Logic Pro.
This science video tutorial includes step-by-step instructions for extracting DNA from wheat germ, the embryonic plant attached to the wheat seed. Individual wheat seeds, or kernels, separate readily from the plant. This kernels have a tough outer coating called bran. If you want to know more, just watch this science experiment.
The iPod has become a common household item. With each new release, the iPod comes with more features, a steady progression from music to videos, and now as a phone. But did you know that there's a way to turn your iPod into a remote control? Take a look at this instructional video and learn how to give your iPod remote control features with some internal tweaking. You need a Logitech bluetooth wireless set in order for this mod to work.
Turn a household item into an awesome hiding spot in just minutes! This video tutorial will show you how easy it is to make a peanut butter safe. Just make a hole in peanut butter jar, put a plastic cup on in, and trim the cut neatly. That's it. Follow the instructions in this how-to video, put your valuables inside, tighten the lid, and nobody will ever find them, unless of course, they are hungry for a peanut butter and jelly sandwich.
You can give your song texture by adjusting individual tracks to become louder and softer to emphasize particular moments. With GarageBand, this process is easy and yields professional-sounding results.
You already know you can create photo pages by selecting a photos template and dragging in individual photos from your iPhoto library. Now there's an easy way to add entire photo albums to your site, each with their own dedicated photo pages.
Just like in the Spy Kids 3D movie, US soldiers may soon upgrade their mission planning from 2D to 3D. Welcome to the wonderful world of augmented reality, US Army.
The video shows us how to create bevels in Xara web designer. Firstly using the rectangle tool hold down the Ctrl key to create a square. The problem with the Xara web designer is that it hasn't got a convert to edit the shape features which actually means that you cant select individual nodes with the shape editor tool which may create some other line. However you can select individual nodes by going to arrange/combine shapes/add shapes with selecting the rectangle. And by doing changes the ...
Kip "Kipkay" Kedersha is known for his intriguing and clever how-to and prank videos, even when he teams up with MAKE Magazine. He will show you how to tweak, hack, mod, and bend any technology to your hacking needs. No electronic device, gadget, or household item can stand the test of Kipkay's hacks and mods.
If we had the time, we would totally make all of our own Valentine's Day cards. But if you have kids, then you know that crafting 36 individual cards for each student is more than a pain in the behind.
This tutorial assumes you've already set up your Facebook account, and are looking for tips and ideas on how to create a profile. Create a page for yourself, your business, your favorite group or any other organization you want to spotlight.
The wonderful thing about a "farmhouse brunch" theme is that most of the materials you'll need to decorate are natural and quite affordable. From sprigs of flowers to brown string to burlap, you probably already have most of the things you need lying around the house.
This tutorial shows you how to make chainmail following the tradition European four in one method. You'll need many small metal rings of uniform size and some metal pliers (work gloves are also recommended!) Afer you make each individual unit, you're also shown how to bring them together in a larger piece.
Want to create your own camera? The simplest one that you can create is a pinhole camera which can be constructed from everyday household items.
One of the most important lessons to teach your dog is simply to teach him to recognize his name. Usually dogs will pick it up within a few days if you use it often, but other times, depending on the dog, it's not as easy.
How cool are smoke grenades? You toss 'em into the air and they explode into a vision of thick clouds and smoke, preventing your enemy from seeing you as you stealthily sneak past him and shoot him upside the head with a paintball gun.
Access your favorite FM radio station with your Motorola Q! This tutorial also shows you how to load your favorite music onto your cell phone, and then choose segments to turn into ringtones, which you can personalize further by assigning them to individual callers.
The new version of Microsoft Office has a feature which allows you to batch create PDFs. You can easily convert whole folders or specfic selections of Word, Excel or PowerPoint files into PDF files. You also have the option of converting the files into individual PDFs, or turn them into one large file.
This prank is simple, creative, easy to set up, messy and embarrassing. Five of the first things that we at Wonderhowto look for in a prank. All you need are some basic household materials:
Not everyone has the "Sun" or "Apollo" line on their palm. For those lucky enough to have it, such a line indicates many potential gifts and popularity! Watch this video as Jim Winters explains how to identify the Sun line and what it indicates for the individuals who have them.
Seriously gals, how easy is this? Unless you're a bum living in a box under a bridge, you can probably muster up the simple tools needed to make this makeup organizer. All you need is Elmer's household cement and six office stamper covers.
In this video, learn how to decorate beautiful cupcakes that are perfect for spring or summer parties. These little cakes look exactly like flower pots and in this tutorial, you will get a step by step walkthrough of the decorating process. These unique and delicious cakes will make a great addition to any table.
School's out! What better time to find fun things for the little ones to do than summertime? One fun and timeless outdoor activity is blowing bubbles.
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 357th installment in their series of digital spreadsheet magic tricks, you'll learn how to pull data from individual sheets to a single master sheet given improper data setup.
Every new pair of ballet shoes needs their elastics sewn on to fit the individual personally. In this video, learn a few tips on sewing in the elastic and satin ribbons with help from a ballet expert: Lynda DeChane-Audette is the founding artistic director of the South Florida Ballet Theater and was born in Boston. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!