Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
We learn how to identify a pecan aphid. There a few different types, some more harmful than others. Looking at the leaves closely we see shiny sticky spots on the leaves. This is called honeydew' which is actually the aphids waste. It is not harmful to the tree. The Black pecan aphids however cause brown discolorations on the leaves. They are necessary to control although mother nature offers a way since there are certain insects who actually eat their eggs. It is wise to first consider this ...
Love4Nails demonstrates a nail design consisting of black and white swirls and dots on a red background. She has already applied a base coat and two coats of red polish. The first step in making the design is the white swirl on the tip. Using the pointed end of a nail dotter, she dips it in the white polish and draws the outline of the swirl, and then fills it in. Next she does the black swirl at the bottom in the same manner.
This video is about how exactly to make a mini strawberry cane. Strawberry canes are sliced into small individual slices to look like tiny little strawberry slices. This how to video is made by Garden of Imagination. This cane is made using many different colors or polymer clay. Making a strawberry cane is much more time consuming than many other canes. You can use these strawberry slices for things such as a mini cake for doll houses. These pieces are normally glazed when on a final project....
This is a demonstration on how to use the PLL method to solve a Rubik's cube. The author informs that what people do before and after applying the PLL technique is very important. According to him, people usually tend to first align as many faces as they can, when they see a partial algorithm and then apply the PLL method, which is very time consuming. Instead, one should stop one step short of alignment, apply the Pll method and then align the faces completely. The author, however, points ou...
Sonya MacDaniel demonstrates how to make a fruit salad with strawberry poppy seed vinaigrette dressing. The salad has less than ten ingredients and is very easy to make. Also, the salad is much healthier than the one made using a pre-made dressing as you can control the amount of fat added. This salad is not just festive and pretty, but also helps you get your recommended amount of fruits and vegetables for the day! The fruit is layered on top of the spinach and then topped with the vinaigret...
Boiling vegetables reduces the amount of edible nutrients. Steaming is a simple way to cook your vegetables and enjoy all their helth benefits. Just rinse whatever you wish to steam and follow the tips in this helpful video tutorial. Steamed vegetables are great alone, or as part of a whole meal. If your vegetables are improperly prepared they can be less nutritious and not as healthy to consume. This video demonstrates a way to cook your vegetables without losing important vitamins and miner...
With the world being obsessed with obesity; where does that leave the polar opposite? Malnutrition should be equally important. In this video from the Youth Health Alliance, the concerns of the under weight person are addressed. After watching, you'll have a basic understanding of what is required to gain weight in a healthy way. It addresses the consequences of being underweight. It also describes both diet and exercise for healthy weight gain. It explains which calories are healthy to consu...
Is your computer's LCD screen getting so dirty you can barely make out what you're typing. Use a few household ingredients to keep a clear, sharp image on your LCD screen without clouding or scratching it.
Twitter has consumed the world, so make sure you're up to date on your Tweets. One way to do that is with Gwibber 2.0 on Ubuntu Linux, the computer operating system that could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to retrieve unlimited tweets with Gwibber 2.0 on Ubuntu Linux.
You'll never spend money on cocktail sauce again once you know how easy it is to make at home. Watch this video to learn how to make cocktail sauce.
Fiber is a very important part of a diet and most people are not getting enough. It's recommended that you consume a minimum of 25 grams of fiber per day if you're a female and about 30 to 38 if you're a male. Learn what to eat for a high fiber diet in this nutrition how-to video.
Watch this video tutorial to see how to make a ghillie suit, cheap and easy. But wait, what's a ghillie suit? A ghillie suit, or yowie suit, is a type of camouflage clothing designed to resemble heavy foliage. It's 3D camouflage, primarily used by military snipers and hunters, or to hide from terrorists. These camo ghillie suits include burlap and natural vegetation. Pull tall grass out, break down trees, hide yourself. Grab the burlap for less time consuming ghillie suit construction.
Whether you're a social type with a loooonnng list of friends or a PR gal with a bunch of people you've got to contact all at once to notify them of an event, it can often get time-consuming to type out the name of every single person you have to send the same email to.
Please do us a favor and preserve your cupcake's modesty by dressing her nakedness up in a sweet parka of strawberry-flavored royal icing. While we're aware of the challenges that frosting a cupcake produces (we've had plenty of occasions when we've ended up with more frosting on ourselves than on the cupcakes), this video lays it out easily for anyone to follow.
Disney's "A Little Mermaid" was one of our favorite childhood movies. It had suspense, a strong heroine, and lots of cute little sea critter friends, but we have to admit one of the biggest reasons we were crushing on the flick was because of Ariel's drop dead gorgeous beauty. With pouty red lips, a soft flush and gigantic eyes that were always interested and responsive, Ariel had brains and beauty; the whole package.
First of all, feel free to disregard the first 2:05 of this video, it is not a how-to but behind-the-scenes footage of this guy's short film. After 2:05, however, you will get a great tutorial on how to make a set of prop Wolverine claw quickly, easily, and cheaply. They are made out of cardboard and spraypaint, and as long as you don't do any closeups on them or require you Wolverine to open his hands with the claws out at any point (impossible in this configuration) they look plenty real. Y...
If you love playing the multiplayer mode for Call of Duty: Modern Warfare 2, then you might wanna try out the campaign. Although it may not be as fun for some, it's still a challenging game that offers players plenty of things to shoot at.
Learn how to make plastic costume chain mail for all your LARPing and Halloween needs. 1 Purchase enough 12" silver binding coil from the displayed suppliers for your project. 2 Using needle nose pliers, cut the rings as shown in the video. Make sure that there is plenty of overlap so the rings will stay closed. 3 Flatten the edge of the cut rings with your pliers. 4 Start to combine the rings together using the European 4 in 1 weave pattern. 5 Build squares of chain mail following this patte...
In this video she shows you how to paint party animal print nails. She starts out by showing you all that you will need. First a top coat is used on all of the nails. Next she paints each nail in three different colors, and the colors are pink, black, and yellow. She makes sure that each nail follows the same pattern. She then paints each section in three different animal prints with a small detail color. Last she makes sure that she ends with a top coat and gives them plenty time to dry.
Need help learning how to do a French twist or pleat? Learn from a makeup artist who will get you "twisting" in no time! To start you are going to make sure you have a few things: a smoothing/bristle brush, a comb/backcombing brush, and plenty of hair pins. Step by step, you will learn the tricks to a lovely French twist. Remember, that practice is the key to perfecting this style. Follow the tips in this video and you will be showing off a sexy up-do with a salon look!
Make this Sweet and Salty Party Mix with this video! Need a simple and delicious snack for your party? Look no further than this video! Watch this video to learn from Ricardo how to make a great snack party mix with some cereal and spices. Make plenty, as these will go in no time!
Forgot to take a few production stills on set? No problem, work with what you have... the actual video footage. See how to get photos from video with iMovie or Final Cut Pro 6.
Backpacking is easy with these tips. Get expert advice on backpacking, hiking, and the great outdoors in this video tutorial. Take action: keep weight off of shoulders, bring plenty of snacks and water, maintain healthy exercise, and consult a guidebook to determine an appropriate trail. John Flaherty, the instructor of this how-to video from Live Strong, has a great love for the outdoors. In 2003, John and his wife started Central Coast Outdoors in northern California. His company provides h...
Would you believe that you can use Reason as an all-in-one performance tool? This Reason 3.0 tutorial will show you how to generate beats quickly, on the fly, using advanced Combinator automation and Dr. REX loops a-plenty. Use of Midi keyboard a must! See how to generate music quickly without completely ripping someone off in this Reason 3.0 tutorial series.
Postural problems can lead to all sorts of problems, from back, hip, and neck pain to heartburn and digestive issues. Over time, balance problems, insomnia, fatigue, and even jaw misalignment can emerge. How you carry yourself matters.
A friend of mine is a classically trained chef, and she often invites me over to her house to eat whatever goodies she has concocted. A few years ago I asked her the cliché question that every chef is sick of answering: "What's your favorite food?"
If you're looking for a dance that is hot, full of emotion, and a great workout, salsa may be for you. Salsa is a dance that keeps both partners feet moving and features many twists and turns.
In this next tutorial, you're going to want to make sure you have plenty of time on your hands. That's because this boss battle is pretty long. You'll be going one on one with the sand boss Stygian. He's a giant, ugly worm that takes some time to defeat. On top of him, you;ll have to battle a bunch of enemies who are on foot.
In this video, Ian Castle tells us tips on how to handle mistakes while singing. The key to making sure you are staying in great focal condition is to warm up and warm down. Next, make sure you don't do too much talking on the day of a performance. Also, don't drink alcohol on the day of or day before you have a performance, as this can alter your voice and make it coarse and dehydrated. Remember to drink plenty of water and avoid breathing in cold air. Also, purchase a portable steam inhaler...
The great thing about woodworking is the ability to do whatever you want to something using various styles and tools. Whether you're making a bird house or a table, there are plenty of ways that this can be done.
In this video tutorial, viewers learn how to create a drawing space. A good drawing table has an incline and plenty of space for drawing on. But if you can't afford or don't have enough room for a drawing table, buy a piece of Masonite from the hardware store. Then simply lean the board on a desk or table. To hold the paper onto the board, use some tape and stick it onto the board. This video will benefit those viewers who are interested in art and drawing, and would like to learn how to crea...
A really cool feature in Camtasia 7 is the ability to draw directly on the screen during a recording. This is helpful if you want to circle something onscreen, or if you want to highlight some text during your screencast. There's plenty of other options also in the ScreenDraw feature. To learn out how to use it, watch this video, which will show you all the things you can do.
Perilla leaf is a great herb that has so many uses. For one, it can be mixed with different spices and seeds to make a great side dish, can be used to make tea, and contains plenty of vitamins and minerals. This tutorial will show you two ways on how to use the herb. One will show you how to make perilla leaf kimchi and the other perilla leaf pickles. Enjoy!
If you are new to Windows Vista or are just starting to set it up to share with other local computers, you will need the help of this tutorial.
YouTube user Leisurpro is here to talk to you about the different kinds of snorkels. Snorkels are an essential tool to snorkeling and scuba diving. So which snorkel is good for you? Well, first we have the children's snorkel which we want to make sure that it's not to overwhelming for the individual using it you also want to make sure that the mouth piece is not to big for the child, keep in mind that some children will be big enough to use adult snorkels. A semi-dry snorkel will have a canop...
Abigail Goss demonstrates a traditional Apostolic hairstyle, the vertical roll with pin curls. She starts by creating a poof, back combing the roots from the crown to the forehead. Then she creates a section of hair above the ears. She rolls this hair several times in one direction and then puts all of the hair into a ponytail at the base of the neck. At this point the style looks like a french twist with a ponytail at the bottom. She then coats the hair with gel. To make the curls, she takes...
In this how to video, you will learn how to break up with your boyfriend or girlfriend. There are plenty of good and bad ways to do this. A bad way of doing this is breaking up with your partner over the phone. Breaking up over instant messages is also bad. Texting can also be considered a bad way of breaking up. Also, never fake your death in order to break up. The best way to do this includes doing this in person. Make sure to tell the truth when you are doing this. Make sure to be careful ...
In this Software video tutorial you will learn how to remix popular songs in Audacity. Open Audacity. Go to file > open and find your song for remixing. Then go to effect > change speed. Select a percentage change and click OK. You can change the pitch by going to effect > change pitch and select something and click OK. Play it and see what the pitch change does to the original and select the one that you like. Under ‘effect’ there are plenty of other options available like ‘amplify’,...
Natasha tells us not wait until we get sick to take care of our health. Building the immune system will often prevent illness in the first place. The basics of a strong immune system are; plenty of sleep, clean water, good healthy food, and minimizing stress. She advises that as we age we need to take more care with our health, but developing healthy habits earlier on has long reaching benefits. Whatever a persons age, now is the time to adopt healthier habits and make sure the basics are bei...