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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
The Dolphin Plank yoga exercise is a test of endurance and strength, focusing on your shoulders and upper back and challenging your balance. The Dolphin Plank is a great move to lead you into the Wheel pose, a deep back bend that requires you to open the hip flexors and shoulders.
How To Filet Crochet - Part 1 We we first heard the term "filet crochet," an image popped up in our minds of chicken fillets from McDonald's, only made from crochet yarn (yes, we were also quite hungry at the time). Well, we'll have to save the yarn foods for another time, because a filet crochet is actually a very complex, difficult crocheting pattern that requires a graph in order to get the stitches right.
We're totally not lying when we say that the necklace featured in this video sells for upwards of $100 at some fine retailers in Beverly Hills. Composed of a long, sparkly necklace chain and a teardrop shaped pendant attached with intricate wire wrapping, this is a necklace that looks a lot more difficult to make than it actually is.
We have no doubt that famed photographer Annie Leibovitz takes perfect photos right at the photo shoot that require minimal retouching. But for the rest of us, as it is for most photographers, the photo editing process is just as important as the photo taking process, if not more important.
Pecan prailines are the foodstuff our ice cream parlor dreams are made of. With copious amounts of sugar, deliciously sweet prailines, and a nice toffee crunch that accompanies every bite, pecan prailines are the perfect treat to serve alongside plain vanilla ice cream and a soda pop (yes, we're piggies like that).
We've got a little secret to share with you: Being a master cupcake chef doesn't require you to be a baking whiz or even have a degree from a famous culinary school. When it comes to good cupcakes, decorating yours to pro standards is easier than you think.
Even though Christmas and the winter holidays have now passed, January is just as chilly and requires equal amounts of hot chocolate and steaming hot baked goods from the oven to warm your kids up after getting a good chill outside.
This simple After Effects tutorial from Laurence Grayson will show you how to use CC Ball Action effect in AE to create a realistic scrolling LED signboard effect, like the ones you see at conference centers and football stadiums. Then end result can be altered to suit your project, and corner-pinned into a scene. There are no plug-ins required, and this method uses the standard toolset in CS3, CS4, and CS5.
While there exist many makeup tutorials out on the web, you'll seldom find one that applies to all skin tones. Darker skin tones in particular require a different outlook in terms of color intensity and application.
Do you play an intensive sport, like soccer or football, that requires you to be able to not only run quickly towards a target area far away, but also to be able to catch a flying ball with precision that far away? Then you'll benefit from the speed and quickness training methods presented in this video.
In this video tutorial, viewers learn how to create a tessellation. The materials required for this project are: index cards, scissors, pencil, large paper and coloring utensils. Begin by preparing a shape. Cut the index paper to a desired shape. Then place it on the right side of the large paper and tape it. Now trace the shape onto the large paper and continue transferring the shape until the page is filled. The shapes should fit together like a jigsaw puzzle. This video will benefit those ...
If you're having a difficult time trying to get some of the green stars in the hit Nintendo Wii game, Super Mario Galaxy, don't worry, help is on the way!
Like billowy, bohemian tops or billowy dresses that go aflutter in the wind? Then this is the perfect DIY fashion tutorial for you. Using a long old skirt you can probably find by digging through your own closet or your stylish mother's treasure trove, you will learn how to refashion the skirt into a full-body dress by simply adding some spaghetti straps.
Eating healthy requires preplanning most of the time, but if you're looking to eat healthy and are strapped for cash and time this is an easy recipe to make which will both speed up weight loss and muscle gain.
You're probably under the (false) impression that building wads of Hulkish muscle also requires wads of cash, because most muscle builders have complete gyms filled to the brim with weights and tabatas.
Most people don't commit to an exercise program because it seems too strenuous to do either before work (which means in the wee hours of the morning) or after work (when you've had a dull pain gnawing at the back of your head the entire day and had a shitty day at work and commute home).
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to apply quadratic functions in algebra.
When your clay is too tough and not malleable beneath your fingertips, you've got trouble. Pottery, after all, requires smoothe and flexible clay that can be molded into any shape you desire.
Want to dress up like Rihanna for Halloween? Okay, we're totally kidding, but you should watch this special effects makeup tutorial if you're looking to wear a costume that requires facial scarring and bruising this Hallowen.
You don't have to own a Cricut, several volumes of themed scrapbooking paper, pinking shears, and ribbons in each color of the rainbow to call yourself a crafter. More complicated crafts do call for this kind of deep and expensive preparation, but the craft presented in this video practically requires nothing.
In this video tutorial, viewers learn how to make fondant. The ingredients required for the fondant are: 1 tablespoon & 2 tsp of unflavored gelatin, 1/4 cup of cold water, 1/2 cup of glucose, 2 tablespoon of vegetable oil shortening, 1 tablespoon of glycerin coloring and 1 tsp of extract. Begin by mixing the gelatin and water, and leave the mixture for 2-5 minutes until it thickens. Then place the mixture on the top of a double boiler and stir until it dissolves. Now add glucose to the mix. N...
It's one of life's little ironies that achieving beachy, messy hair requires not just riding a wave at the beach but rather staying in the shade, as it were, at home and spraying on zillions of gallons of hair products and using various curling irons and flat irons.
God knows there are a lot of shabby sandals around today. The only solution to the perfect pair of flip-flops is to mod them yourself. Add a little glamour to your sandals and see how to glam up your flip-flops in this video from GiannyL.
When you begin practicing intermediate to advanced yoga, you have to challenge yourself with harder poses like the handstand, which requires a strong core and ripped arms. Though after practice the handstand gets easier to do, we know you're only human and have some off days.
In this clip, learn how to tether your rooted Droid to a WiFi network and use it as a modem for your other Wireless devices. This process is pretty easy and only requires a network and that your phone be rooted.
You may think that, like cooking, there exists a set number of static routines/recipes without much innovation or change. But new exercises are invented all the time.
Many stage productions will require exaggerated eyelashes. The fake lashes make your eyes stand out, even from far away. You can use these lashes for anything from dance competitions to acting performances to Halloween to a night out!
Tutus are a fun part of childhood for many little girls, and in this tutorial, you will learn how to make a no-sew tutu with your kids. This skirt is super easy to make and your daughter will enjoy doing it.
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 ...
Looking for a fun, creative gift to give someone for Valentine's day? Then, this is the perfect tutorial for you!
This video describes how to make Thai Pasta Noodles. The commentator first lays out all of the ingredients on the table and tells the amounts required for the recipe. The cooking begins with the preparation of the sauce by combining chicken broth, soy sauce, and peanut butter in a measuring cup. Then, garlic and ginger are added in a pan with vegetable oil along with the red pepper, red chile flakes, and finally, the chicken breasts. Once the chicken is almost done, the cilantro and green bel...
In this video tutorial, viewers learn how to make a volcano. The materials required are: baking soda, red food coloring and vinegar. For the base of the volcano, users will simply need to use a cup and cover it with some dough in a shape of a volcano. Now add 1-2 tsp of baking soda into the volcano. Now add in a few drops of red dye into the volcano. Then pour in 1 cup of vinegar into the volcano. This video will benefit those viewers who are interested science, and experiments and would like...
Learn from Betty Crocker Kitchens, how to easily and quickly make a dinosaur birthday cake. You do not need a special cake pan for this recipe. She uses two 9" round cakes, to cut all the shapes you need to make the dinosaur. It is only required to cut out 3 shapes, and you can print the templates from their website. After the shapes are cut, you use the frosting to "glue" the cake to the platter you are working on and then spread a thin layer of the frosting all over the cake to seal in the ...
This video describes the process of split and cutting concrete blocks. For splitting concrete blocks, a hammer as well as a chisel are required. For cutting concrete blocks, you can either use a skill saw with a masonry blade or a masonry saw. Next, proper safety guidelines and equipment are discussed. For splitting masonry blocks, two types of blocks that are manufactured with splitting notches are shown. To split these blocks, they must be scored with the chisel along the entire length of t...
In this tutorial Brandon from Pocketnow.com will show you how to set up and use your remote desktop on a Windows mobile smart phone. Windows mobile remote desktop allows you to remotely access and control your Windows computer from your cellphone device, it is just like controlling your computer but in the palm of your hands. This guide will also show you how to get the Remote desktop software on your cell phone device if you don't already have it. The remote desktop requires for you to have ...
This is a great instructional video on how to make sauteed garlic asparagus. The main ingredients required to make this wonderful food are three table spoon unsalted butter, two cloves garlic chopped,one bunch fresh asparagus, quarter teaspoon kosher salt and quarter teaspoon ground black pepper. First melt the butter in a big skillet over medium-high heat. Once the butter is melted add the garlic. Then add asparagus spears and salt. Finally add pepper to it. Now cover it and cook stirring oc...
Healthy Kids Rock demonstrate how to make your own garlic butter. Making garlic butter is easy and requires only a few simple ingredients and techniques. To make the garlic butter first,roughly chop three large cloves of garlic. Then, sprinkle salt over the garlic and mince the garlic with a knife. The garlic should take on an almost pureed texture. Then add garlic puree to 500 grams of softened butter. Next, chop a handful of parsley and add it to the garlic butter mixture. Once the herbs ar...
This is a demonstration of making a hand tied bouquet.Keep all the required articles nearby on the table.Take a few stems of lemon grass and bind them with a wire to form a single bunch.Tie the aspedestra leaves in a loop with wrapping a wire to the stem.Now take the stems with single flower like movie star roses or carnations or iris or tulips pluck or cut the loose petals.Now hold one of the stems loosely in the left hand,now with the right hand place the second stem so that the flower is o...
