Direct Match Search Results

How To: Do a High Gears soccer drill with Nike Bootcamp

Who would you back in a race between a scooter and a sports car? And which would you rather be driving? Changing speed is at the heart of top-level soccer performance, so every player needs a smooth-changing gearbox to win the races that matter over ninety minutes. Nike Bootcamp's High Gears drill gives you the tune-up you need to shift up and down the gears with ease when that match-winning sprint is on – for the loose ball, the last-ditch tackle, or that glimmer of a goalscoring chance. Nik...

How To: Play The Eye of Judgment on PS3

This how-to video shows how to play The Eye of Judgment for the Play Station 3. Have you seen Eye of Judgment for the PS3 which utilizes the EyeToy to allow you to battle other card enthusiasts over PSN? Well if you've had questions about how it's played or how Sony keeps cheaters from getting the better of you, check out this clip from the hosts of Epileptic Gaming who do a quick tutorial on how to play the game, and show you in real-time with two different matches.

How To: Pull off the quarters trick

Secret: The REAL secret to this trick? The real secret is to wait. Set everything up, tell everyone the rules, and... wait. Wait as long as it takes. If you've already done the match trick,, then you've captured everyone's attention... this is where you translate that momentum into a free drink. This trick IS SO unbustable, that you can let people work on it all night, until finally, in a fit of desperation, one of them will BEG you for the solution. Tell them that you'll be HAPPY to share th...

How To: Build a portable stink pen

In this how-to video, Kipkay shows you how to build a portable stink pen and you need a cheap pen, a bobby pin, and matches. Take apart the pen, save the spring, put the bobby pin through the center of the pen, and bend the edge of the bobby pin. Pull the pin back to fire and create one gross smell. Watch this video pranking tutorial and learn how to build a portable stink pen for practical jokes. Use this as inspiration for one of your April Fools Day pranks!

How To: Change List Colors & Icons in iOS 13's Reminders App for a More Customized Look

In iOS 13, Apple is taking the Reminders app more seriously. With its long list of helpful new changes, the app finally stacks up to other task managers like Todoist or Wunderlist. One of the changes is small but mighty — the ability to add custom icons to lists. Doing so lets you personalize each collection of reminders to your liking and can help you identify lists with just a glance.

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