Promote Items Search Results

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: Survive in Dark Souls with a few easy tips

Are you playing through Dark Souls and having flash backs to all those times you died in Demon Souls? IGN is here to help you with several tips and tricks on surviving. This guide shows you good spots to grind, what gift to pick for your character, and where to get the Sorcerer's Catalyst item that will allow you to cast magic in the game, even if you aren't a magic user.

How To: Completely delete items from Mac OS X

In order to completely delete items from Mac OS X. Download Google desktop. This will search your computer and the web and your computer. Go to Applications. Right click on Google Desktop. Go to Show Package Contents. Drag contents into the trash. Next, go to Google Gadgets. Click and drag it to the trash as well.

How To: Pack a backpack for mountaineering

The video demonstrates how you should pack to be fully equipped and prepared for a backpacking trip that lasts 2-3 days. Gather all of your equipment including clothes, food, water, climbing gear, emergency kit, sleeping back, and more. When you start to pack, you want to make your center of gravity is very low so pack your heavier items near your back and lighter ones that aren’t required immediately during your trip such as your sleeping bag at the bottom of the backpack. Also remember th...

How To: Make a robot out of household items

This do it yourself robot can be made out of many materials you can find around your house. You'll need a few special non household items, such as an arduino and a class 3 laser. However, once you assemble everything correctly, you can make a sentry robot inspired by the robots in the game PORTAL. Even if you've never built a robot before, as long as you have a basic knowledge of electronics, you can start with this simple and fun project.

How To: Build a wave machine out of household items

In this tutorial, we learn how to build a wave machine out of household items. You will need: 20 straws, 40 paper clips, 2 pieces of tape, and 1 washer to make this. First, you will need to pull out a long string of tape and lay it down with the sticky side up. After this, you will need to stick the straws on top of the tape in a row all going next to each other. Do this from the top to the bottom until all of the straws are stuck on. Then, stick the washer to the top and you are finished wit...

How To: Make a new menu in Joomla

In this video, we learn how to make a new menu in Joomla with Chad. First, log into your Joomla account and go to the menu button. Click on "menu manager", then you will click on the "new" link. After this, enter in the unique name, title, description, and module title in the appropriate boxes. Once you do this, click "save", and now go to the menu items icon under the links menu. Now, go to "new", then "external link". Enter in the menu item details in the appropriate boxes, then add in the ...

How To: Return many items for a single lookup value in 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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...

How To: Use partial text matching 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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.

How To: Make a Christmas wreath with poinsettias

To make a Christmas wreath with poinsettias, by using synthetic materials you will need a Christmas wreath, pine cones, ribbon, berries, poinsettias, and any other picks you may want to use. You can purchase these items at any craft store. First, shape wreath, make bow out of Christmas ribbon (or pre-purchase bow), and attach on wreath. Next, wrap excess ribbon around Christmas wreath and align evenly poinsettias around wreath. Then, wrap around wire from the ornaments, pine cones, berries, a...

How To: Print directly from your Mac desktop

In this video from MacTipsOrg we learn how to print directly form your desktop on a Mac making printing very quick and easy. First, open your system preferences, and then click on print and fax. Now take the printer icon you see there and drag it to you desktop. Place it anywhere on your desktop. Whenever you need to print now, you can take your item, drag it, and drop the item right on the printer that is now on your desktop and it will print! This is a quick time saving technique to use for...

How To: Pack your luggage efficiently

Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...

How To: Pack a backpack for Europe as a male traveler

Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...

How To: Pack a bag for Europe as a female traveler

Backpacking through Europe is an exciting and affordable way to see a new country. This video tutorial shows female travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. As a general rule, include clothing that may be easily layered for colder climates.

How To: Make a mini polymer clay hamburger for a dollhouse

Using multiple layers of clay, garden of imagination shows how to make a hamburger and fries out of polymer clay. This decorative item would then be placed into a miniature dollhouse being displayed as a food item. She rolls a peppercorn on brown clay to give it the texture of meat. She mixes together green and whit clay for lettuce, and uses another piece of clay to ruffle the edges of the lettuce. She uses small round cuts of clay for tomatoes. Using an embroidery needle with a clay handle ...

How To: Combine multiple PDF files on a Mac

In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...

How To: Make a miniature cream puff

The people at Garden of Imagination demonstrate how to make a miniature cream puff. Using a mixture of polymer clay, clay icing, pastel paints and a variety of tools, including a paintbrush, a scalpel, and tweezers, a miniature cream puff is born. This mini item is perfect for any number of occasions. When used in combination with other mini foods and pieces, it makes a cute and cheap decorative item. Creating a tiny and affordable State Fair has never been easier!

How To: Do wet blocking to a knitted piece

The Knit Witch shows you how to do wet blocking to a knitted piece. With specific tools like a blocking board with a grid, a tape measure, and a few other items. The items used can vary based on what kinds of material you are using so it's important to know what each one needs. Reminders and tips are explained when the pertinent step is reached so that you can keep them in order and apply them when needed. Wet blocking will be a breeze after watching this video and following the steps closely.

How To: Use packing tubes to contain clutter when traveling

The organizer pouch, a flat, rectangular, often multi-compartmented, nylon bag with zipper closure(s) is a great item that is becoming hard to find. They sometimes include see-through mesh panels, and are available in a variety of colors. These are terrific for avoiding what could otherwise be a cluttered mess in your bag. Give a little thought to organizing your belongings into categories and storing them in the pouches. This will help you keep track of those small items that have a way of g...

How To: Hit a golf ball far

Ken demonstrates how to hit a golf ball far. A golf shot starts with a good grip to give it power and flexibility. Grip the golf club under the heel pad creating a 45 degree angle. When the wrist flexes and hinges, the angle will be 90 degrees which will give you power and speed. This promotes flexibility, control and a desirable centrifugal effect. Create speed through motion. Keep your feet together to keep your body quiet and you will increase the speed of your hands and arms. It will also...