Players Pick Search Results

How To: Use the Microsoft KIN Two smartphone

Whether you're the proud owner of a Microsoft KIN Two smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features. Specifically, this video demonstrates the unit's Favorite, Loop and messaging functionalities.

How To: Get the Armory of One achievement in Left 4 Dead 2

It's time to lock, load, and prepare to kill some zombies. In this Left 4 Dead 2 tutorial, you'll find out how to easily unlock the Armory of One achievement. In order to get it, you'll need to find and drop an ammo crate for your teammates to pick up. They spawn from explosive ammor to fire ammo and can be used to help end those zombies lives.

How To: Make a professional-looking advertisement in Photoshop

Need to create an ad for your business? Learn how with this video lesson. Meet the Adobe Photoshop pen tool! Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which presents a step-by-step guide to creating a professional-quality advertisement.

How To: Extract an object from its background in Photoshop

Want to separate a foreground object from its background? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from Connor Tuts. For more information, including step-by-step instructions on how to get started extracting elements from pictures in Photoshop yourself, watch this graphic designer's guide.

How To: Retouch a face in Adobe Photoshop

Improve your complexion the easy way! Learn how to digitally retouch a face with Photoshop. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial. For more information, including step-by-step instructions on how to retouch human faces within Photoshop, watch this graphic designer's guide.

How To: Remove stains, dirt and discoloration in Photoshop

Want to touch up an old printed photograph? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to get rid of unwanted stains, dirt and discoloration using Adobe Photoshop.

How To: Remove dust, dirt & scratches from images in Photoshop

Want to remove dirt, dust and scratches from an old photo? With Adobe Photoshop, it's easy to restore antique or damaged photographs. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to remove dirt and noise from an old image.

How To: Make classic tiramisu with mascarpone & coffee liqueur

Tiramisù is the world's most popular Italian dessert, with delicious layers of sponge cake and brandy (or liqueur), usually with powdered chocolate and mascarpone cheese. This particular classic Italian dessert is the perfect balance of fresh whipped cream, mascarpone cheese and coffee liqueur. Check out the entire video recipe for this tasty classic style tiramisu dessert.

How To: Use the Micrsofot KIN One smartphone

Whether you're the proud owner of a Microsoft KIN One smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features. Specifically, this video demonstrates the unit's Phone, Spot, Loop and Theme functionalities.

How To: Make an awesome Christmas wreath

Are your wreaths looking a tad shabby? Make your own Christmas wreaths this holiday season with help from Mary Fletcher Jones and materials readily available at any Michael's craft store. To complete this beautiful wreath, you will need the following items:

How To: Find an item's relative position via MATCH in MS Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.

How To: Use the CHOOSE function in Microsoft Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 46th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use MS Excel's CHOOSE function.

How To: Use Microsoft Excel macros securely

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.

How To: Speed up conditional formulae with VLOOKUP in MS Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.

How To: Calculate taxable earnings given a ceiling in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...

How To: Use conditional summing in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.

How To: Use Excel's SUMIF, RANK & IF functions

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Add across sheets in Excel with 3D cell references

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.

How To: Make a decorative tin for your mom on Mother's Day

Are you struggling to get mom a unique gift this Mother's Day? Do you always get her flowers or chocolates? Break out of the "same old, same old" and make a decorative tin for mom shown here in this video. By picking up just a few materials from your local craft store, you'll be one step closer to creating the best homemade gift mom has ever received!

How To: Get started playing slide guitar

A step-by-step video tutorial presented by Andrew Wasson shows the basics of playing the slide guitar for beginners. First, choose what kind of slide you want. Metal slides are known for their high-end treble sound, while glass slides are a little warmer sounding. Andrew goes on to teach you what gauge of strings are best suited for slide playing, as well as how to pick which finger to use your slide on.

How To: Install the Adobe Flash Player on Internet Explorer 8

In this ClearTechInfo tutorial the author shows how to install Adobe Flash Player on Microsoft Internet Explorer 8. He opens the Internet Explorer and goes to the website get.adobe.com/flashplayer. After navigating to that website he scrolls down and points to the location where there is an option to agree to the terms and condition and download the flash player. He also shows how to enable the active-x control to download the flash player and finally after downloading the player he shows how...

How To: Pop a pimple the right way

Don't pick the blemishes on your face, at least until you've seen this how-to video. You shouldn't pop zits because of the high risk of scarring, but you'll probably do it anyway. Watch this video skin care tutorial and learn how to pop a pimple the safest way possible.

How To: Prepare your computer to upgrade to Windows 7

Rocketboom Tech correspondent Ellie Rountree recommends 5 tips for installing Windows 7. Before making the big switch to Windows 7, check out these tips. Some topics covered are backing up your files, picking out the right version of Windows 7 for you, and when to make the switch. Follow along and learn how to prepare yourself, and your computer, for an upgrade to Windows 7.

How To: Do a Wolf Whistle

Use the piercing whistle in this how-to video on strangers at your own peril. Although it's commonly depicted as a pick-up method, it may not be particularly effective in that regard. All the same, the wolf whistle is a classic and will definitely be attention grabbing. Watch this video, and you may even be able to apply it as a practical joke of sorts.

How To: Wrap gifts with the furoshiki eco-friendly method

Join Molly de Vries and pick up some new holiday tricks with a green conscience. She shows us how to make a festive fabric garland from attractive scraps, then shows a furoshiki fabric gift wrapping technique. Molly is a sustainable textiles maven and creator of Ambatalia "The Fabric Society." Learn how to wrap gifts the furoshiki method.

How To: Perform the Sonic pen spinning flip trick

Getting tired of performing tricks at the bar with beer bottles? Well, try picking up a pen or a pencil. Watch this video tutorial to learn how to perform the Sonic pen spinning flip trick. Pen spinning isn't just good for the bar scene, it's also good for the school and work environment. The Sonic Flip can be daunting, but practice makes perfect.