New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
Syncing your bluetooth earpiece to your BlackBerry device can be tricky. But pairing your bluetooth enables BlackBerry with your earpiece is actually quite easy. Best Buy has answers. The Best Buy Mobile team explains how to connect a Bluetooth earpiece to your mobile device. See how to access connections set-up on your Blackberry and also see how to wear a Bluetooth headset.
Accidents are the worst. They're costly, time consuming and an all around pain in the butt. Rear-end collisions are among the most common types of accidents on the road. Take these simple precautions to avoid a rear-end collision.
Learn how to play "Black" by Tokio Hotel, an acoustic guitar tutorial. Follow along with this demonstration, tabs and lyrics here:
In this tutorial, we learn how to operate dynamic radar cruise control in the 2010 Prius. This supplements the conventional cruise control with a vehicle to vehicle cruise control. The radar system sees the car ahead and is less effected by bad weather conditions. The driver can select short, medium, or long driving distances. When cruising at a set speed that is faster than the car ahead, the vehicle will slow down to the speed of that car. A warning will be sounded to tell the driver to tak...
If you just brought home a Windows 7 notebook or desktop PC, but you can't figure out how to configure the WiFi connection to get internet on it, take a look at this guide to learn how to connect your Windows 7 computer to a home network.
Are you a Farmville fan? Looking to get ahead without all the time and hard work? This how-to shows you how to level up quickly and beat the system. This cheat is easy to use and will let you plant your corrupt seeds quickly.
Learn the basics of shooting videos in this video. This funny and informative video from Vimeo's excellent Video 101 series of tutorials demonstrates the importance of things like always carrying extra batteries, holding on to the subject for at least 5 seconds, using the rule of thirds to compose the shots, and planning the shots ahead of time.
In this video, we learn how to get a bigger butt with squats. First, place your feet wider than shoulder width apart. Then, point your toes out at a 45 degree angle and look straight ahead. Squat down as deep as you can while carrying a bar. Repeat this again, making sure you are keeping your head up and looking straight ahead. The deeper your squats, the larger your butt will be from the muscle you are building. Continue to do this for several reps, then add in more weights as your body gets...
In this video you can see how you can walk in high heels. Heels do not need to be long and thin to be considered fashionable. But no matter the length of your heel, take extra caution to keep your balance and place the least amount of strain on your muscles. Step with your heel down first, then let the sole follow quickly and smoothly. Walk with your toes pointing straight ahead or as close to straight ahead as possible. Swing your arms as you walk for balance. Keep your legs straight, close ...
This will show you how to think ahead in a game of chess, from no other than "How to Think Ahead in Chess" by I.A.Horowitz and Fred Reinfeld - Chapter 14 - Lasker's Defense To Queen's Gambit Declined: I - Simplification Leads to Freedom. Watch this three-part tutorial.
Did you know you can talk to more than one person on your iPhone? You can talk to two, three… four people, and it just takes a little knowhow. Conference calls are easy, so how do you set one up? Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up a conference call on an Apple iPhone.
If you need to make lots of frosting flowers (such as for decorating a wedding cake), you can make many of the flowers ahead of time and then let them air dry before putting them on your cake. This video shows you how to make hydrangeas, gardenias, roses and Gerber daisies out of buttercream frosting.
In this origami how-to, learn the art of folding a paper lily flower. This fold will start from the frog base, so if you already know how to fold the frog base, make one and skip ahead to the lily part. You'll need a sheet of origami paper and a pencil. If you use orange paper it could look like a tiger lily!
There are certain days in life on which you are practically required by law to look your best: Your wedding, major holidays when portraits are being taken, and your birthdays.
Teach your kids about the ancient Chinese abacus, often used as a counting tool, with the help of a fun arts & crafts project! In this Simple Kid's Crafts tutorial, learn how to construct a Chinese abacus for fun with your kids. This is the perfect project for children ages kindergarden and up! Help your kid's get ahead of the curve with fun, educational arts & crafts projects like this one.
Before you remove any wall in a home remodeling project, it's essential to determine if it's a load-bearing wall or not. If you rush ahead without making sure first, you just might bring the roof down on your head! In this video, Tim Carter, of Ask the Builder, will show you how to determine of a wall is load-bearing or not before you remove it.
Why spend money on a commercial ice pack when you can make one at home in minutes? Whether you're thinking ahead for eventual accidents or aches or you're in the midst of a first aid emergency, the quick and simple ice pack in this how-to video will help ease your pain. All you need is water, rubbing alcohol, a freezer safe, sealable plastic bag, and the instructions in this informative video.
The Thread Heads hang out at the Renegade Craft Fair in New York. Then they teach us how to make a bikini from an old tee! It's a ways into the video, so jump ahead if you just want the how to. Hot!
Oh, Waze—you know, that Google-owned traffic navigation app that tempts drivers into stopping at local food joints like Dunkin' Donuts and Taco Bell? Well, now you can even order a large iced coffee through the app before you even arrive at a fast food hotspot.
While I consider myself to be a pretty organized guy, there are often times where I just can't find a file I put on my phone. Most of the time, when I download a file it goes automatically into my Download folder, but when I use a third-party to download other files, like torrents, they could end up in a number of places. Filtering abilities on file explorers often fall short, so it was time to find an app that would automatically sort files in real time.
Every student with college aspirations should learn how to not only calculate their own GPA, but how to keep that GPA up! In this video, learn how to figure out your own GPA, whether you be in high school or college. Stay ahead of the curve by following this easy guide.
Sometimes a single driver can vastly improve traffic. Drive like a trucker: keep a large space ahead of your car. This can erase the patterns of stop-and-go driving (wipe out the Traffic Waves.) It can also break up the clogged merge-zones at certain highway exit ramps.
Forget the callsigns and titles from previous Call of Duty video games, Black Ops gives you something new to play with— playercards. Playercards allow you to create virtually any emblem you can possible think of because they're fully customizable, and emblem images can be colored, moved, rotated, flipped, resized and stacked on top of each other, with up to 12 emblem images layered at once. And if you're making Kyle Broflovski from South Park your playercard emblem, you'll need all 12 layers!
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to share files between Ubuntu (Host) & XP (Guest).
Go ahead and treat yourself to the true cinematic experience of Terraria in widescreen. Download this file and give yourself more side to scroll, more land to explore, more of everything when you take advantage of widescreen mode in Terraria.
Feeling the holiday blues? Then perk up your day - and prepare for the busy work year ahead of you - by mixing up this little sucker.
If you wait for the newspaper to come out with all the Black Friday deals, you'll have lost out on several hours of valuable shopping time! The best way to stay updated this Black Friday and Cyber Monday is by using smartphone apps!
There's nothing quite like drawing a venemous villian trying to throw a bomb at you to awaken your senses and get your fingers flexible for the drawing-filled day ahead.
Admit it: you're a die-hard Star Trek fan at heart. And you know that the best aliens in Star Trek are the Klingons. This video will show you how to count in Klingon. There's English subtitles, but pay attention to the pronunciation! Once you learn these Klingon numbers, go ahead and try it out on your friends!
Teach your children how to tell time by infusing a fun craft project into your lesson! In this short tutorial hosted by Simple Kid's Crafts, learn how to make an easy paper plate clock for children ages kindergarden and up. Get your kids ahead of the curve through fun and educational craft projects like this one.
Want to skip ahead in an eBook? Watch this computer tutorial video to learn how to jump to a new location in the Amazon Kindle. Jumping pages in the Kindle video will be easy once you've mastered the tips in this how-to video.
If you're looking for a way to make your XBox 360 profile stand out from the rest, then look no farther. Check out this video to learn how to edit your 360 bio to better reflect your personality. Just copy and paste the grid below into Notepad:
Go ahead and celebrate your individuality—just don't announce to the office that you're a lazy nut-job. You will need: awareness, self restraint, plants, clock, a bowl of candy and personal momentos. Keep politics and religion out of the decor. Keep collectables at home. Interesting not: Plants indicate you are dedicated to your job.
There's nothing to fear about a trip to the mall—as long as you plan ahead and shop smart. This video demonstrates the best way to budget your money, make the most of your time at the mall, and shop smart, budget conscious. Good instructional video for your upcoming Christmas shopping & holiday sales.
If you're like me, you put some or all of your houseplants outside for the summer. Now that fall is here, it's time to think about moving them back in for the long winter ahead. This how to video shows a few steps you can take to prepare your plants for indoor conditions. Following these easy steps should help ensure your plants winter over successfully, so you can get them outside again next spring.
Go ahead and take that bet. This how to video shows you how to win at a heads or tails coin toss every time.
Lye can cause chemical burns and the fear of getting burned prevents arts enthusiasts from making homemade soap. Watch this video to learn how to safely make lye solution so you can go ahead and unleash the creative child in you.
Kristin Holt from is here to show you how to get ahead in GTA IV just by using your phone in addition to the pigeon locations.
Hetal and Anuja show you how to make this super simple Indian dessert - Kulfi. A little like ice cream, Kulfi has it's own unique flavor. Try this make ahead recipe the next time you are having a party -- it's a crowd pleaser!
