Biggest Pitfalls Search Results

How To: Sort numbers with a formula 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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.

How To: Cook Polenta in 15 Minutes Instead of 40

I became a big fan of polenta while studying Italian cooking. Previously, it never occurred to me that ground corn could create a dish that could rival the best pastas or potatoes. Those rich, golden bowls of cornmeal, cooked until tender and flavored with good olive oil, butter, sea salt, and fresh herbs soon became one of my favorite things to eat.

How To: Play online multiplayer well as any class in Killzone 3

Killzone 3 is the biggest shooter to hit the PS3 in quite some time, and one of it's few awesome unique IPs. This video will teach you how to not be a n00b in this awesome game while using the Marksman (hint: spawn trapping), Infiltrator (stabby stab), Engineer (helps Marksman with ammo for more spawntrapping), Medic (revives Marksman for more spawntrapping), Tactician (spawn-point seizing) classes. Spawn

How To: Get an Aubrey O'Day/Danity Kane inspired makeup look

In this clip, learn how to get Aubrey O'Day's makeup look from the girl group, Danity Kane. Aubrey is arguably the biggest star of the group and was the definite stand out personality on P.Diddy/MTV's "Making the Band". This look is sexy and definitely screams party girl. If you are heading out to a fun event, try out this sultry eye look and stand out in the crowd.

How To: Get through airport security quickly

Airport security lines are one of the biggest hassles involved in air travel. Navigating them quickly and successfully can be the difference between making your flight and not. This video offers some tips for how to get through security quickly, including buying airport-security-friendly luggage and packing said luggage in an easy-to-inspect way. Also, don't wrap any gift, as security may want to unwrap them!

How To: Prepare a turkey burrito burger with Rachael Ray

Rachael Ray is one of the biggest stars in television cooking, and her 30 Minute Meals series focuses on easy meals that save both money and time. In this installment she demonstrates how to prepare a turkey, bean, and rice burrito burger, which turns a relatively small amount of turkey into massive, filling burger patties. Quick, easy, cheap, and delicious.

How To: Keep ice cubes frozen longer for your next party

Ok, it’s not the biggest problem in the world, but an ice bucket full of water is a not-so-subtle hint that the party’s over. Make your cubes last until the final guest has had their fill. Watch this Howcast video to learn how to keep ice cubes frozen longer. You will need boiled water, large ice trays, insulation, like bubble wrap or cloth, and muffin tins.

How To: Conserve water in your home

Australian native Scott's biggest concern is water conservation. By overhauling his bathroom, hot water, heater and backyard, Scott saves $360 a year on water costs. Learn how you can save money and conserve water by renovating your plumbing with this how to video.

How To: Determine whether watermelons are ripe or not ripe

One of the hardest fruits to determine the freshness of is the watermelon. It's the biggest question in the produce department of grocery stores, so you're not the only one having problems. This video from YourProduceGuy gives you the tips to finding out what to do when picking out a fresh and perfectly ripe watermelon and the local store. There's a sweet spot for every fruit.

How To: Install Frash on an iPhone 4 or iPad and view Flash media on your device

One of the biggest problems with the iPhone 4, iPad, and iPod Touches is that they don't have any native support for Flash, which is the language of choice for much online media. Fortunately, there's an App for that now too called Frash that will allow you to run Flash on your iDevice. This video will show you how to get it, install it, and start really experiencing the web on your iDevice.

How To: Easily rig a float or slip bobber rig

If you've never fished before, you may not know all the different ways to help you catch the best looking and biggest fish. There's more to having a fishing rod and string. In this tutorial, you'll find out how to easily rig a float or slip a bobber rig. It's easy to do and will help you out when on a boat or on land. Good luck and enjoy!

How To: Know out what women carry in their purse

The purse. One of the biggest mysteries to man. In it, lies hidden treasures and things that no man can understand how it exactly fits in there. It's so mysterious that it can become maddening. So in this tutorial, you'll find out how to know what women carry in their purse. Good luck and enjoy!

How To: Use filters in Final Cut Pro and Final Cut Express

This clip explains the biggest difference between Final Cut Pro and Expres — to wit, the Filters. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, and to learn more about the difference between FCP and FCE, watch this tutorial.

How To: Make yourself pack light for business trips

Avoiding the need to check luggage has been one of the biggest goals of business travelers for decades, especially now that many airlines charge more baggage fees than ever. This video outlines six easy tips for packing lightly and efficiently, which will enable you to carry all of your bags with you and save a lot of time at every stage of your trip. These include wearing your heaviest clothes and organizing your belonging within your suitcase.

How To: Use an iPad as a midi controller

The Apple iPad is one of the biggest and most popular pieces of technology in recent years. It sold millions of units in an amazingly short amount of time and can be used for a variety of different jobs. In this tutorial, you'll learn about one of them. This video shows you how to use an iPad as a midi controller Ableton Live. So sit back, pay attention, and enjoy!

How To: Convert AAC iTunes files into MP3 without software

One of the biggest pains is finding a way to convert files. Most of the time, you would need to download software in order to do so, but that can be a problem within itself. This tutorial will help those that are interested in converting their AAC iTunes files into MP3 without using software. It's easy to do and will make your life a bit more easier. Enjoy!

How To: Choose photography backdrops

Interested in taking professional-caliber portraits but aren't sure what sort of backgorunds to buy? When choosing a background, your biggest consideration should, of course, be the backdrop's primary application: browns and blues, for example, are great colors for standard portraits. For more information on selecting your first photo backdrops, watch this free photographer's guide.

How To: Identify types of fly fishing flies

There are two types of fly fishing flies, and they are distinguished as surface and sub-surface flies with the surface ones being called dry flies. This tutorial will teach you how to tell the difference, and what this means. Make sure you know what's what and make sure you catch the biggest fish in the pond.