Exclusive Items Search Results

How To: Use Your iPhone to Sell Unwanted Gadgets Without Ever Leaving Your Home

If you want to sell all of the old electronics lying around your home, it takes a lot of work. If you go the eBay route, you have to take tons of pictures, describe it accurately, wait for a week until someone bids on it (or not), then package it, ship it, and wait for feedback. Craigslist is a little bit easier, but usually requires you driving somewhere to meet the buyer in a public place (if you want to play it safe).

How To: Mine for resources such as coal, iron and more in Minecraft

Minecraft is the surprise indie hit of 2010 and it's still only in Alpha! And one of the mainstays of the name, "mining" is a key element to not only survival but advancement in the game and the construction of bigger and better items, tools, armor, buildings, ect. If you're confused on how to find the materials, or maybe an effective way of actually creating a good mining tunnel, this video tutorial will guide you. You'll learn what types of materials you'll need, as well as what some of the...

How To: Use the Helghast StA-14 rifle in Killzone 2

Killzone 2 is the latest iteration of one of the Playstation 3's only reputable exclusive series. It's a great shooter, and has many guns that are well-balanced and each offer distinct advantages. If you want to master the game, you'd better know how to use each one properly. This video will teach you everything you need to know about the Helghast StA-14 rifle, a semi-automatic but powerful rifle for medium-range combat.

How To: Diagnose and treat hemorrhoids

Around half the UK population will develop piles at some point in their life. In this exclusive guide, Dr Jessen explains the causes of hemorrhoids and dispels some myths along the way. He also discusses treatment options – from over-the-counter creams to surgery – and advises on the best way to prevent piles occurring in the first place. Watch this video tutorial and learn how to diagnose and treat hemorrhoids.

How To: Create your own audio podcast

Podcasting has become the radio phenomenon of the modern age. Kevin Rose and Dan Huard explain why podcasting is so popular and they show how to set up a basic podcast environment from the hardware you'll need to the uploading process. Also, get an exclusive look into Leo Laporte's (of This Week in Tech fame) advanced podcast studio!

How To: Remedy potential earthquake hazards in the workplace

Washington State has a history of large earthquakes, as does California. More than 1,000 earthquakes are registered in Washington State each year. More than 10,000 are recorded in California each year. In an earthquake, non-structural elements, which is anything that does not actually hold the building up, may become unhooked, dislodged, thrown about, and tipped over. this can cause extensive damage, interruption of operation, injury and even death.

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: Send the exclusive gifts from FarmVille (11/27/09)

This video tutorial shows how to send exclusive gifts in FarmVille (11/27/10). Sending gifts to your friends is one of the many ways that FarmVille helps you stay connected to people on Facebook. This video will teach you how to send the FarmVille.com exclusive gifts in Facebook, which normally isn't possible. Show your love for your friends by sending them the best gifts possible!

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: 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: 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: Tie a Knute hitch

In this video, we learn how to tie a Knute hitch. The purpose for this is to make an easy dummy cord on something with a hold for it. To start, tie a simple overhand knot in one end and then make a bite in the knot. With this bite, insert this into the hole in your item. Once it's through, take the end with the knot and put it through the loop. Then, pull the end of the string until it's tight over the item with the hole. Then you can use this as a handle so you don't lose your item!

How To: Make a chemical indicator from kitchen items

In this tutorial, we learn how to make a chemical indicator from kitchen items. First, make an indicator by grabbing some red cabbage and some vodka. Now, heat up some water until it's boiling, then place a smaller beaker inside the water with vodka inside of it. Place the red cabbage inside of the smaller beaker, then stir it up and let sit for 10 minutes. A lot of the color will come out with the cabbage being inside of the alcohol. After this, pour this into a storage bottle and pour the w...

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 a creative gift basket from unique items

In this tutorial, learn how to take funky items from around your home like a picnic basket, an easel, a backpack and other fun things and turn them into creative gift baskets. In this clip, learn how to accessorize the perfect gift box for a creative friend or family member. The recipient will love these personality specific, interesting presents!

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