Negotiating Advanced Search Results

How To: Count unique records exceeding a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Filter records to a new workbook 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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.

How To: Use the EXACT function in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.

How To: Play "Hey Julie" by Fountains of Wayne for beginners

This guitar lesson video shows you how to play "Hey Julie" by Fountains of Wayne on acoustic guitar . In the tutorial your learn, the chords, strumming technique and style. This video is geared towards beginners but of course the more advanced student is welcomed to give it a whirl. It's a fun great song, and your in good hands with instructor Erich Andreas.

How To: Do the basic jerk dance

In this Jerk dancing tutorial, a young man by the name Young Maj teaches us in a few seconds how to do the basic Jerk step. After? He burst out into a crazy advanced Jerk dance full of dips and acrobats... Not for beginners or those with bad backs. 'A' for presentation however, Young Maj!

How To: Apply hard wax to cross-country skis

NordicSkiSource.com owner, Doug McSpadden, instructs how to apply a hard wax to your cross country skis. Great informational video for the beginner to advanced skier. You need to have a good iron and patience. Wax the groove of the ski before you place the iron on the base. Make steady consistent passes on the ski.

How To: Play "Romulus" by Sufjan Stevens on acoustic guitar

Want to play like, or along with, Sufjan? This video guitar lesson presents a step-by-step walkthrough of Sufjan Steven's "Romulus." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Sufjan Stevens' "Romulus" on your own guitar, watch this how-to!

How To: Play Sufjan Stevens' "Predatory Wasp of the Palisades"

Want to play like, or along with, Sufjan? This video guitar lesson presents a step-by-step walkthrough of Sufjan Steven's "The Predatory Wasp of the Palisades." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Sufjan Stevens' "Predator Wasp of the Palisades" on your own guitar, watch this how-to!

How To: Play "Angeles" by Elliott Smith on acoustic guitar

Elliott Smith was more than a great songwriter; he was a great guitar player. This video guitar lesson presents a step-by-step walkthrough of Elliott's "Angeles." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Elliott Smith's "Angeles" on your own guitar, watch this how-to!

How To: Play "Between the Bars" by Elliott Smith on guitar

Elliott Smith was more than a great songwriter; he was a great guitar player. This video guitar lesson presents a step-by-step walkthrough of Elliott's "Happiness." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Elliott Smith's "Happiness" on your own guitar, watch this how-to!

How To: Play "Memory Lane" by Elliott Smith on acoustic guitar

Elliott Smith was more than a great songwriter; he was a great guitar player. This video guitar lesson presents a step-by-step walkthrough of Elliott's "Memory Lane." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Elliott Smith's "Memory Lane" on your own guitar, watch this how-to!

How To: Play "Happiness" by Elliott Smith on acoustic guitar

Elliott Smith was more than a great songwriter; he was a great guitar player. This video guitar lesson presents a step-by-step walkthrough of Elliott's "Happiness." While this tutorial is geared toward intermediate and advanced players, even beginners will find much to take away. For more information, and to get started playing Elliott Smith's "Happiness" on your own guitar, watch this how-to!

How To: Create glitch type drum effects in Reason 3.0

This music production software tutorial shows you how to create Glitch-type effects for use with your drum patterns in Reason 3.0. It is an advanced tutorial only because of the speed at which he has to cover the material. In this example Ace Pincter will be adding glitch effects to drum patterns using Dr. Rex, but you can use any Reason drum pattern. Included: RV7000 Gating, Automation, Matrix offsetting, Filtering by gate, and Distortion.

How To: Origami an azalea

Step-by-step instructions for how to make an origami azalea (flower and stamen). This video is for intermediate or advanced folder, as it may be to difficult for a beginner to make an origami azalea.