Direct Match Search Results

How To: Earn the "Dodge This" achievement in Red Dead Redemption on the Herd mission

This achievement can be earned on the Outlaw to the End downloadable cooperative mission in Read Dead Redemption. To get the Dodge This achievement, start a private match with a friend on the Herd mission. Once the mission starts, select the bolt action rifle and the rolling black rifle. Use the bolt action as your primary weapon, and shoot the TNT crate next to the tent on the righthand side. Quickly switch over to your rolling black rifle. Have your teammate use one of the repeaters to weak...

How To: Create a defined name for a dynamic range 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Make grilled salmon with garlic, ginger, & basil sauce

Packed with rich omega-3 oils, fatty acids, and more protein than a WWE wrestler needs before a big match, salmon is a wonder food of sorts. Omega-3s protect heart health, boost your metabolism, and reduce inflammation (which means fewer pimples for those that are acne-ridden), while protein helps you lose weight by keeping you fuller longer.

How To: Draw matching cartoon eyes and eyebrows

Drawing eyes is often the most difficult part of nailing down a comic book or manga character, but also the most vital part. Eyes really animate a face, so it's important to master all types of eyes if you wish to become a good artist. This tutorial will teach you how you can contain the eyes and eyebrows in the same plane, or basic shape, to make sure they align evenly. When this sort of method isn't used, often people will draw eyebrows that are disconnected from the rest of the eye.

How To: Create a flaming face of fire in After Effects

In order to be taken seriously in the world of motion graphics tutorials, one needs to teach something that everyone will remember… some kind of face distortion technique. Jerzy Drozda Jr has his "Form Face" and Andrew Kramer has his "Demon Face Warp," so the only thing that can possibly match those terrific After Effects tutorials is… FIRE.

How To: Use the Media Browser Panel in Adobe Premiere Pro

This clip explains how the Adobe Premiere Pro CS4 Media Browser panel can save you time and keep your projects tidy. Also learn about Equalize Volume within Soundbooth to make volume matching files easy. Whether you're new to Adobe's popular non-linear editor (NLE) software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detaile...

How To: Build a storage box for your deck

Building a storage box for your deck is a smart way to add extra storage to an area usually not known for having storage. The great thing about using wood than plastic, is that is adds to the feeling of being outside and can be stained to match the look of your deck. This three part tutorial, will take you through the steps of building a successful storage box and shows you step by step.

How To: Texture a head with projection painting in Blender

This clip provides detailed, step-by-step instructions on how to texture a head with projection painting when working in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started texturing modeled heads yourself, take a look!

How To: Compare text with text & numbers with numbers in 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 634th installment in their series of digital spreadsheet magic tricks, you'll learn how to build logical formulas for counting with criteria or conditional formatting so that the comparison is between text and text or numbers and numbers. Text-to-number comparisons (e.g., 2003 to "2003") do not yield matches. Learn h...

How To: Use Spotlight to find files in Mac OS X

In this video tutorial, viewers learn how to use Spotlight to find files in Mac OS X. To activate Spotlight, click on the blue magnifying glass icon in the top right corner. Then type in the term to search. Spotlight will display all the documents and files that match your search. If you click on Show All, you will have more options in Spotlight. In the Spotlight Preferences, users are able to select the categories for Spotlight to search in or not search in. This video will benefit those vie...

How To: Fold a hanging origami ornament

In this Arts & Crafts video tutorial you will learn how to fold a hanging origami ornament from Ana Maria, an Origami artist. You will need four sheets of rectangular paper of two different colors. Take one sheet and fold it diagonally. Flip the paper over and fold back along the same diagonal again. Now fold both the protruding corners back to match the edge of the paper. Repeat these steps with the other three sheets of paper. Then you got to lock the four folded sheets as shown in the vide...

How To: Make a defense-splitting pass with Ricardo Kaká

This video demonstrates how to make a defense-splitting pass. You need to see three very important factors. The first one is you need to see the opportunity. Secondly, you need to choose the right moment. And third, you must be able to put the right weight on the pass. Learn to control your ball so that you are in the position to make a killer pass. Train yourself to be able to improve on these aspects. The more you train yourself the more you will be able to successfully do it in real matche...

How To: Find the Sandcastle Easter Egg in BattleField BC 2

Although not has highly popular as Call of Duty: Modern Warfare 2, Battlefield: Bad Company 2 is one of the few shooter games that is able to seperate itself from the arcade style of COD:MW 2. In B:BC2 you rely on strategy and teamwork in order to win multiplayer matches and the game. But if you're looking for something that will make you smile, check out this tutorial. In the video, you'll find out where the Sandcastle Easter egg is on one of the maps. It's just a small little thing, but is ...

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: Run lookup queries with two values 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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.

How To: Extract the word that occurs most frequently in 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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...

How To: Make a wedding bouquet fast and cheap

You will need pliers, scissors, fake flowers, stem wrap tape, and some pretty ribbon! Start by separating all of the flowers. Try and create a set of flowers that look nicely together. Match pretty colors with pretty colors. Make sure it is balanced on all sides and not too much of one color in one spot. Then wrap all of the stems together with the tape wrap. Then use the pliers to trim the stems. Then tape all of the stems together. Then you should wrap all of the stems in tissue paper. Cont...

How To: Compare two tables and list unique items 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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.

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 the BINOMDIST & NORMSDIST functions 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. In this Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...

How To: Buy a bikini

Cate Adair, of ModernMom, explains how to go about purchasing a bikini. First, realize that there are stores specifically for Bikinis in which you can buy pieces separately to mix and match! There are also varying bra cups and varying bottoms to pick what you like and what fits you best. A halter is best for support or a band top can be for those who may not have a larger chest. Some tops are even meant to pick up and support the chest, so you can pick these types also! Cait also warns that y...

How To: Paint a prosthetic wound

This video describes the coloring techniques to make a realistic gelatine prosthetic wound. The presenter chooses to use grease paint as it applies easily to the rubber gelatine wound mold. First, apply a base color to mimic that flesh tone around the wound and blend it until it matches the skin tone. Next the presenter applies red and pink tones to the wound, the idea is to mimic the color of raw meat. Highlights are then applied inside the wound to simulate fat underneath the top layer of s...

How To: Apply flawless falsh lashes by Illamasqua

This video teaches the secrets of applying flawless false lashes. An excellent summary is given below. First hold the lashes with tweezers to your eyelash to check the size of it. Cut it off a bit if the false lashes are big compared to your eyelashes. Now apply some glue carefully to the base of the false eyelash. Close your eyes and stick the false lashes to the base of your eyelash and hold it for a few seconds to let it dry. After the glue gets dried blend the false lashes to match with y...

How To: Pull water into a upside down container with a candle

This is an exciting video for kids of all ages! Do you know what atmospheric pressure is? You will after watching this video. Know any fancy names for water? You will after viewing this fascinating experiment. Mr. G gives you a list a supplies you will need and then he shows you how to do the experiment. The supplies are easy to obtain. You will need a lighter or matches, so adult supervision is required, but the experiment is easy to do.

How To: Hide screw holes with wood plugs

There are a number of ways to deal with screw holes that are visible. You can buy some wood buttons and put them in the holes. You put a little wood glue in the hole and then tap the wood buttons into the holes using a hammer. This is a decorative solution to cover up screw holes. If you want to completely cover up the holes completely put a plug cutter on your drill and cut a plug out of a piece of wood that matches the wood that the hole is in. Take the plug put a little glue on it and tap ...

How To: Do the Step it Up Nike soccer drill w/ Andrés Iniesta

Step up your game with Andrés Iniesta in Nike Bootcamp's Drill of the Week. When a game's deadlocked and there's no room for manoeuvre, it's the fastest feet that open up space for a match-clinching moment of magic. Now do what The Man says: shoot. Score. Relax. Nike bootcamp brings you this pro soccer drill training video. Brush up on your soccer skills & learn how to do the Step It Up soccer drill.

How To: Do the Nike soccer drill Shoot with Andrés Iniesta

A soccer ball. A 60 metre course. Nets at either end. And an instinctive hunger for goals. That’s all you’ll need for ‘Shoot’ – the latest Nike Bootcamp Drill of the Week. Watch a maestro at work, as Barcelona’s Andrés Iniesta shows how to shake off those tired legs and fire your team to glory in the dying seconds of a crucial match. Nike Bootcamp brings you this pro soccer drill training video. Brush up on your soccer skills with Andrés Iniesta and learn how to do the soccer drill Shoot.