Workouts Match Search Results

How To: Make a cartoon character in Flash

This video will show viewers how to use Adobe Flash and how to make a cartoon character talk in this program. This tutorial covers aspects such as recording the voice of your characters, drawing their mouths to speak, and how to sync the recorded speech to the animation. Furthermore, this video will also show how to create subtle facial expressions that display emotion in the character. In order to record the sound, the host recommends a program called Audacity which has a free downloadable v...

How To: Solve the six problem solution

Solving 6 math problems using different methods is the idea behind this video. First, you make three rows of numbers vertically from 1-9. All the numbers match across for example, 1 1 1, 2 2 2, 3 3 3, and so on. Each set of numbers creates a mathematical problem who's solution is the number six. These problems require some thinking to solve. The only one that is immediately apparent is 2 2 2=6 which is, of course, 2+2+2=6, (3x3)-3=6, the square root of 4 =2. This done on all three of the four...

How To: Create a sheer and flirty school picture day makeup look

You only get one picture day per year while you're in school. It only takes a minute or so, but the results of that one shot stay with you for life in the form of your yearbook. So instead of being the one girl who got too lazy to put on makeup and then sneezed in your photo shoot, turn up your game a little this year and be the perfect model for your picture. Makeup done for photograph purposes requires a bit of extra effort.

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