Unique Selling Search Results

How To: Choose a perfectly ripe Tommy Atkins mango

Just because the grocery store sells produce, doesn't mean it's all good and ready to eat. Mangos are a particularly tricky fruit to get right… er… ripe. Tommy Atkins mangos the more common mangos, and are usually grown in Mexico (originally Florida). When choosing a Tommy Atkins mango, you need to look for a mango without bruising and with as much color as possible. Green is not quite ready yet. Red is excellent, but a beautiful mix of red and yellow is the best.

How To: Create a smokey eye look with Urban Decay Naked

Urban Decay's new makeup palette, Naked, sold out within minutes of debuting on Sephora and on Urban Decay's website. Why? Well, with eight universally flattering neutrals and four gunmetal gray shades, you can either do a very neutral, daytime look for work or amp up the glam factor with the smokey gray colors for night.

How To: Craft a briolette (drop bead) crystal necklace

We're totally not lying when we say that the necklace featured in this video sells for upwards of $100 at some fine retailers in Beverly Hills. Composed of a long, sparkly necklace chain and a teardrop shaped pendant attached with intricate wire wrapping, this is a necklace that looks a lot more difficult to make than it actually is.

How To: Make a healthy chicken wrap for your kid's lunchbox

With obesity now a confirmed epidemic in the United States, we should be putting more emphasis than ever on how we feed our children and what they consume at school. While many educational instititions sell salads and healthier options like apples and carrot sticks, these foods often don't catch your kids' attention when they're placed side-by-side with cheeseburgers and calzones.

How To: Create multicolored fur and hair in MAXON Cinema 4D

This tutorial will show you how to make your hair module materials multi-colored. There are also some tips on setting up lights to help sell the hairy look. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started creating rainbow-colored hair in your own Cinema 4D projects, watch this 3D model...

How To: Unlock any T-Mobile Google G1 Android phone for free

In this tutorial, learn how to save yourself the money you'd pay someone to unlock your Google G1 phone from T-Mobile and do it yourself in just a few quick minutes. This is actually a very easy process and this clip will walk you through the process step by step so you can freely use your phone on any network and not be limited to T-Mobile. This is also helpful if you wish to give away or sell your phone to someone on a new network.

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: Use new features for photographers in Photoshop CS5

Whether you're new to Adobe Photoshop or a seasoned digital photographer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...

How To: Hack Dragon Boy with Cheat Engine (11/19/09)

The maximum is a 1000 gold. In order to hack and win the game, he goes through several techniques choosing a level to start out, once a level completed and he collects one gold. He then selected a cheat engine in his Firefox page. He advised in order to hack the game, multiply the amount of gold you have times 8. At that point you have to sell something in the game. That created 2, so 2 times 8 is 16. Repeat the process. Then multiply that by 8000 to create 1000 gold which is the maximum amou...

How To: Plan for international travel

Betsy Sell and Tom Wilt of AAA Travel Services present this video to teach you how to plan for international travel. They teach you how to prepare the right documents, explain how to get a passport, and discuss travel insurance. They also discuss how to plan for emergencies and how to deal with different kinds of money such as travelers' checks. They also discuss how to pack, what to do when documents are lost, and safety tips. This video is the introduction in a series with this information ...

How To: Get the Most Value from Your iPhone Trade-In

Phones these days are expensive. The iPhone 11 Pro is presumed to start at $999, following the iPhone XS and iPhone X's leads. One way to bring down that cost is to trade in your old iPhone, but there isn't one clear-cut way to do that. You could trade your iPhone into a participating website or put yourself out there and sell the iPhone on your own. It's all about what's best for you.

How To: Replace the motor drive assembly in a Braun electric mens shaver (8583)

If the motor in your Braun electric shaver (Model # 8583) isn't working anymore, you'll probably need to replace it. But most of you will probably just junk the shoal mens shaver. And you don't have to— because you can fix it yourself! Just pick up a replacement motor drive assembly (Part # 7030-244) wherever they're sold, online or in stores. Then follow along with this video to see how to disassemble the Braun shaver and switch the motor assemblies.

How To: Pack jewelry business orders easily and quickly

So you've done it. You've been wanting to have your own jewelry business since you were six, and you finally saved up enough money to purchase all the materials and are now making more moolah than you can count with your on-trend wire wrapped earrings. But how do you handle packing and shipping so many orders without going crazy?

How To: Find asset turnover, capital intensity and inventory turnover ratios in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...

How To: Create a new buyer or seller account on Etsy

Looking for instructions on how to create a new buyer or seller account on Etsy? This clip will teach you everything you'll need to know. It's easy! So easy, in fact, that this video guide can present a complete overview of the process in just over two minutes. For more information, including detailed, step-by-step instructions, and to get started buying and selling crafts on Etsy yourself, take a look.

How To: Make your own thin-layer chromatography (TLC) plates

The price of TLC plates can add up. See how to make thin-layer chromatography plates (TLC plates) for a few cents each that are as good as commercial TLC plates that sell for a dollar or two each. You can use these home-made TLC plates the same way you'd use chromatography paper, but the plates provide sharper separations and require far less analyte. They also lie flat, and are much easier to store for later reference. For more information, including step-by-step instructions, and to get sta...

How To: Apply a Carrie makeup look from "Sex and the City 2"

Women around the world are getting ready to pack into sold out theatres for the release of "Sex and the City 2" this Spring. So, why not show up to the big premiere with a fresh and pretty makeup look inspired by Sarah Jessica herself? This look comes straight from Carrie Bradshaw and is sure to make any girl glow. Just because our girls' latest adventure takes place in the dessert doesn't mean they don't look fabulous in the sand. So, follow along and rock a Sarah Jessica inspired style in y...

How To: Create a contribution margin income statement in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.

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.