Items Amid Search Results

How To: Make a small robot gripper out of household items

A perfect project for the budding roboticist in you! This video shows you how to make a small robot gripper using basic household items. Press the button and make the robot's come together! You will need: a small blow torch or butane lighter, a glue gun, a dremel or rotary tool (along with several different bits), the free cutting pattern, a permanent marker, a micro servo, some small nails or pins, a small piece of Plexiglass and a paperclip. If you don't have access to a dremel, you can fak...

How To: Use a rotary cutter

In this video, we learn how to use a rotary cutter with Kenneth D King. Before you begin, make sure to use a cutting mat so you don't damage the top of your surface. To cut your item, you simply place the rotary cutter on the bottom of the item, then run it through until you have reached the top, or the desired area you want to cut. If you want to cute with a different shape, then you can purchase different cutters that will create shaped edges on what you are cutting. After this, place your ...

How To: Make animal masks using household items & John Lithgow

It's time to teach your kids about animals! To get your little one thinking like an animal, why not help them look like one? In this tutorial, featuring John Lithgow, learn how to turn common household items like paper plates and paints to create fun, realistic looking animal masks with your kids! You will also learn how to make special doggy treats and bird feeders so that you can really get on all fours with your animal buddies! Have fun!

How To: Count unique items in a list in Microsoft Excel

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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.

How To: Return multiple items by array formula in MS Excel

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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).

How To: Clean your game disc, DVD or CD with household items

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...

How To: Prepare yourself and your home for a hurricane

Hurricanes can occur any time with out any warning. So it is prudent to prepare you self for disaster recovery in case of any hurricane. To protect your self from hurricane by staying at home or to flee from a hurricane you will need some items ready. The main thing is water. So arrange for one gallon of fresh water for one person per day. It is good to store water sufficient for one week. So store enough quantity of water for all the persons in the home sufficient for one week. Make sure tha...

How To: Make a Hovercraft with Common Household Goods

This video illustrate us how to make a hovercraft with common household items. To build one, first of all, collect all of the items required for making it. You need a CD, bottle cap, balloon and super glue. Then start by applying glue to the lower end of the cap and sticking it to the center of the CD and let it dry. After it has dried, blow up the balloon and secure it up on the bottle cap tightly. Now open the bottle cap and let the balloon deflate.

How To: Count unique items with multiple criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...

How To: Create a cloud in a clear container

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.

How To: Use the SOFLAM item in Battlefield 3

The SOFLAM is a gadget that you can use in Battlefield 3. It is a team based gadget that you deploy and use to laser target. It is different than a mortar and can be a little hard to use. This guide will show you how to get the most out of a SOFLAM so that you can tear up the other team.

How To: Farm for wheat and grass with seeds in Minecraft

Farming in Minecraft isn't the most exciting part of the game, but it's essential for making the high-level food items like cake so you'd better get used to it. This video will walk you through all aspects of Minecraft farming, including getting seeds, using your hoe to til the soil, planting the crops, and then using bonemeal to make them grow fast.

How To: Use Slide and SlideToggle() Effects in jQuery

The slide effect is a popular feature of many websites that allows information to cascade out from an item on a page and the rest of the page to adjust accordingly. This effect is created using the SlideToggle() function in jQuery, the popular Javascript library. This video will teach you how to use it to make your website much easier for your users to access.

How To: Perform complicated looking magic tricks anywhere

In this video, Justin Kredible will teach you how to perform a ton of cool magic tricks using items you already have around the house. Justin is a master illusionist and in this clip he shows you some of his easiest (yet still fascinating) magic tricks. Like Justin says, he doesn't reveal secrets..he teaches magic. Have fun!

How To: Use Mail Merge in Pages for Mac

A step-by-step guide that will walk you through Mail Merge on a Mac computer. You will gain how to prep and print envelopes, letters or any document that you need to send to different names and addresses on each item. You can pull the data from your address book or from a Numbers Spreadsheet and will see how to modify and merge the information you will need to successfully set up your documents.

How To: Make a buttermilk substitute

Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.

How To: Pick handcuff locks and escape

This guy shows how to easily bust out of handcuffs with one of three household items. Its a cool thing to know but most of the time if someone puts handcuffs on you its best to just leave them on. Uses a dental tool and bobby pins.