Perfectly Crafted Search Results

How To: Replace a damaged power cord on a Hitachi circular saw

Have an old power tool that works perfectly fine except for the fact that the power cord is shot or maybe you just bought a brand new power tool and accidentally cut off the cord? You're in luck because there is a way to replace that damaged cord. You'll need to take the part off that encases the cord on your power tool, in there you will find the switch the cord is connected to and connect your new cord to it.

How To: Create random basic math problems in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use custom number formatting with zeroes in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up data from different Excel tables with INDIRECT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Create a macro & assign it to a form button in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assign the macro to a form button. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Change an Excel table's conditional formatting with DV

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Easily measure waist size

If you are looking to purchase a new pair of pants or suit, you will need to know how to measure your waist size. In this quick tutorial, learn exactly how to use a piece of measuring tape to take your measurements and ensure your new outfit fits you perfectly.

How To: Perfectly roast vegetables

In this CHOW episode, learn how to roast delicious vegetables with Lisa Jervis, cofounder of Bitch magazine and author of "Cook Food: A Manualfesto for Easy, Healthy, Local Eating". Learn how NOT to roast your vegetables to get a dish full of mushy veggies that taste more steamed than roasted.

How To: Steam broccoli in the microwave

Do you not have a steamer? Or time to wait as your vegetables steam? In this video you'll learn how to steam your broccoli in the microwave. Quick and easy in the microwave to immediately serve and enjoy on their own or with any meal. Yes, the microwave will produce some perfectly steamed greens, with a pinch of salt and maybe some butter.

How To: Steam delicious broccoli

Having a hard time getting your broccoli steam just as you please. This video shows you how to steam your broccoli just right and perfectly soft to enjoy with your meal or on there own. You'll see exactly what you've been doing wrong and how to fix it to enjoy your steamy greens.

How To: Cover a square dummy cake with sugarpaste/fondant

Dummy cakes are for stores & cake decorators to show off their designs without the worry of a falling cake or cake spoil. In this tutorial, learn how to perfectly cover a dummy cake (made of styrofoam) with sugarpaste or fondant icing. With a little practice, you'll be covering your cake with no wrinkles or tares in no time! Follow these simple steps to get this practice down.

How To: Learn different key harmonicas

More often that not, beginner harmonica players will have to be told the key to use during a jam session. It's perfectly reasonable to ask the key, so long as it's before the song starts that you're asking. But if the answer is obvious, you're better off knowing than asking. You don't want to look silly by asking obvious questions. This video will show you to know the key without asking.

How To: Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.

How To: Style crossed French braids

Tips and tricks to cross style French braids. Starting with making sure that you get hair damp and as close to perfectly straight to make sure the French braids come out as well as possible. This step by step instructional video shows you how to part and braid the hair on another person to help them create this style of braided hair. After watching this video you would be able to create the style of crossed French braids with perfect precision.

How To: Make a 200mw burning laser

Don't use a perfectly good DVD burner to get your laser that will pop balloons, light matches, and burn stuff. Just buy a laser diode at mfgcn.com and also a laser housing, and you won't be tearing a computer DVD player apart. This is the easy way to make a 200mW burning DVD laser. Use a Mini Maglite and some rechargeable batteries so you don't burn out the laser.

How To: Smooth skin in Photoshop CS3

Think every model you see in a magazine has perfectly smooth skin? Sure, but don't worry, it's not natural! You can do the exact same thing in Photoshop with this tutorial. Watch and learn how to smooth skin by retouching portraits with blur tools in Photoshop CS3.

How To: Coat drywall around boxes with joint compound

Watch this instructional video on how to coat detail work around boxes and pipes with joint compound. Spackling drywall is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of spackle. Learn how to lay dow thin coats of putty around details and box shapes to avoid heavy sanding in the second stage of prepping a room for painting.

How To: Coat butt joints with joint compund

Watch this instructional video on how to coat butt joints with joint compound. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of spackle. Rock the putty knife back and forth to coat a butt joint with joint compound. Once you are ready, try out to bonus trick for spackling masters.

How To: Coat ceiling joints with joint compound

This instructional video demonstrates how to coat ceilings with joint compound, without dripping mud on your face. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of joint compound. Spackling ceilings is one of the more difficult tasks in prepping a room for painting, but this video provides tips on how to lay down thin layers of putty to avoid heavy sanding after the spackle dries.

How To: Coat a cornerbead with joint compound

This is a video demonstration on how to coat cornerbeads with join compound. Spackling is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a bucket of fresh joint compound. Learn how to spackle a corner in thin coats to avoid heavy sanding in the second stage of prepping a room for painting.

How To: Putty coat drywall

Here's a way to make your drywall project perfect. Mix up some thin joint compound, using more water than normally required for spackling holes in the wall. You can roll the putty onto the wall with a think rolling brush. After the joint compound dries, it only requires a light sanding. Watch this instructional video to create perfectly smooth drywall surfaces with liquid spackle.

How To: Tie the perfection loop with fishing line

The Perfection Loop is a great knot for tying a small loop at the end of the line. The Perfection Loop is perfectly in line with the standing part of the leader and it is both quick and easy to tie. Follow along with this how to video to learn how to tie the perfection loop for fishing.

How To: Draw perspective and depth

Learning how to draw is a very much about learning how to see. Watch this instructional drawing video to begin to draw the illusion of depth on a flat surface. Most people can see perfectly fine and understand the concept of depth in space. However, drawing becomes tricky when you must translate a moving object onto a piece of paper. Learn to draw in the page, rather than on the page.

How To: Do a side leg lift circle pilates exercise

The side leg lift series is part of the classical Pilates repertoire and the circles strengthen the core, flatten the abdominal muscles and tone the inner and outer thighs. If you feel strain in your lower back, bring your legs slightly forward of your body, but for a real challenge, maintain a perfectly straight line and bring your top hand to your hip. Watch this fitness how to video and you'll be strengthening your body with pilates in no time.