Tearing yourself to pieces trying to format fractions in Microsoft Excel? Give this video tutorial from everyone's favorite YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to format fractional values via the custom number formatting tool in the number tab in the format cells dialog box. This video discusses proper, improper, like, unlike and mixed fractions.
Tearing yourself to pieces trying to solve fractions in Microsoft Excel? Give this video tutorial from everyone's favorite YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to use Excel to add and subtract fractions and mixed numbers as well as how to find lowest common denominators.
Learn how to make traditional maple syrup with expert Bill Hiller. This great tutorial series shows you what to look for in the trees as well as how to process it.
This how-to video will show the proper use of key modulation in music. Follow Andrew Wasson of Creative Guitar Studio as he takes you through the uses of key modulation in music writing. Watch as he explains the difference between direct modulation and pivot chord modulation. Once you know the different types of modulation, you can learn how to introduce both of them to your music writing as you continue growing as a muscian.
Out of all the toys that have existed in the world, LEGOs are some of the most interesting, fun, and creative pieces of building blocks. Not only can they easily be taken apart, but there is no limit to what you can build using these magnificent blocks. This video tutorial will show you how to take some LEGOs to make a nice little table. Enjoy!
This tutorial video shows how to make an origami bird base. As you might guess from the name, the bird base is used when making the traditional origami crane; however, it can be used as a starting point for other origami patterns as well, so it's good to learn how to make this fold. Follow these steps to learn how to fold an origami bird base.
Making your own sausage rolls lets you add the exact ingredients you wish to include. This instructional video demonstrates how easy it is to make traditional sausage rolls using basic cooking equipment. When they're finished, simply eat the sausage rolls with a dollop of ketchup and enjoy.
Ever been interested in drawing a Celtic cross but didn't know how? This step by step instructional video will show you how to create a drawing of a Celtic cross and all you will need is a piece of paper and a drawing utensil like a pen. It shows you how to create the basic shape of the cross and then takes you through decorating the surface with the intricate Celtic designs and knots.
Going to the salon to get bangs and layers can get expensive, so this video shows how one girl transformed her hair from all over length to having swooping bangs and face framing layers. To create this look, she separates out her hair and uses hair scissors to cut small pieces at a time to achieve the desired style. This is not aimed at being a how-to video, but this is a good one to watch if you are contemplating cutting your hair at home.
If necessary, cut kimchi into desirable size (about 2-inch lengths) Cut green onion into 2 to 3-inch length pieces
This video demonstrates a project taken from "Make" magazine. Viewers will learn how to modify an ordinary computer mouse with a vibration unit for use with PC games, similar to the rumble controllers sold for video-game consoles, to make gaming more fun.
>1 Cut a piece of a chain about two inches long. >2 Open a jump ring with pliers and attach it to your charm and then close it with a pair of pliers.
Using a potato peeler on ceramics is fast, simple and gives your piece a unique look. While your pot is still soft, take a potato peeler and "peel" your pot in small sections working around the pot. You don't want to press too light or too firm, it might take some practice. Keep your cuts random to add to the charm.
If you've ever attempted to remove Cydia apps from your iPhone or iPod Touch using the traditional long-touch method, you will have quickly discovered the Cydia-distributed applications have no 'X' to delete them. Watch this short video to understand the correct way to remove Cydia apps.
If you're feeling particularly handy, you can try using this video to fix a jammed iPhone power button. In it you'll learn how to completely disassemble and then reassemble your iPhone. If you've got the right tools lying around, you might just be able to save yourself a lengthy repair with Apple. Make sure to pay attention, because there are a lot of little pieces. Good luck!
Learn how to make homemade pendants! It's quite the process, involving a piece of glass (frosted glass with bevel edges is best), Fantasy Film, opals for embossing enamels, and a pool of hot glue. If you want to learn how to make dichroic carnival glass pendants with Fantasy Film and colored opals, then just check out this video tutorial.
A jigsaw is a powerful piece of equipment, and it can make your home repair projects go a lot faster. But what should you look for when buying a jigsaw? In this tutorial, Mark Donovan of HomeAdditionPlus.com explains what you should look for when you are going to purchase jigsaws and jigsaw blades.
In this video tutorial, you'll see how to make a magic wand illusion. It's not a complicated process, and the tools and pieces are things you might already have around your workshop. With just a little work, you'll be able to baffle and amaze your audiences with this simple trick!
The Judo throw became one of the most famous judo moves for a reason. Done right, it is a devastating (and very cool looking) maneuver. In this tutorial, Judo Black Belt and BJJ Brown Belt Mark Massey teaches us the Kuzure Osoto Gari (and the more traditional) Osoto Maki Komi throw.
Need a use for a model tooth? Learn with this "Tooth Carving 101" tutorial how to carve a fake tooth from a bar of soap. One will need a small carving knife, a bar of soap and about thirty minutes. Your fake tooth with make for one heck of peculiar mantel piece.
"Lego Racers" was a 1999 video game where players could assemble their own go-karts using virtual Lego pieces and then race them. This short video employs stop-motion animation to show you how you can use Legos to make a toy go-kart for Johnny Thunder, one of the game's characters.
If you grew up playing the video game "Lego Racers" you probably wished you had some of those Lego go-karts for real. This short video uses stop-motion animation to show you how you can use some of those old Lego pieces under your bed to make a toy go-kart for Gypsy Moth, one of the game's characters.
Cheap method to create your own neat looking CD cases! Instructions on how to create cover for cd disc from A4 piece of paper.
Learn all there is to learn about gardening from Naztazia... watch this video tutorial to learn how to start a basic container garden.
This is the tutorial on how to perform the Straw Thru Neck trick. You need to slide the straw between your fingers to hide it. Then you need a small piece of straw to keep on your tongue to show it went through your jaw. This is a classic kids' trick.
Learn how to display canapes artfully and elegantly. This is a great piece of information for making your appetizer exceedingly impressive to guests. This elevates the dish to a caterer's status of presentation.
Use this quick and easy tip for chopping sticky dried fruit. The dried fruit can often stick to itself and become very difficult to chop into distinct pieces. This is important for baking cakes or other dessert recipes that require the ingredient.
Loop here, and then there, and then here again. It's easier when you watch it. Pancetta is pork tied and roasted. Tying pancetta is a complex process. Spread with pepper corns. You will use a butcher's knot to prevent it from untying. This rolls the pork before you cook it.
Learn how to make roux. A roux is the traditional French way to thicken and enrich gravies, sauces, and soups. The technique dates back more than three hundred years. To make roux, you'll need flour, clarified butter, and a whisk.
Learn how to fold an origami camel. All you need is a piece of paper. Follow along with this origami demonstration, the process is fairly simple. And the result is pretty impressive! Fold an origami camel.
The traditional "French Drop" vanish is commonly known around the world to magicians, but the "Hebrew Rise" manifestation is not. In this magic video tutorial, see how to perform a French Drop vanish and Hebrew Rise trick, the re-appearing act after a vanish coin trick involving sleight of hand.
This is a tutorial on how to make a $2.00 didgeridoo. This musical instrument is made Redneck style out of ABS pipe. The Digeridoo is an Australian wind instrument. This one is a non-traditional plastic version.
This is a video tutorial on how to assemble K'Nex quad or ATV vehicle. He gives you the list of different Knex parts you need with quantities. This is a simple assembly, with a time lapse of how to put each piece together.
Using a 3/4 inch Hot Tools curling iron, Biosilk & blow dryer for this sheik Beyoncé look. Section off hair to make sure you get every piece. If you try this look, always hair spray before wrapping the hair around the curling iron. After you're done, use some sculpting wax by Pantene to smooth it out & keep it in place.
Kick the habit with a video tutorial that will teach you how to perform the Pendulum freestyle trick with a footbag. Yes, footbag is gaining popularity throughout the world, either by freestyle footbag, footbag net or circle kicking. The only piece of equipment needed to play is a footbag, otherwise known as the hacky sack. Just make sure you get the right hacky sack for the job and watch to see how to perform the Pendulum freestyle trick.
Kick the habit with a video tutorial that will teach you how to perform freestyle leg over tricks with a footbag. Yes, footbag is gaining popularity throughout the world, either by freestyle footbag, footbag net or circle kicking. The only piece of equipment needed to play is a footbag, otherwise known as the hacky sack. Just make sure you get the right hacky sack for the job and watch to see how to perform freestyle leg overs.
Who’d have thought that crumpled paper was good for anything but the trashcan? With this easy technique, you can transform tissue paper into pretty pieces of art. This is a fun kids craft project. You will need cardboard, double sided contact paper, tissue paper, and scissors. Fun activity to do with kids!
The Hundred is a classic piece of pilates that’s not only great for your body, but is as easy as one, two, three…
Homemade cookies are a terrific gift. With a simple bakery box and some ribbon, the package will be as pretty as the contents.
This is an instructional video featuring Doug Prime, founder of the Future Engineers Center at the University of Massachusetts Lowell. Aviation snips are good for cutting small metal, but nail and steel rods require bolt cutters. Use safety glasses and clear the room as pieces could fly. Stand up as bolt cutters require strength and pressure.
