Unique Utilisation Search Results

How To: Fold an origami Christmas tree ornament

Origami is simple and fun and our host proves that right off by displaying how little we actually need material wise, to make something unique and pretty. Just two swathes of patterned paper, put flush together and a paper clip. First folding your little construction into the shape of a tiny kite It gets very precise from there. Incorporating smaller and smaller folds, but with a close-up view and a step by step explanation, this video will ensure success. After creating your unique abstract ...

How To: Make a beautifully unique beaded windchime

Do you have a bunch of flawed beads left over after you make your crafts? You know the ones, the chipped, cracked, sharp ones that don't make the cut and usually get tossed in the garbage? Why not make those into something lovely, where the cracks don't matter? In this two part tutorial, learn how to turn your discarded beads into a beautifully shiny wind chime for your backyard. This chime is unique and makes a lovely noise in the wind. Let's get crafting!

How To: Count unique items in a list 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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.

How To: Highlight rows that contain unique values 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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Count unique values greater than 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 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Count unique items with multiple criteria in 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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...

How To: Play online multiplayer well as any class in Killzone 3

Killzone 3 is the biggest shooter to hit the PS3 in quite some time, and one of it's few awesome unique IPs. This video will teach you how to not be a n00b in this awesome game while using the Marksman (hint: spawn trapping), Infiltrator (stabby stab), Engineer (helps Marksman with ammo for more spawntrapping), Medic (revives Marksman for more spawntrapping), Tactician (spawn-point seizing) classes. Spawn

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.

How To: Get extra skaters and use some codes in Skate 3

It's time to go achievement hunting! In this video from the great men at Achievement Hunter, you'll be playing the game Skate 3. In this tutorial, you'll be finding out how to get some extra characters and use a couple of cheat codes. The characters are unique and different and the codes are pretty fun to use. So check out the tutorial and have fun!

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: Grind your own spices

In this tutorial, we learn how to grind your own spices. Spices grow all over the world, which can give them all unique tastes. Start off by grabbing the spices that you want to mix together. Use your favorite spices to make your own unique tastes. If you are roasting, you should not roast or toast the spices all together at once, so they don't incorporate smells. After you do this, you will use a mortar and a pestle to crush down the spices. Start pounding on the spices to release the oils a...

How To: Write a unique personal statement essay

In this tutorial, we learn how to write a unique personal statement essay. Personal statement is the heart of the application where you can give voice to your accomplishments, dreams, and goals. You want to stand out from the rest of the applicants, so you need to express what's important to you. You can show them how well you write and show passion, your smarts, and sense of humor as you write. You can do this because you are prepared and you are being true to yourself. Once you understand t...

How To: Turn a tank top or tee into a better fitting, cute, unique shirt

Your tanks and your tees aren't fitting just right, don't throw them away or toss them in a storage box just yet. Grab some scissors and cut that sucker up, then mold it in a better fitting, unique and cute shirt. The easiest part is simply slicing up the back up the shirt, but then comes the strings. Watch and see for yourself. This is a great way to transform a normal T-shirt or tank top into something more creative.