Average Search Results

How To: Unlock your iPhone or iPod Touch to bypass the passcode

Back in the olden days, if a lock was, well, locked, you couldn't get in the door. At least, the average individual couldn't get in the door. But inventive and scheming folk (read: ye hackers of olde) devised crafty ways to pick lock keys and sometimes even created skeleton keys that opened any door or chest. This will let you unlock someones password on an ipod or iphone touch.

How To: Deal with being a flat chested girl

With the average woman a 36C, it can suck being the flattest girl in the room. Here’s how to make the most of what you’ve got! You will need better posture, the right clothes, the right bra, exercise and eye shadow. Small breasts age better, so don't feel bad about your flatter chest. Use these tips to enhance your natural flat chest.

How To: Create a Japanese dolly inspired makeup look

If you've ever been to the Harajuku district of Japan then you know that nothing is off limits to Japanese girls (and sometimes guys) when it comes to makeup. Whether they're dolled up in the Lolita style or the slightly racist Ganguro style (in which girls dress up as black-faced "average American teenager"), makeup shows off each person's personality.

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Do basic statistical analysis in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:

How To: Work with nominal, ordinal & interval scale in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...

How To: Properly prepare & cook spaghetti squash

There are many ways to prepare spaghetti squash but this video takes your through a quick and easy method. First, pierce your squash with a fork and microwave it on a microwave-safe dish. Note that you should microwave the squash for an average of five minutes per pound. In this video, the cook is using a 3 pound squash so she microwaves her squash for 15 minutes. After it's done cooking, allow the squash to cool and cut it in half to remove the seeds. Now you are left with the squash flesh. ...

How To: Remove permanent marker stains with toothpaste

This shows viewers how to remove permanent marker stains using toothpaste. First, you will want to do this in a bathroom or kitchen. Fill up a cup just barely with water. This should only be about 1 cm deep or full in the cup. Next, you will need to different kinds of toothpaste, preferably one a gel and another the average paste. Now, put the toothpaste into the cup, about quarter size, and use your finger or any tool to mix this with the water. Next, you'll want to put this mixture onto the...

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Prune hybrid-T roses

John White and Rosemary Maddox Master Gardner will teach us how to prune our hybrid t-roses. To begin, you’ll need a set of bypass pruners, long handles loppers for branches or canes, which are bigger than your thumb. You may also need a pruning saw, 10% bleach solution which is 10 parts water + 1 part bleach., an old dog bowl for the bleach, gloves, and a low stool. Begin with the bypass pruners clipping all branches that may be crossing or too close to the main branches that you will keep. ...

How To: Get women with Dr. Neder

This video has a man by the name of Dr. Neder and he has a book by the name, ‘how to be a man in a woman’s world.’ He answers a series of questions. The first question asked is how to get a girl with a boyfriend. The answer this video provides is simply that all girls are looking to date up. Meaning your value and assets, if there is a greater attraction then the girl will end up with you and dump the guy that she is with. Does size matter? The average size of most man is five inches to five ...

How To: Remove blue haze from photos in Photoshop

Learn how you can remove the blue haze from photos in Photoshop with this tutorial! 1. Select any image and right click on the menu click on Levels. 2. Select each and every channel and set input levels for red, blue and green and see the preview of the image. Set as RGB in Channels. 3. Now, click on "Sample in image to set gray points" and click on the area of the image which need to be set gray click on ok button. 4. From the picture icons select eye dropper and make sure it is set as 5 by ...

How To: Create the makeup look of Bella Swan from Twilight

Twilight, that steamy, dreamy love story between teen Bella and heartthrob vampire, Edward Cullen. This love story is based on a series of vampire novels (Twilight, New Moon, Eclipse, and Breaking Dawn) by Stephenie Meyer. True love, handsome boy, and vampire danger = perfect teen love story. Who's your favorite Twilight character? This makeup tutorial demonstrates how to create Bella Swan's makeup, based on the actress Kristin Stewart in the Twilight movie.

How To: Carve a raw chicken for dinner and save money

Gwen Schoen and Paul Carras share with you in this video how simple it is to save money by carving a whole raw chicken. You can save your pockets an average of 20 – 30%! First take out any insides; this is usually the neck, heart and liver when included. Lay the chicken on its back and start with the wings. Break the skin with a boning knife and pull the wing away from the body until the socket pulls out. Finish the incision where the socket meets and repeat on the other side. Then you’ll...

How To: Identify a mustang horse

This video is a tutorial on how to identify a mustang horse breed. The instructor begins by saying that it is not easy to identify a mustang horse because of the cross breeding characteristics of mustangs. The mustang shown in the video is larger then an average mustang. The instructor shows the mustangs white brand and all the different meanings along with age tagged along with the horse. The mustang is known for having feet that are larger then most other horse species. The most important s...

How To: Quickly find the area of a trapezoid

In this video, Mr. Maisonet provides a quick and easy method for calculating the area of a trapezoid. In the first step, The lengths of the two bases (the two sides of a trapezoid that are parallel to one another) are averaged. The lengths of the bases are first added together, and the sum is divided by two, yielding the average. The average is then multiplied by the height. The resulting product is the area of the trapezoid. This method for finding the area of a trapezoid is mathematically s...