This video tutorial will teach you how to format percentage numbers in MS Excel. Excel is a spreadsheet application that allows you to use calculations, graphs, pivot tables and much more to create the spreadsheet you want. You can learn how to avoid common mistakes that occur with formatting percentages and how to set the program to automatically format numbers as you type. This video will guide you through formatting percentages as you learn how to use MS Excel to make spreadsheets.
Fashion Demonstrator offers a short tutorial on how to prepare your self for a night out in high heels. First you start by wearing a pair of heels all day around the house, higher then ones you intend to wear later. This is to get your feet used to the feel and your self used to the balance. Then when you are ready, you switch to the pair of heels, with a still high but slightly lower heel then before, that you intent to wear out. The idea is that since you have spent the day in very high and...
This video shows how to add volume to short hair for anyone with flat or fine hair. Dean Banowetz shows how to add volume using the InStyler Rotating hot iron in this video tutorial. To use this tool, take a section of hair and then curl under to create body at the root of hairs. Do this all around the crown and sides. Then, repeat the same steps for the lower parts of the hair making sure to curl the hair to frame the face. You can fluff up the hair after you have curled a section to avoid h...
Richpin shows the proper way to replace an engine coolant temperature sensor on a Saturn S series. Before he explains the steps of replacing the sensor, Richpin covers the tools to use. Also, Richpin illustrates the types of tools to avoid before beginning the replacement process. First, remove the cap from the expansion tank and then tighten it the way it was before. Next, Richpin shows the procedure for locating the temp sensor. Then, remove the connector from the sensor. Afterwards, Richpi...
Marion teaches us how to use a technique involving lace and glitter mist to make the lace look vintage. The lace can be placed in a bucket to spray the glitter mist from Tattered Angels onto the lace. Doing this in the spray bucket allows you to avoid spraying anything else in your work area. Marion uses the Old Lace Glimmer Mist, Suede, Cream de Coco, and Sherbert spray colors for this technique. This combination of the sprays allows you to create an old and vintage look on lace that can be ...
This video gives a brief description of how to prepare and cook baby artichokes. Baby artichokes vary in size based on the season, may being the best month to get them. To avoid getting a bitter flavor from your artichokes be sure to remove the skin, this is best accomplishes by brushing,rinsing, peeling, and cutting all of the green outer layer until you can see the pale yellow inside. To preserve the color of your allow them to sit in lemon or vinegar water and drain completely when done. C...
Have you ever wondered how sumo wrestlers are able to obtain and maintain such massive figures? Joseph Stickland, an applied clinical nutritionist, will explain to you exactly how a sumo wrestler is able to do this. Joseph will also explain the health detriments and the dangers to this type of lifestyle. Joseph explains that sumo wrestlers will skip breakfast, exercise, eat massive amounts of calories, (10,000 calories at least) for lunch, take a nap, and then have another mega calorie meal f...
This video is a tutorial that gives very helpful tips to viewers on how to pass any urine screening THC test. Viewers will learn how to prepare for a THC test and how to successfully pass the test. This video is for those who are currently doing drugs. This video will benefit those who are doing drugs because it will allow users to avoid failing the test and any consequences for failing. Viewers learn helpful tips such as: do not eat before taking the test, drink water and exercise.
Tony D'Angelo demonstrates his method of making hard boiled eggs. He starts with room temperature eggs to avoid cracking the shells, adds water to cover them, and adds a little salt and vinegar to prevent the eggs from cracking. Once the water boils, he takes the pot off the heat and lets it sit for about 11 minutes. He uses salad tongs to move the hot eggs into a bowl of ice water. Once the eggs are cool he stores them in the fridge. He claims that using this method to make boiled eggs ensur...
Confused with how to use your protractor for Geometry homework? In this helpful video, Doug Simmons from free math tutoring provides easy to understand classroom examples explaining how to use both sets of numbers on your protractor. Provides easy to remember rules that will keep you from fumbling with the common confusions of protractor use. Doug also explains common mistakes that you should avoid in order to start getting the right answers in your math problems. Finally, math tutorials at y...
The best time to get a pomegranate is October to late January. The first thing in seeding and eating pomegranate is cutting it in half. Hold it on a cutting board and with a knife, cut it right down the middle. When you open the fruit, you'll notice that there are a lot of seeds inside. To remove the seeds, you'll need to go to the sink. Turn on the water and put a large bowl in the sink. Break the skin off the pomegranate in the bowl of water face down to avoid spilling red dye. Start pullin...
In this video, Patti the Garden Girl will show you how to put drainage holes in your container garden from galvanized steel containers. To avoid your plants sitting in water, you simply need a hammer and a nail that is about a quarter of an inch thick. You then should hammer about 10 small holes in the bottom of your galvanized steel planter. This should allow proper water circulation in your planter, preventing your plants from drowning. This is a perfect and easy way for any gardener who wo...
In this video the author talks about the secrets of quitting smoking forever. there are basically four tips to achieve this result. The first is you need to keep your hands busy, so that you can avoid the desire to hold a cigarette. Similarly you also need to keep your mouth busy, by chewing gum or anything to draw your attention away from cigarettes. It also helps to keep a pack of cigarettes in your pocket all the time to continuously remind yourself that you have to stop smoking and there ...
Knowing how to ride a bike is a fun and useful skill that kids can use well into adulthood. This video tutorial demonstrates a safe and simple way to teach kid’s how to ride a bike. Before taking to the streets, make sure the child is wearing a correctly fitted safety helmet. Support the child while they pedal from the street or concrete into a nearby grassy area. Early on, make sure to teach them proper bike-riding safety laws and be sure to keep the mood light and avoid showing any frustrat...
Getting errors when trying to crunch your numbers in Windows Excel can be frustrating, but with this fun and easy to follow guide to remove the "#DIV/0!" error. When the computer thinks you're trying to divide by zero, it produces an annoying error, but by following this video guide you can be free of that irritation. He goes step by step on how to edit the formula calculator so that it no longer produces the error, and even explains in detail why this is solving the error problem. You don't ...
Fixing a flat bicycle tire is a skill every cyclist should know. This video tutorial shows how to fix a flat tire on a mountain or road bike using a patch. The best way to avoid a flat is to keep your tires properly inflated between 40-60 psi. However, in the event of an accident, it’s important to pack along a patch kit, tire levers, and a pump. To access the damaged tube, release the brakes and remove the actual tire. Apply the patch and replace the inner tube for continued riding.
The dynamite sushi roll, also known as a spicy tuna roll, is a delicious dish. This video tutorial from Sushi Sushi shows how to make a sushi roll with crab salad, avocado, and cucumber, topped with spiced ahi tuna.
This video explains how to not answer an interview question from a potential employer. The question is "Share a goal you set for yourself." The interviewee answered the question incorrectly. She avoided answering the question by describing goals that she set for her employees when she was a manager. She also added that the company set a goal and the prize was a trip to Hawaii. Sharing a goal you set for others does not answer the question, and neither does a company goal.
Everyone wants trendy custom looking destroyed jeans and this video teaches us the best, and most practical way to destroy them yourself at home, avoiding the often huge markups stores can apply to these sorts of items. Taking the jeans that you intend to alter, you take a simple razor to the area you wish to rip, and lightly, in a sort of tapping motion, slash at it until you expose a whitish color in the material. Go all the way through if you wish to expose skin, but be careful where you d...
This video shows you how to quit smoking by keeping your mouth busy. By chewing on something you can avoid smoking. Edarem uses sunflower seeds to keep his mouth chewing. He placed them in his pocket in place of his cigarettes. Anytime he needed a cigarette he would chew sunflower seeds. After 2 weeks he stopped smoking by doing this. You can also take 3 deep breaths anytime you feel the need for a cigarette. You should consider the price of cigarettes when quitting.
For women who have short legs or who are pear shaped, Anna Saccone provides some tips on how to make those legs appear longer. For example, nude shoes which are the same color as your legs will make your legs appear longer, and avoid wearing shoes that have straps at the ankles. If you are short or have short legs, it is beneficial to wear high heels or platforms if you prefer them. Hot pants are discouraged and when possible, wear shorts that have a turned up hem. For any girls who would lik...
Wondering how to sharpen a kitchen knife?
This video demonstrates the proper way to deep frying a turkey. Before you start frying the turkey, you should make sure the turkey is fully on normal temperature and that your pot of oil is at 350 degrees. Turn off the flame of the pot and then slowly lower your turkey and submerge it in oil, making sure to avoid spilling any oil. Once the turkey is fully submerged in the oil, you can turn the flame back on again. The turkey should be cooked for 3.5 minutes per pound. If the instructions in ...
Have you ever dropped your iPhone or iPod in water? Learn how to fix it here. Water can be very damaging to electronics because of its conductivity. You can avoid short circuiting your device by following the directions in this tutorial. Discover why water can hurt your electronics and how to dry out a wet device from the inside out. Find out how to open the device and access the logic board. With materials as simple as a hair dryer and guitar pick, your device can be as good as new!
In a pot, simmer pork for 30 minutes and remove scum that rises to the surface. Keep stock. In a casserole, heat oil and sauté garlic and onion for a minute.
This instructional video shows how to make delicious scrambled eggs to eat alongside cooked cherry tomatoes, mushrooms, and sourdough bread. First cook up the mushrooms and cherry tomatoes in a heated skillet of olive oil with a dash of salt and paper. For a fluffier consistency, add butter and stir the eggs while heating them up, as opposed to pre-mixing in a bowl. Continue stirring while removing them from the heat to avoid overcooking. Serve on a plate along with the tomatoes, mushrooms, a...
A knitted cast on stitch is one of multiple methods for casting on your stitches, and is good for starting a scarf, or the bottom of a sweater. With this tutorial, learn how to do the cast on stitch. Beginning with a loose slip knot, knit a stitch, making sure to replace the original stitch on your left hand needle. This will provide the basis for all the subsequent stitches, making up the amount of necessary stitches you will need to cast off. Keep in mind this is not an elastic stitch, so a...
Are you slow in multiplying and dividing your fractions? Let Mr. Rider from Speed Math 101 walk you through an easy to follow marker board math lesson that will have you managing those numerators and denominators like a pro. With a simple and easy to remember process, Mr. Rider walks you through common examples, misunderstandings, and problems. Improve your speed and accuracy in math class with the Speed Math 101 method. Avoid the usual pitfalls of improper fraction reduction that might you l...
The video shows the user how to make their hands resemble those of a vampire. This is done by applying a thin layer of white makeup to the backs of the hand with a cylindrical sponge. The reason for only applying the makeup to the backs of the hands is to avoid coating surfaces you touch with the white makeup. It's suggested that you leave a gap between the makeup and the sleeves of your jacket as it does not spoil the effect and helps eliminate the likelihood that you'll get makeup over your...
This video chronicles various ways to scent your home. First of all, you can use scented candles. However, if you do not wish to constantly burn your candles and would like to avoid the risk of fire, you can use a candle warmer to just warm your candle, which also is effective in spreading the scent. Oil warmers may also be used to heat up scented oils that will fill up and scent your room. Using the many different techniques outlined in this video, you should be sure to create a nice, pleasa...
This video shows the viewer how to use paper tape to cover the joint between panels on a dry wall. The creator of the video does this using a 6-inch dry wall knife and a curved trowel. He first applies standard compound to the joint using the trowel. The compound should be applied evenly and the thickness shown is said to be around 1/8 inch. After applying the compound he then gently presses the tape over the joint. He then smoothes the tape on the wall, using a dry wall knife. While doing th...
Acne is a problem for many individuals and by following these 5 simple steps, you can be on your way to nice, acne-free skin. First, cleanse your face gently and not more than twice a day. Do not pop your pimples, which could spread the bacteria and allow them to get deeper into your skin. Avoid using too much acne medication, which could cause your skin to become too dry and irritated. Also make sure that you use noncomedogenic products. Finally, a healthy diet that has the correct blend of ...
This video is about the concept of "foofing" when shooting flash photography. For this, you need a camera with a flash that can be directionally adjusted. The process involves simply pointing the flash at either a wall or the ceiling, to avoid having the light from the flash strike the subject directly. This can create several different lighting and shadowing effects, giving photos a less "harsh" look, and also giving them a more "professional" look. The color of the wall or ceiling used will...
Learn how to whiten your teeth using Photoshop with this video tutorial. 1. First thing you will want to do is remove the padlock if your image has one. You should be able to find this in the top right hand corner of your screen or in the background layers option.
CHOW Video Intern, Lauren Stenmoe, shows the quick and tasty way to make your own fake blood for special occasions, such as Halloween. Don't settle for the pricey, disgusting fake blood! Instead, make your own and avoid the nasty taste and costly price.
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 is a Cheat Engine guide on how to hack this flash game - Particles. Kongregate Acheatment shows you how to hack Particles with Cheat Engine (09/23/09). This Particles cheat will give you a speed hack with only 2 balls.
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. They will help you avoid pitfalls and get your project up and running fast. In this DIY episode, see how to make a motion activated silly string shooter.
Snooze bar addiction is no joke. Learn how to wean yourself off this destructive, ugly habit. You Will Need:
The deltoids are the muscles near and above your shoulders. It goes on the front of the arm and it goes on the back of the arm to the shoulder. It gets really tight sometimes. One thing you want to find out from your person before you are doing a stretch on them on any part of the body is to make sure that they don't have any range of motion issues or any dislocations of the joint. Get expert tips and advice on massage and other treatments in this how-to video.
