Unique Extras Search Results

How To: Play inversions of triads on the guitar

As a guitar player, you will be faced with various challenges in your career, and one of those are being able to blend in with your rhythm section without stepping on anybody elses toes. One way is playing inversions of triads to give a fresh and unique sound to your rhythm and lead guitar playing. In this video you will learn about rearranging triad shapes to make inversions.

How To: Defeat the bosses in Castlevania: Harmony of Despair

If you recently purchased Castlevania: Harmony of Despair on your Xbox 360, this next tutorial will help save your life. In this strategy how to tutorial, you'll find out how to defeat the game's most difficult enemies, the stage bosses. Each one has unique powers and attacks, but they also have some different weaknesses as well. They're easy to follow and should be easy to follow. Good luck and enjoy!

How To: Overclock a rooted Motorola Droid phone easily

The Motorola Droid was one of the first and is still the most popular Android phone. It's hardware keyboard, a unique feature among it's competitors, will keep it there for a long time, but it's performance is starting to lag behind. Why not overclock it's processor, giving it some much-needed speed? This video will show you how to overclock a rooted Droid the easy way, and help you make your phone work faster.

How To: Add words to the Swype database for faster texting

If there are words that you use often but Swype doesn't know them yet, you can easily add them to the database of your texting program. In this clip, learn all about adding uncommon or unique words to your Skype dictionary so that you can text even faster. You can even add web addresses, e-mails, nicknames and anything else you use often and don't want to tap out.

News: Hands-on with Samsung's Official OEM Cases for the Galaxy S9

The Galaxy S9 is now in the hands of millons of excited users. Getting a new phone is always fun, but it's important to think about protecting your device. Perhaps the most popular cases for the Galaxy S9 are the official OEM options from Samsung. There are a plethora of cases, whatever your preference and needs may be. Let's take a look at each case individually, along with the pros and cons.

How To: Cut up your t-shirt and look unique and stylish

In this Beauty & Style video tutorial you will learn how to cut up your t-shirt and look unique and stylish. Take a loose baggy style shirt and make two marks with scissors just near the shoulder seam. Then cut down the center of the t-shirt about 2inches. Now cut from the shoulder marks up to the center point and on the back just cut straight along the shoulder cut marks. Then cut open the top part of the sleeves little short of the shoulder seams. After this cut off the bottom seam. Then st...

How To: Extract a unique list from a huge data set in MS 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Group duplicates & extract unique records in MS 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Dynamically count unique words in a column in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Make a champagne ginger cocktail

Bartender Gene shows you how to make a unique, healthy, ginger infused cocktail. Simmer 1/2 cup water, sliced, fresh ginger and sugar to make a ginger infused syrup. Remove from heat, let cool, then add 1/2 cup vodka and refrigerate. When your syrup is cool, strain out the ginger and throw it away. Place candied ginger at the bottom of the glass and pour in about a tablespoon of the syrup. Top off with sparkling wine and serve. Follow these easy steps to create a celebratory, unique, good for...

How To: Make a delicious prawna siciliana from frozen ingredients

Nearly everything in this recipe has been frozen! You will need: 10 black pitted olives, 2 tablespoons of capers, 6 diced tomatoes, 2 fresh red chilis, 1 lemon, 16 frozen raw tiger prawns, 1 cube of frozen chicken stock, frozen roasted veggies, extra virgin olive oil, pinch of garlic, pinch of basil, pinch of parsley, grated Parmesan and your cooked spaghetti.

How To: Insert a movie from iTunes into your Keynote project

The Media Manager that comes with Keynote is a useful tool for adding in all sorts of media to your slideshow or project; and videos can add an extra level of depth and information to your project. Take any movie or clip from your iTunes library and then use the Media Manager tool to insert it into Keynote. It's a very simple process - the whole video showing you how to do it takes barely a minute!

How To: Set up a mini hidden camera easily

This video shows you how to set up and hide mini wireless spy camera. Where you put it is up to you. Who you spy on is up to you. If you're wanting to keep an extra set of eyes on someone, watch and learn. Whether it's your bathroom or kitchen, put your eyes on the prize.

How To: Fix a leaky toilet with basic steps

Is there toilet water all over the floor and you have no idea why? It could be a leak toilet, which is pretty common if you have faulty supply lines, or the wax rings have worn out. But don't worry, you don't need to call a plumber to ease your woes, in this video you will learn how to fix your leaky toilet with a few household tools and some extra knowledge!