Effective Match Search Results

How To: Diagnose and treat athlete's foot

If you spend a lot of time with your feet crammed into sweaty trainers, then you might be familiar with Athlete’s Foot. In this exclusive guide, Dr Harper discusses the symptoms of this common fungal infection of the skin on the feet, and how it is spread. She also advises on the quick and effective over-the-counter treatments available, and offers practical tips to ensure that your feet don’t mature into something that would feel more at home on a cheese board! Watch this video tutorial and ...

How To: Use a CPR Ezy in case of a heart attack

The aim of CPR is to preserve life by maintaining an adequate supply of oxygen to the heart and brain. Effective CPR prolongs a person's chance of survival until either a defibrillator arrives and can be used to shock the heart back into its normal rhythm or advanced professional life support is available. This how-to video shows you how to use a portable CPR Ezy when someone you know is suffering from a heart attack. This medical device helps you perform CPR on a victim in a constant rhythm.

How To: Buy a rake

Dr. Rick looks at a new type rake. When buying a rake look for something lightweight, something made of aluminum. That way there are no splinters and it is easy to handle. This rake has a nice soft place at the top and at the base where the hand fits, thus fewer blisters. Where it picks up stuff it's curved so when pressure is placed the rake folds back and is effective at moving grass clippings, wood chips or anything else.

How To: Use Quote Replies in Facebook Messenger to Prevent Confusing Conversations, Just Like in WhatsApp

Text conversations can get confusing fast. In the time it takes to type up a response to your friend, they can send you one, two, three, or more messages. Once you send the original reply, it no longer makes sense in the context of the chat. Clear up the confusion with Facebook Messenger's "new" quote reply feature, which shows both you and your friend exactly what message you're responding to.

How To: Use Beginner Python to Build a Brute-Force Tool for SHA-1 Hashes

Developers creating login systems know better than to store passwords in plain text, usually storing hashes of a password to prevent storing the credentials in a way a hacker could steal. Due to the way hashes work, not all are created equal. Some are more vulnerable than others, and a little Python could be used to brute-force any weak hashes to get the passwords they were created from.

How To: Booby Trap a Christmas Gift

Although Christmas is not a time for pranks and booby traps, but rather quality time with the family, why not have a little fun at the expense of your loved ones? Here's a simple yet effective way to booby trap a Christmas gift. You'll need the help of a balloon, but the end result will be hilarious. Just wait until Christmas morning and everyone is eager to open their presents. That's when the fun begins. Merry Christmas!!!!

How To: MAKE FIRE with a MAGNIFYING GLASS

90 seconds that could save your life. How to actually MAKE A FIRE with a lens, rather than just burning a hole in a leaf. (Or frying ants, which seems to be the other thing that kids like to do with magnifying glasses.) By forming your target material into an efficient ball, you will be able to start a fire even with very small lenses. Like less than an inch across small. The finer the individual fibres, and the more densely they are packed, the more effective is your ball of smigtin (smoulde...

How To: Apply subtle makeup and a wig during chemotherapy

In this tutorial, we learn how to apply subtle makeup and a wig during chemotherapy. First, create eyebrows with a pencil that matches your skin tone. After this, apply a white shadow to your eye and underneath your eyebrow. After you brush this on, you will then apply a smoky color to the creases of the eye and blend it in with the white color. From here, apply black eyeliner on the top and the bottom of the eye. After this, you can put your wig onto your head and then brush it and style it ...

How To: Replace an old doorknob and install a new front entry handleset

Tired of your old front entry doorknob? Get rid of it in lieu of something a little classier (and safer). A handleset is the perfect way to make your front door stand out, and this video will show you how to install one— specifically, Schlage Plymouth Handleset. You'll need a phillips head screwdriver, tape measure, battery drill, 3/8" drill bit and a Sharpie or other marking device. To see how to install the matching deadbolt, click here.

How To: Break guard position in Jiu Jitsu

In this tutorial, we learn how to break guard position in Jiu Jitsu. First, you will want to get into a position where you are over the body of the other person. Your arms should be held straight out so you are able to move and gain control over the other person. If their legs are around you, you can move your arms into place to block out their arms and lock in their head so they no longer have control of the situation. It may take you a few tries to get used to this, but there are ways to ta...

How To: Create fake blood effects

In this tutorial, we learn how to create fake blood effects. The easiest blood formula is to use soap and red food coloring, nothing else. It's the easiest blood to make and looks more realistic than anything else. You can also make blood out of different things if you want to make a more expensive version. Make sure you always add in red food coloring and make it dark to match the color of real blood. The liquid should flow so it looks like real blood. To create blood splatter, you will take...

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Check whether quantities are equal in two lists in Microsoft 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Edit HV20 HV30 video in Movie Studio or Vegas

First you need to do is to open up the HD video file of Canon HV20 and then you can set the project properties. So go to file, import, media and open up the video file. Now drag it to the timeline and go to file, properties, click on the file folder called "match media settings" and open the same video file which you just opened. Now click on apply and then ok. But now video proportion is not fine. To fix it go to option, preferences, click on video tab and check the box which says "simulate ...

How To: Pronunce "Ta'a" & "6a'a" in Arabic

In this tutorial, we learn how to pronounce "Ta'a" & "6a'a" in Arabic. First, become familiar with the families of letters by their pronunciations. It will be helpful to hear the audio of how these sound so you can match the letter with the sound. As you learn the "ta" and "a" sounds, you will see how they change in different words, so they aren't always the same. The pronunciation will sound more heavy in some words and lighter in others. Once you have learned these, you will be ready to lea...

How To: Crochet a left handed headband with optional flower

In this tutorial, we learn how to crochet a left handed headband with optional flower. To start, you will make the foundation by crocheting a single crochet 54 times. Once you have made the base, you can take another color and start to crochet it on top of the first foundation. You will use a single crochet on the top, then to make larger humps double crochet for part of it. When you reach the end, take another color and repeat the same process going over the last color. You can continue arou...

How To: Use present tense of Spanish AR verbs

In this video, we learn how to speak Spanish using present tense AR verbs. "Nosotros" means "we", "nosotras" means we as well, it's just talking about a female while the other is talking about a male. Common "ar" verbs include: necesitar, patinar, practicar, terminar, tocar, trabajar, nadar, hablar. These mean (in order): to need, to skate, to practice, to fish, to play, to work, to swim, and to talk. When you are talking about a male, female, or group of people you need to change the last pa...

How To: Create a shocking Cirque Du Soleil makeup look

Halloween is coming sooner than you think; have you decided what you're going to dress up as yet? While going with the wicked witch or sexy black cat route is always fun and unfailingly cute, the easy choice quickly becomes the dull one, especially if you're essentially worn the same costume time after time.

How To: Set up the calendar in MS Project 2007

In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...

How To: Tap a keg with various pumpers

In this tutorial, we learn how to tap a keg with various pumpers. There are around 5 different types of pumps you can use. Make sure your pump matches the keg that you have, to make your beer come out easiest. Also, make sure your keg is completely full when you purchase it, so the beer comes out easier. There are many different types of kegs, but no matter what type you have, place it inside of a large plastic bin with ice to keep the bottom as cold as possible. To use the pump, set it insid...

How To: Mix automotive or car paint

In this video, we learn how to mix automotive or car paint. To begin, you want to look at your car information to find out what kind and color of paint they used on it originally. Once you have this information, you can take it to an automotive shop and they can do a code search for what to mix together to get this specific color. You may have more than one option on how to make the color, depending on what it is and what year your car is. Next, you can have the paint made and tested to see i...

How To: Make a floral arrangement

In this video, we learn how to make a floral arrangement. Start off with the biggest flower you are going to use, and build around that. If you have a white flower, pick a bright colored one to go next to it. Remember to use different flowers and colors to mix and match and make beautiful bouquets. You will also want to remove the bottoms of the stems and tuck smaller flowers in between the bigger ones. Creating color contrasts can help make an eye-popping floral arrangement. You can start bu...

How To: Apply lipstick for dance and stage performances

Applying lipstick for the stage is different than applying lipstick for everyday. On stage you are going to want to make sure your lipstick matches anyone else in your performance so that you look uniform, and also choose a "loud" color so your audience can see your lips. In this tutorial, you will learn how to apply lip liner, lipstick and fix any mistakes you might make. This look is perfect for a performance because you want people to be able to see your facial features from far away.

How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Fix a small hole in your drywall

In this Home & Garden video tutorial you will learn how to fix a small hole in your drywall. This video is from www.fixitfromhome.com. The cheapest way to fill a hole is to get some dry wall compound, a plastic knife, sponge and a small brush. Take a little bit of the compound on the knife and fill the hole. Press it slightly so that no gaps are left inside the hole. If the rest of the wall has a texture, to match it with the texture, clip the end of the brush, make it damp and just brush the...

How To: Tune a ukulele by ear

WataAtaCrackah teaches you how to tune a ukelele by ear without an electric tuner. Just like a guitar, you start by getting the first string tuned and gradually work on the others. The first step is to get the right pitch of the G string, which is quite a high note. What the G string sounds like is demonstrated. Next, you work on your A string and this should sound like the G string with a finger pressed on the second fret. Then the E string is worked on. The sound of the E string with a fing...