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.
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.
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...
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...
Ever worry about your breath after eating an onion? Well, follow along as food editor Ian Knauer gives us a trick on how to get rid of the dreaded onion breath.
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!
Basic materials needed to draw cool anime costumes are: Paper
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.
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!
Petrilude is a guy who does makeup. He gives great tips that are great for women to follow and use in their daily makeup routines. He also comes up with some amazing makeup looks inspired by celebrities and music videos. In this tutorial, he shows you how to get the same makeup look as Lady Gaga in her "Bad Romance" music video. You, too, can accomplish the same gorgeous, breathtaking look if you just follow his instructions.
Play "Scream" from High School Musical 3, an acoustic guitar tutorial. Follow along with this demonstration, tabs & lyrics here:
We like our Egg McMuffins around here, albeit homemade with our preferred ingredients: whole wheat (or homemade sourdough) English muffins, a slice of thick Tillamook cheddar cheese, a meat, perhaps, like Canadian bacon, and finally—that perfectly-fried, perfectly-shaped egg.
Injustice: Gods Among Us is one of the most popular games to come out over the last couple of years. It was a hit on video game consoles, and it's got a solid 4.5 rating on both Google Play and the iOS App Store, with almost 2 million people rating the game combined.
The lengths people will go to for a grilled cheese sandwich are amazing. They'll use irons, wafflemakers, or whatever appliance that produces enough heat to produce the perfect combination of golden, grilled bread and oozy, melting cheese. I personally favor my cast-iron skillet or the oven for making a really great grilled cheese sandwich. If I'm feeling lazy, then a toaster oven will do. But what if you're at work or in a dorm and the break room only has a toaster?
Turn a 'toy' radar gun into the real thing! Cops don't even have one like this! While this is a completely new and different design, the inspiration for this video is from an article by Ken Delahoussaye in MAKE Magazine. Just watch this video tutorial on how to hack a toy radar gun into a real one.
Outdoor lighting is an important part of your landscape. It's serves multiple purposes, but wouldn't you want to make sure you're getting the right lights, for both daytime and nighttime use? Lowe's has the answers to help you plan and install outdoor lighting in your yard.
In order to make a pair of baby shoes from gum paste, you will need the following: a pattern/template from Cake Central, gum paste, a paint brush, a knife, foam, mini flower cutter, rolling tool, a cutting tool, a quilting tool, dust brushes, snowflake luster dust, and edible glue.
Josh Copp and Madeline Donahue show us how to build a light table from pine wood and plywood utilizing two fluorescent light fixtures as the light source inside the box. The frame of the box is fashioned out of two 1X8 planks cut into four pieces so that two sides are 30 inches and two sides are 22 3/8 inches. The base of the box is made of plywood or OSB and is 30X22 3/8. Once the pieces are cut and assembled using a pocket hole jig and wood screws, the inside of the box is painted with whit...
Potato cakes are a great treat for entertaining some guests or just to enjoy on your own. In this video, Betty demonstrates how to make potato cakes quickly and simply.
You will be sure to win over anyone with some decadent homemade chocolate truffles. These are so impressive and rich and the best part is they’re surprisingly easy. Chef Alex will show you a few professional tricks to make this a sensational dessert.
This is a video that demonstrates how to make a homemade birthday cake. He uses a springform pan and brushes the entire inside with butter and dusts it with flour. He mixes flour and corn flour and puts them through a sieve. Using a mixer, he mixes eggs and then adds sugar, whisking it for about two minutes until it's light and airy. He adds flour and uses his bare hand to fold the flour into the batter. He pours the batter into the cake pan and puts it into the oven, along with another pan o...
This how-to video is about how to repair a leaky faucet. One of the most common problems with the faucet is the replacement of the rubber washer, which is located on the bottom of the valve unit. First, stop the water supply by turning off the stop valve at the bottom of the sink. Then, turn on the faucet until the water stops flowing. Next, remove the handle. To do this, we first need to remove the decorative cap using a screw driver or sharp pointed knife to expose the screw. Then, remove t...
Did you know that you can make a rocket out of stuff you might already have around the house? In this tutorial, you'll see how to make a candy rocket using PVC pipes, sorbitol (a sugar substitute) and other fairly common household objects. With just a little work, your sugar rocket will be ready to blast off into space. Sweet!
Systm presents this detailed tutorial on how to make a custom Star Wars style light saber. Luke, Darth and Obi-Wan's Lightsabers were pieced out of junk piles. David shows you how to build exact replicas and an original design from The Custom Saber Shop. Then he picks a fight with Patrick.
This how to video is a quick excerpt from a DIY show. In it the construction and installation of a box beam are demonstrated. Watch and learn how to assemble box beams for your next home improvement project.
What's cooler than a quad ATV? How about one that looks like a Hummer? If you just bought the Giovanni 110cc mini HUMMER then you definitely want to watch this tutorial and see every detailed step on how to assemble this quad ATV.
This instruction video shows how to assemble a paper star lantern. If you've purchased a paper star lantern and don't know how to put it together, this tutorial will show you how it's done.
Brian Sredd gives tips and pointers on how to assemble a new amp rack.
So you've been reading about how bad refined sugar and high fructose corn syrup is in your diet. And you know you should cut down on your sugar intake. But it's everywhere! How can you eliminate sugar and high glycemic food from your diet without suffering cravings?
The curling iron is both our friend and enemy. While there's nothing better to give you curls as voluminous as those buxom Victoria's Secret Angels, if they touch your skin you can end up with bad burns.
Sugar may be bad for the body, but it most certainly is good for the soul (and your taste buds). And now that the holiday season is coming up, you should feel free to let yourself indulge a little with small portions of flavorful treats.
Move over ketchup; salsa is officially America's favorite new condiment. This is great news, since salsa has infinitely less fat, calories, and bad artificial gunk than ordinary ketchup.
Brussels sprouts get a bad rep (mostly from picky kids), but they're actually super delicious if you prepare them right. Caramelized brussels sprouts bring out the best flavor because doing so exposes more of brussel sprouts' surface area to the pan.
If you pull the spark plugs out of your engine and they are covered in oil, that might seem terrible, but the problem really isn't that bad in all likelihood. Your probably have a spark plug tube leak, and this video will show you how to find and fix just such a problem.
Buns, thanks in no small part to ruler-yielding headmistresses and chunky cafeteria ladies, have the bad rep of being extremely severe. But they really don't have to look uptight.
Thanks to the movie "Beetlejuice" we will never say "Beetlejuice" three times in a row - ever. The campy, morbid flick centered on its title character, Beetlejuice, a "bio-exorcist" from the underworld with really bad teeth.
Just because your car shows an error code doesn't mean you should pull any parts. This video will show you how to confirm error code P 0340 on a Nissan (Bad Cam Sensor) by using a lab scope to check the cam sensor.
Quinn Fabray, as many of you probably already know, is the reformed bad girl on "Glee." Formerly a haughty cheerleader, she's now a mom and sings for the glee club happily.
Though rodents may have a bad reputation, a rat can make a great pet for kids. Rats need a good sized cage, lots of toys and regular trips to the vet to maintain their teeth and make sure they don't get sick. Follow these tips to keep your new pet happy and healthy!
Being an origami beginner doesn't mean you have to relegate your folding wanderings to measly cranes (though all that folding practice isn't a bad thing) and ninja stars or lucky stars.