Weal Picked Search Results

How To: Play the key elements of "Sweet Home Alabama"

Learn how to play Lynyrd Skynyrd's "Sweet Home Alabama" with this free guitar lesson. This video guide presents a complete, step-by-step breakdown of the song including chords and picking patterns. For more information, and to get started playing this popular southern rock anthem on your own acoustic guitar, watch this tutorial.

How To: Play "Old Man" by Neil Young on acoustic guitar

Learn how to play Neil Young's "Old Man" with this free guitar lesson. This video guide presents a complete, step-by-step breakdown of the pop-folk ballad including chords and picking patterns. For more information, and to get started playing this popular Neil Young tune on your own acoustic guitar, watch this tutorial.

How To: Play "Blackbird" by Lennon/McCartney on guitar

Learn how to play the Beatles' "Blackbird" with this free guitar lesson. This video guide presents a complete, step-by-step breakdown of the pop folk ballad including chords and picking patterns. For more information, and to get started playing this popular McCartney tune on your own acoustic guitar, watch this tutorial.

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