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.
This is a great series of videos showing you how to solve simple algebraic equations. The first video demonstrates solving equations using addition or subtraction, the second deals with solving equations using multiplication or division, and the third shows how to solve multistep equations.
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:
An important part of surgery is knowing the various types of closures to perform. This medical how-to video demonstrates how to do a simple interrupted suturing technique. The simple interrupted suturing technique is especially good for simple laceration repair. Follow along and learn how it is done.
improvement and repair tips such as how to repair drywall or sheetrock, how to float drywall, how to replace door trim, and how to fix a window in this free home renovation video guide series.
Make a do-it-yourself shoe! This video sewing tutorial shows how to put together Simple's first DIY shoe. Watch and follow along to sew and assemble a hand-made shoe from Simple.
This beauty video demonstrates how to do fast and simple Urban Decay makeup.
HoloTube, a new unofficial YouTube app for the Microsoft HoloLens, brings a whole bunch of new content to the mixed reality headset. While it's nice to have, the experience feels focused on quantity, not quality. HoloTube has a simple interface most people will recognize. You get a page of video categories, and as you drill down through each option you're presented with videos to watch. You can view regular, flat videos on the wall (or wherever you like)—which has its merits.
In photography, bokeh refers to the blurry or out-of-focus parts of a shot. Bokeh can be good or bad—it all depends on how you use it. There are tons of ways to create a bokeh effect, whether you go the traditional route with lens filters, digital with Photoshop, or even from your iPhone. With filters, you can use the blurred spaces to produce different shapes and colors. If you have a DSLR and want to experiment with bokeh, this tutorial by Chris Perez over on Apartment Therapy will show you...
If you're at all like me, you constantly get frustrated that repeaters only boost redstone signals in one direction. It's annoying!
Make sure your neighbors don't mind before you learn to play the drums with Mr.G. In this new four part series, he is going to teach you how to play the drums. You'll start with extreme basics, including your grip, to learning a simple 16th note full measure. Watch this, if your sick of just "banging", whether it be pots and pans or a proper drum set.
Check out this music tutorial video that demonstrates how to play a simple guitar boogie in G. This instructional video provides fret diagrams and live action to show how to play a simple boogie in G. This video is aimed at budding fingerstyle guitar players, but can be adapted to a pick. Advanced beginners are also encouraged to watch and learn. Play a simple guitar boogie in G and improve your guitar playing skills!
Sure, there's six steps, by why are there eight videos? Well, why don't you just keep reading, or watching?
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.
Sometimes simple is the best way to do it, and what is simpler than green beans? Well, they aren't THAT simple, but the concept is easy to grasp. Green beans can make a fantastic side dish to any meal if you know how to cook them right. In this video, chef Jason Hill introduces you to a simple, but delicious green bean recipe with garlic and shallots.
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.
You may or may not have known, but mowing your lawn can actually help keep it healthy and promotes root growth. It also makes your yard look great and helps it stand out from any other bad looking yards on your block.
Want to turn on Mac OS X's simple Finder feature? It's easy! So easy, in fact, that this Apple accessibility guide can present a complete walkthrough of the process in just over a minute and a half. For details, as well as to get started enabling the Simple Finder interface yourself, watch this helpful how-to.
There are many different acting classes available in Los Angeles, so how do you know if you are taking the right type? Don't get stuck with a bad teacher, or learning the wrong method for your chosen field. This tutorial, hosted by actor Shaun Pilkington, will walk you through a few insider tips for choosing the right mentors. Follow along, practice your skill and make your Hollywood dreams come true.
Golden girl Jennifer Aniston never skips a fashion beat on the red carpet (maybe because she 9 times out of 10 wears black, which we know is never not flattering?), but when she stepped foot onto the red carpet last year at an event, she once again started a "Rachel" hair trend.
Letting your hair down is never a bad look, but sometimes the dependable choice turns into the dull one. Polish your hairstyle skills and your hair at the same time by watching this video on how to create a voluminous bun inspired by a look Jessica Alba recently wore to an event.
