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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
This how to video shows you how to style your hair like Zac Efron with American Crew molding clay. You will need the clay mentioned and a brush. First, comb your hair so that you have side swept bangs. Use a straightening iron on your hair if it is very curly and textured. Next, take some clay and rub it in your palms. From here, rub your hands through the back of your head to the front. Remember to work from the top of the crown to the front. Use the come to make any adjustments. Take more c...
John White, a Doña Ana County Extension Agent, highlights a new section on the show - a monthly checklist for the garden. This time, he talks about what to do in your garden in the month of February. The checklist includes planting dormant plants, pruning with a purpose and applying herbicides and pesticides. He shows us various types of dormant plants that can be purchased from nurseries in February for planting such as potted, bare-root or root-balled plants wrapped in burlap. As for prunin...
Blue corn is a special variety of corn which can be differentiated by the majority of the corn species by looking at the unusual top growth of the corn. It is a hybrid and grows very uniformly throughout. Now take a corn from the field and peel it off. You shall notice that it has a blue color corns. Blue color corns are hard from outside but they are very soft and tender in the middle. You can use these blue corns in making commercial products like blue corn chips, tortillas, and atole ’,‘ c...
Instead of paying to have someone else do it, learn how to flush your auto transmission fluid in less than 10 minutes by following this tutorial. Unknown to most people, is the fact that draining your transmission from the bottom, only removes about half of the fluid, while the rest remains. This tutorial shows how to do a complete flush. First, find out how much transmission fluid your vehicle needs by reading the owner's manual. You will also find out what type of product you need to use. R...
This video shows you how to light a bottle with long exposure in photography. The end result is to have a picture of a bottle with glowing edges with a black background. For starters you set your SLR camera settings to a 30 second manual shutter speed and a f5. 6 set aperture. Put the camera on a tripod for steadiness and set up your subject. For the subject, on a table, place your bottle in front of your chosen drop cloth. It is best to choose a color similar to the bottle. Then you use a li...
This video shows us ho to make an acne fighting toner out of aspirin. If you have an acne prone or oily skin, try a toner with Salicylic Acid or BHA in it. If you want to have an acne fighting toner that is cheaper than the commercial products then you must know how to make an acne fighting toner out of aspirin. Here's how: Put 10 tablets of aspirin in an empty bottle. Pour in Witch Hazel into the bottle. Pour about half of the bottle. Wait until the aspirin tablets are completely dissolved. ...
1. Shallow Bow You bump into someone in passing
Mr. Paul Righetti teaches us a Santa Maria BBQ tritip lesson. The beauty of Santa Maria Style barbecue is that it delivers big flavors while being relatively easy to prepare. You can even take some flavorful shortcuts with Santa Maria Style Barbecue products by Susie Q,s Brand and Cowboy Flavor, among others. So fire up the grill and let'€™s get started!
In this tutorial, amazing make-up artist, Kandee Johnson shows how to get Walt Disney's beautiful Princess Jasmine look from Alladin! Watch as Kandee transforms herself into a whole new her! (Get it? A Whole New World? A Whole New Her?)
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
This beauty video demonstrates how to create a daily makeup face routine.
Twilight, that steamy, dreamy love story between teen Bella and heartthrob vampire, Edward Cullen. This love story is based on a series of vampire novels (Twilight, New Moon, Eclipse, and Breaking Dawn) by Stephenie Meyer. True love, handsome boy, and vampire danger = perfect teen love story. Who's your favorite Twilight character? This makeup tutorial demonstrates how to create Rosalie Hale's makeup, based on the actress Nikki Reed in the Twilight movie.
Twilight, that steamy, dreamy love story between teen Bella and heartthrob vampire, Edward Cullen. This love story is based on a series of vampire novels (Twilight, New Moon, Eclipse, and Breaking Dawn) by Stephenie Meyer. True love, handsome boy, and vampire danger = perfect teen love story. Who's your favorite Twilight character? This makeup tutorial demonstrates how to create Bella Swan's makeup, based on the actress Kristin Stewart in the Twilight movie.
Twilight, that steamy, dreamy love story between teen Bella and heartthrob vampire, Edward Cullen. This love story is based on a series of vampire novels (Twilight, New Moon, Eclipse, and Breaking Dawn) by Stephenie Meyer. True love, handsome boy, and vampire danger = perfect teen love story. Who's your favorite Twilight character? This makeup tutorial demonstrates how to create Alice Cullen's makeup, based on the actress Ashley Greene, in the Twilight movie.
This makeup look is full or purples inspired by a Lancome pictorial for the Fall of 2010. If you want to go for sultry look with tons of purples, then this is the look for you, perfect for the autumn months. Marina Filipovic Marinshe shows you the steps to applying this look. Follow along with this Croatian beauty!
Looking for a decent late summer look for a night out on the town? This bronze and copper look might just be what you're looking for. And believe it or not, this makeup style was inspired by a fox. Yep, the animal, not the Megan.
Girls have it tough, especially when it comes to makeup. Although you don't have to wear makeup, it's practically unheard of to have not worn makeup at all. Makeup can be intimidating, almost like you have to be an artist, but it isn't that hard. Makeup could be easy to apply, and still look great. This easy beauty tutorial is based on peachy corals, great for summer and great for warming up the skin tone, whether you are fair, bronzed, blonde or brunette! It can work for everyone!
Watch this 8 part series to learn all about fake UGGs and the 7 deadly signs of UGG boots. You'll be surprised at how easily people can be fooled with fake products. Make sure your UGG Australia boots are the real deal!
In this how-to video, you will learn how to make potassium trichromate. You will need potassium chromate and dichromate. It is easy to go between the two. You can add a base to the dichromate to make the chromate. It will go from orange to yellow. The trichromate can be produced. You will need nitric acid, potassium dichromate, and sodium disulphate. First, make a solution of sodium sulphate. Take a long test tube and the potassium dichromate to it. Add double the volume of concentrated nitri...
The iPod kids shows viewers how to covert movie files that are already on your computer into a format that will work with your iPhone or iPod Touch (2nd generation).
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
County expert John White determines how to solve some pesky plant problems for the area. The first problem - cutter bees on Crepe Myrtle - is an obvious one, with the deep curved "bites" showing on most of the leaves. He suggests using an insecticide but then points out the signs of a second problem - beetle damage. Crepe Myrtle is prone to beetle infestations and he advises to get out a flashlight and look for them at night when they are at their worst. A problem with heat scorching on Euony...
This video demonstrates how to make your own Greeting Cards at home. You will need the following: water color paint in bottles with sponge tip applicators and spray, ruler, adhesive, solid color paper stocks, patterned paper, a rubber stamp, stamp cleaning products, a bone folder, and a trimmer.
Garden of Imagination teaches viewers how to make cute and adorable mini polymer clay pancakes for a dollhouse or decoration. First start out with a wooden square to put the finished product on. Next, start out with light brown clay and roll it out on a clay setting number 4 on the pasta machine. Next, use a circle cutter to cute the shape of pancake. Next, texture the pancake so it look doughy and make sure the edges are not too straight. Make three of these pancakes and place them on the wo...
Robert Steinken fro California, of ModernMom, instructs the viewer how to do a quick and easy Half-up half-down hairstyle! First, brush all of the hair back. Make sure all of the hair is brushed off the face and behind the shoulders. Next, you will want to section the hair by taking a section of hair just about the top of the ear. Go up to the crown of the head in the center of the hair. hold the hair at the top and pull the rest to the bottom. At this point, you will have the front section a...
Get all of the objects you use for your shave. Make sure your razor is sharp. Your daily shave should be a delight and not a chore. Start by washing your face with hot water. The hot water opens up your pours allowing your beard bristles so be pushed out. Message a pre-shave product into your face. This helps soften your beard. With a brush lather up your face paint brush style not in circular motions. The lather should be a nice thin even coat. This will help keep pores from closing. Shave y...
Edna shows us the basics of making buttercream frosting for professional, decorative cakes starting with the right ingredients. She uses a basic buttercream recipe, but makes sure that she does not over-mix the ingredients. She also explains how she used to use Crisco, but when the company changed its recipe to zero trans fat, she decided to started using real butter, which makes the frosting a lot less yellow. Additionally, use of Crisco, makes the frosting drier and much more crumbly. If yo...
Gigafide will show you how to slipstream Windows installations. You need to go to Vlite and download the program for Windows Vista. Install and run it. Select install at the main window. Use 7-zip to extract the ISO file. Next, go to that folder and run startcd.exe. You click next, agree to the terms and install it to the Vlite folder. Go to that folder, then Tools - x86 and select the file wimgapi.dll. Copy and paste that into the main Vlite folder. Go to Vlite, select your Windows Vista dis...
This video describes how to draw an anime face viewed from the front. Anime faces are enjoyed by everyone because they depict unique personalities. Anyone can draw an anime face using their imagination. These steps make it simple:
This is a great Halloween look for those of you who do not one to wear masks are a bunch of gory effects. You can even use this look for other dress-up parties. Princess Pinkcat shows you how to do her evil fairy makeup look.
This is a good way to kill bed bugs; they are annoying bugs. 1. Diatomaceous earth is in powder form. You will first take the cap off.
You can't go wrong with spaghetti and meatballs unless you are feeding a vegetarian! This awesome recipe will surely keep people wanting more.
Learn how to reduce your risk of allergies. Transform your home into a sanctuary for your eyes, nose, and throat by reducing the risk of allergies.
With a little muscle and a powerful cleaner, even the filthiest oven can look new. Since it's best to let the cleaner sit overnight, try to start cleaning before bed.
Limit asthma attacks by learning how to anticipate and prevent them. You will need: a medical doctor, knowledge of symptoms, warning signs, and triggers, preventive measures, a peak-flow monitor.
Make sure your winter wardrobe survives the summer by putting it away properly. Learn how to store your winter clothes.
People like Ralphige and The Jerky Boys have elevated prank phone calls to an art. Here’s how you can get in on the fun.
No better way to celebrate your love than with a face full of festive makeup. This Valentine's Vixen makeup look is great for going out on that special night, but can even be duplicated as pageant, recital, or any festive makeup. The cosmetic products used to create this look are from MAC, Barry M, Rimmel, and N.Y.C. Watch this video makeup application tutorial and learn how to do a flowers and hearts Valentine's decorative makeup look.
You have seen a match make plasma in the microwave. You have seen a compact disc light up. Now you are going to see why it is dangerous to put grapes in the microwave.
