Unique Desired Search Results

How To: Grow a bonsai tree from a seed

Bonsai is a beautiful art that focuses on manipulating a tree to any shape you desire! If you've wanted to grow your own bonsai from a seedling to the full thing and are wondering where to start, check out this video! In it you will learn what sort of trees that you can plant to make into bonsai, as well as how to grow it from seed to seedling!

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.

How To: Make a urethane rubber mold

This video illustrates in great detail how to create a perfect urethane rubber mold. Urethane Rubber molds are widely used when a flexible mold material is required and a more expensive or less abrasion-resistant silicone rubber is not desired. However, their use requires careful application of release agents. This process can be used in automotive, mechanical, fine art and film special effects uses.

How To: Make a mini polymer clay hollow pumpkin for a doll

In this video we're shown how to make a miniature hollow pumpkin. First start with Sculpey clay, the color you want to use is sweet potato pie. Roll some out flat and wrap it around a large glass marble, cutting off the excess clay. Next cut a small opening at the bottom so you can remove the marble later. Start sculpting the outside of the clay into a smooth spherical shape, using the marble as a guide. Next, take a toothpick or other similar utensil and poke a small whole in top of your pum...

How To: Use a candy thermometer

Making a batch of candy this holiday season? To make a successful batch of candy, you need the precise temperature, consistency, and timing during the cooking process. Watch this video to learn how to use a candy thermometer.

How To: Make turkey noodle soup

Learn how to make some casual, traditional, and unique dishes with tutorial help from myrecipes.com. In this video recipe, learn how to make turkey noodle soup. This simple, 35-minute recipe from Cooking Light magazine gives turkey leftovers a fresh start in soul-satisfying soup.

How To: Make black forest trifle

Learn how to make some casual, traditional, and unique dishes with tutorial help from myrecipes.com. In this video recipe, learn how to make black forest trifle for kids and the whole family. This is an awesome dessert for anyone. Chocolate cake, chocolate pudding, and dark cherries make up this easy, make-ahead dessert. And since it's low-sugar, it works with a diabetic meal plan.

How To: Sketch a dragon

For all those who have always wanted to sketch a dragon, here is one video which will give you step by step instructions on how to draw one. Dragons are creatures who breathe fire through their noses. The video is a quick watch and learn tutorial and anybody with a desire to possess a dragon sketch can master it in minutes. Use the sketch in comic book illustrations, animate it, or use it as a design on your favorite t-shirt.

How To: Make your own sock blockers

Learn how to make your own sock blockers with this video. • Trace your sock with extra spacing. • Cut out the template. • Take 3MM foam sheet. • Trace the template onto a foam sheet. • Extend and cut off the traced foam sheet to desired length. • Cut the form with the scissors.

How To: Chill Any Drink in 1 Minute

Here is how to cool any desired drink to a nice and cold temperature in just one minute. Whatever the reason why you need a cool drink fast, whether it's because you don't have a fridge or freezer on hand, or that you just want to make your drink cold fast, this method is awesome.

How To: Disable the Annoying Increasing Ringtone on Your Samsung Galaxy S4

Samsung introduced a wave of seriously unique and innovative features on the Galaxy S4, including air gestures and weather sensors, but a lot of the features are actually just updated ones from the Galaxy S3. Unfortunately, one of those that returned was the dreaded increasing ringtone. In their increasing ringtone system, the ringtone will start off on a low volume and increase until it reaches your set volume. In theory, this is useful for not shocking the user with a sudden, blaring ringto...

How To: Knit the Ladder Stitch

The Ladder Stitch is wonderful for scarves, blankets, shawls. It might seem complicated at first, but once you get into the rhythm of it it goes along easily and it's fun to watch the ladder go up and up. Step 1: Row 1 (WS): P4 *k2tog Tbl, Wrap Yarn Twice, k2tog, p4; Rep from * to End.

Street Art Tricks: How to Blend 3D Prints into Real-Life Objects

While graffiti may never be fully accepted by the masses, it has already become a very large medium for creative artists across the globe, who make mundane and austere cityscapes a little more interesting for the rest of us. Walking past this Banksy stencil on my way to class (at UCLA) made my day. Art like this can cause people to stop and appreciate the otherwise boring and blank walls that surround the city. It can stir up artistic feelings, pensive thoughts, and other emotions stored insi...

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