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...
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...
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...
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...
It is important to make sure the water is chemically balanced in your fresh water fish tank. If your water is not balanced, your fish may get sick and will not live as long. Make sure you monitor your fish's water and PH levels so that it matches your pet's breed.
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 ...
When you can't make it, fake it! Every girl needs a little hair lift now and then, and whether your mane is coldly ignoring all your attempts to boost volume or you're just feeling lazy, Secret Hair Boostias can add thickness without damaging your hair.
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.
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...
You don't want to look back at your prom photos going, "ugh, I wore that?!" or "oh my god, I look like I have a dead skunk on my head," do you?
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.
Forget the standard one-ended candle— this two-ended spinning candle beats even the biggest candle. It's a simple trick, which needs only a couple glasses (wine glasses used here), one nail, a long taper candle, and a lighter or pack of matches.
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 ...
This video illustrates how to apply foundation quickly and easily everyday. This process is done by using the following steps.
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...
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.
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...
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...
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...
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...
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...
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.
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 ...
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.
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.
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...
Cael Sanderson showing wrestling technique for Iowa state University Wrestling Camps. In this wrestling technique video Iowa State Head Coach Cael Sanderson Shows how to finish a shot when the opponent sprawls. You are trying to hook the ankle and increase your leverage.
What happens when you need to build a fire, but you forgot your matches and lighter? What if you don't know the fire-plow method, the bow and drill method, or even the flint and steel method (not that you would have flint, because you forgot your lighter)?
Need to spruce up (or wreath up) your trailer for the holidays? For this Christmas in your trailer park, let Jolene Sugarbaker show you how to make a classic trailer park Christmas craft... the wreath. This video will show you how to turn ordinary dryer sheets into a festive holiday wreath.
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.
Watch to learn how to make your mouth into a jack-o-lantern without burning the roof of your mouth.
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...
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!
Attention aspiring screenwriters! In this tutorial, learn how to sell that script. You may have written the next Hollywood blockbuster – but unless you can finance the film yourself, you’ll need to sell the screenplay to a producer who can make it come to life.
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.
Facebook really wants us to use Messenger. For the most part, they've succeeded; theirs is one of the most popular messaging apps right now. And with yesterday's announcement of new features, Facebook is only going to make their flagship chat application better.
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 ...
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.
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...
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...
