Effective Bad Search Results

How To: Clean up a bad data set for a pivot table in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Survive a hangover

TVLesson has created a video on how to survive a hangover in two simple lessons, lesson one is drinking knowledge and preparation, and lesson 2 is drinking tips and hangover remedies. Lesson one breaks down what alcohol does to your body and how to prepare for heavy drinking. Lesson two breaks down what to do after you've had a lot to drink and that all you'll need to prevent yourself from having a bad hangover is patience, juices, ibuprofen, and a lot of rest. So if you're looking to prevent...

How To: Know if your girlfriend wants to break up

Dan and Jenn teach us how to know if your girlfriend wants to break up in this video. If the girl is saying that she doesn't deserve you, this isn't necessarily a bad thing. She may just want to make a point that you are really good to her and she doesn't know if you are the one for her. If the woman just got out of a bad relationship, you may need to give her a lot of time and space while she is going through everything. Just talk to your girlfriend to get a feel for the relationship and the...

How To: Potty train and housebreak a dog

In this tutorial, we learn how to potty train and housebreak a dog. There are a lot of techniques out there, but you will want to do in the most fast and effective manor. Some pet owners want to paper train their puppies. This may work, but it will take longer to get your puppy to associate going to the bathroom with paper. Don't let your dog pee in the house in the beginning, or this will let your dog think it's okay for them to do this all the time. Focus on all the aspects of dog training ...

How To: Avoid foods that raise cholesterol

Nancy Dell is telling us what fats are bad for us. Fats that raise cholesterol. There are two categories of that kind of fats which are bad for us one is saturated fats. Saturated fats are those fats which are extracted from animal like milk, cheese, butter, any cream, yogurt, meat etc. So you have to choose low fat milk to get protein, calcium from the milk.

How To: Create photo collages on a Microsoft Windows PC with Shape Collage

Looking for a free, effective means of creating digital photo collages on your Windows desktop or laptop computer? This clip will teach you everything you'll need to know. With Shape Collage, it's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over two minutes. For more information, including detailed, step-by-step instructions, take a look.

How To: Make your own eco-friendly laundry detergent

You may not realize it, but most of the laundry detergents that are being sold in supermarkets contain chemicals that can be bad for peopel, but more importantly bad for the water supply. People have begun to realize this and are starting to make their own household items from scratch using harmless items.

How To: Become a full time potter with Simon Leach

According to a recent survey, many of us work to live rather than live to work. That may explain the lack of satisfaction that most workers report at their jobs. While little job satisfaction can be attributed to a number of causes (horrible boss, bad pay, bad hours, etc.), there is first and foremost the prime mover. Many people are stuck at a job they don't want, sadly.

How To: Do makeup like Lady Gaga from her "Bad Romance" video

In this video, we learn how to do makeup like Lady Gaga from the "Bad Romance" music video. To begin, apply ivory foundation all over the face with a foundation brush. Now, blend the makeup out with a sponge then apply a finishing powder. Next, apply a pink and white eyeshadows that are both pale on the entire eyelid up until the brow bone. Once you get to the lid, put on a brown color to the upper eyelid above the white eyeshadow. Now, apply the white eyeshadow to the bottom of the eye and a...

How To: Bluff in no limit Texas Hold'em

There are some basic thing that you will need to think about, when trying to bluff in poker. Always think about taking advantage of being in position. Being "in position" refers to being the person who bets at the most advantageous time. This is the case, when you are "on the button": i.e. the last person to bid.

How To: Replace an A/C cabin air filter on a BMW E60 5-series

Just like with any A/C it's important that the filter be replaced every year to help make sure that it works properly. Not doing so can result in a lackluster A/C and bad air quality for you and others. The same holds true for car A/Cs as well. Not changing the air filter can be bad for the vehicle and lead to avoidable damage. So in this tutorial, you'll find out how to replace an A/C cabin air filter on a BMW E60 5-series. Good luck and enjoy!

How To: Deliver words to a cell via IF, AND & VLOOKUP in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.

How To: Modify a Nerf Big Bad Bow to shoot farther

In this Hobbies & Toys video tutorial you will learn how to modify a Nerf Big Bad Bow to shoot farther. Open up the front part of the shell by removing the screws. Make sure the spring on the launch piece stays together and pull out the barrel. Then dismantle the white restrictor piece and drill a hole in the center for more airflow as shown in the video. Now cut off the orange barrel as close to the wall as possible with a pipe cutter and sand it off. Take an extra piece of CPPC pipe and ram...

How To: Make your own laundry soap at home

In this video, we learn how to make homemade laundry soap! To do this you will need: one bar of ivory or handmade lye soap, borax and washing soda. First, grate your bar of soap and place into a large plastic container. Next, add 1/2 cup of Borax to your shredded soap followed by 1/2 cup of washing soda. Now you will need to mix this thoroughly, making sure everything is well combined. Now put this into a container with a lid on it and store for future use. You will use one tablespoon per loa...

How To: Prevent bad dog behavior with a kong toy popsicle

Are you sick of your dogs bad behavior? Such as chewing your furniture, bothering you while eating dinner, barking incessantly, and even stealing your slippers! Dee Hoult shows us how to properly use the 'Kong' toy to prevent all this undesirable behavior. It's simple, you just fill the toy with your dogs regular dog food, soak it with water, and put it in the freezer for 1 hour! Then you give your "Kong Pupsicle" to your dog, who will play with it for 30-45 minutes, getting the food out of t...

How To: Show vendor names associated with a low bid in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.

How To: Create bad teeth using Photoshop CS4

Nobody in the world enjoys seeing somebody with really bad teeth. Or enjoys kissing them for that matter. So this video is perfect for you pranksters out there looking to get revenge on a family member, friend, or even enemy. Find out what it takes to make rotten teeth using Photoshop.

How To: Teach kids simple golf drills

Conan Elliot is here to explain how to give effective golf drills to children. Using light and short golf clubs-made for young people-are a perfect fit for young children, as they are not too heavy and will not negatively effect their swing. First, have the child take the club in their right hand (or left if they are left-handed), and hold the left hand in the crease of the right elbow. Doing that during a swing can help guide a child into holding the arm into a perfect L shape while swinging...

How To: Avoid a bad finish to cure golf push shots

In this video tutorial, viewers learn how to avoid a bad finish to cure a golf push shot. Usually, when players make a swing for the ball, their arm separates from their body. This will take the club to the right of the target and as a result, pushes the shot. To correct this, connect your left arm to your left side as you make a swing. This will allow the club to stay with your turn and go down the target line. This video will benefit those viewers who enjoy playing golf and would like to le...

How To: Repair common problems with garbage disposals

Harry shows ways to fix common garbage disposal problems. First he shows if it hums use a crowbar to break free what is stuck. If you flip the switch and nothing happens it may be the red reset button on the bottom has popped out. He enplanes it may even be a bad wall switch or a bad breaker. He then shows you how to replace the disposal if that is what needs to be done. He shows you what to do if your new pipe is too short, how to properly wire your new one, and how to hook the drain for you...

How To: Cut a person or object out of a picture in Photoshop

Ok, so you ditched the ex like a bad habit but now every picture on your Myspace features their face? No problem! You can use PhotoShop to cut objects out of your picture or to make people disappear. This video shows how to do both of those so you can forget the bad memories and move on! After you master the techniques shown you can also use them to cut the background out of your picture and then replace it with a background of your choice!

How To: Cartoonize your videos with Cartoonr

Learn how to turn your videos into "A Scanner Darkly" style animations with this simple, quick and effective tool. Go to New Blue FX. Select your download platform and download the plug-in. Open your relevant software (this video example uses Sony Vegas) and note that the New Blue FX have been added. Open a video and pick an effect you like. If necessary, adjust the effects, until you are satisfied. Preview your video. If satisfied, render it and save. Follow these simple steps to turn your v...

How To: Cure a case of the hiccups

Getting troubled by hiccups? Watch this short video showing a simple but effective way to get rid of hiccups. A very practical remedy and all you need is a cup of water. Just one cup of water? Watch this out on what to do with one cup of water. Wait a minute without drinking and look for a couch or a bed to lie down with the level of your head lower than your tummy for sometime and repeat it. Now don't worry if you get hiccups.

How To: Multiply red fountain grass

In this video, Shirley shows her viewers an effective way to multiply your red fountain grass in order to create more grass from a single plant. After the growing season, find a large, overgrown patch of grass and use a shovel to dig out a section by the roots. After planting the grass in a pot, it is crucial that you shear the top of the plant so that the grass is only 4 to 5 inches tall. This will ensure that the plant focuses on growing roots rather than its blades at the moment. This meth...

How To: French braid bangs

Having a bad hair day? Here is the answer: French braid your bangs! Section your hair: taking the bangs with some of your hair and put it into three sections. Keep the rest of your hair aside in a ponytail. Each time that you go over the middle, pick up another small section of hair, going as far down as you want. Once you have added in all the sectioned hair, bobby pin it at the base, and there is the answer to your bad hair day.

How To: Use proper golf stance to hit the ball straight

This video teaches you how to hit the ball straight using proper golf stance. Golf tips magazine presents Joe Durant, one of the best PGA Golf hitters in the league. He first tells us the problems with bad posture in amateur golfers. He shows us the bad posture and then demonstrates why it goes wrong. Secondly, he shows us good posture. He bends his back slightly with a slight bounce in his legs. After following the instructions he says, you will be well on your way to hitting like a pro!