Homer Simpson would have an absolute fit over this delicious-looking kawaii donut pillow. Embellished with a thick layer of strawberry frosting and then topped lightly with candy-colored sprinkles, this pretty donut looks almost good enough to eat.
This crafty project is inexpensive, it's easy to do and it's really handy for attaching things like letters, photos and to-do lists. This isn't like a cork memo board, because you won't need any push pins or cork pins! Watch and learn how to make this French memo board. This is the pretty alternative to drab store-bought memo boards.
Do you know why we hate those envelopes that come with any greeting card you buy at Hallmark, Papyrus, or a drugstore? They're SO boring. Always the same rectangular shape, always the same opening mechanism, with the only innovation for each envelope being the color, which does vary to match the card.
Got ninja skills but no ninja costume? The solution is simple... a plain, black T-shirt. That's pretty much all it takes to be one hell of a badass ninja on Halloween. Well, you should also wear a completely black matching outfit that has long sleeves and pant legs.
What's so genius about this project? yeah, it may just seem like a plain white piece of paper that you fold a bit to stand up, but you're actually getting two beginning origami projects for the price of one. That is to say that if you learn how to make the origami tent in this video, you'll also be learning how to make a pyramid.
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).
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.
If you ever wanted to tether your iPhone but found your carriers’ prices ridiculously high, then meet HANDYLIGHT. This $0.99 iPhone app has a nice hidden feature. It will allow you to connect to the internet using your iPhone (i.e. tether). There’s no guarantee that this app will stay in the app store much longer (or even on your phone after you purchase it), so use it at your own risk.
Jam tracks/backing tracks act like an instantly available band: while you play riffs on the lead guitar, backing tracks add the bass line and help ground your beat. This allows you to practice anything from major scales to minor scales. A drum beat is included to keep you strumming on the right beat.
Are you having a monster mash theme party for Halloween? If you're looking to really spice up your festivities, then match your ghoulish monster decor with your party eats.
In this video, we learn how to film skateboarding. First, get a camera that fits your price range and you will be ready to start filming. Next, use a long lens so you capture the best shots of people on their boards and in motion. Next, make sure you capture the lines that the skateboarder is skating on. Use different angles to get the best shot possible. You want to get close to the action, so you will need a fish eye lens. Use your skateboard to follow the skater around. Using these simple ...
Due to the downturn of the economy, many smart shoppers have turned into smart crafters instead. Whether it's making crafts for your home or for friends, crafting saves money (we're talking a $2 craft versus a $50 present for a friend's birthday present).
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.
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.
Want to feel like unemployed royalty? Then ransack your kitchen and whip out some olive oil and honey and make yourself a luxurious and super hydrating hair mask that'll have your tresses driving like a Benz at the price of a tricycle.
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...
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.
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!
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...
If you're anything like us, then you find it pretty ridiculous that whenever you purchase a gift card, you have to shell out nearly twice the amount of the gift card in order to put it into a neat, pretty gift card holder.
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.
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
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...
