Unconventional Pick Search Results

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

How To: Choose a perfectly ripe Camembert cheese

Choose the right Camembert cheese, cut it up nicely, and store the leftovers properly: important tips to keep you in good cheese humor. In this how to video learn how to pick a Camembert cheese that is perfectly ripe. Learn what it should smell like, what it should feel like from this CHOW contributor.

How To: Choose the right adhesive for a repair job

Depending on the job at hand, you're going to want to choose the right drill glue. There are different adhesives that will work better with metal, wood, glass, ceramic tile, or anything else you might need to bond, and that have different techniques for using. Watch this video home improvement tutorial and learn how to pick the right glue for the repair job at hand.

How To: Attract and feed orioles

Here is a bird how-to video that offers tips on attracting and feeding orioles. Orioles like hummingbirds are attracted to a specific color. When choosing an oriole feeder you want to pick one that is orange. Follow along as the owner of a birding store gives you more great tips on choosing a feeder and food material for a orioles.

How To: Calculate averages in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Decorate a haunted house for Halloween

Setting up a haunted house for Halloween doesn't have to be expensive. This how-to video offers some tips for adding spooky touches to your haunted house. Instead of buying everything from a Halloween store, thrift stores and tag sales are a great place to pick up decorations to modify yourself. Watch this video tutorial and learn how to get props ready for a Halloween haunted house.

How To: Play relas on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak introduces the rela and demonstrates how to play one. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started playing relas on your own tabla, take a look.