Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn about the SUMIFS function and how it blows SUMPRODUCT away when it comes to calculation speed.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to count unique records with a formula with a helper column to speed up calculations.
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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
Looking for a more efficient way to shoot video & stills? In this video, learn how to work more efficiently by using a laptop for capturing video and stills with the Canon EOS 5D and the 7D. Pull focus with a UMPC laptop (a EOS utility) to get the job done well.
P. Allen Smith talks with Shawn Hatley of Brae Water about the rain water harvesting system at the Garden Home Retreat. Begin by digging a very large hole. Simple rain tanks conveniently fit into the large dugout. This instructional landscaping video to save up to half a million gallons of water in a single year. Collecting rain water is a cost efficient way to save water and energy while maintaining your garden.
Watch this instructional yoga video to do the stoop pose. This yoga pose is also called the Hindi squat. The stoop pose is a simple and efficient exercise, but you should make sure you are doing it right. The squat pose opens up the hips and pelvis. Use a blanket or mat to protect your joints.
Watch this instructional stretching video to stretch the calf muscles. Stretching your calves is a simple and efficient exercise, but you should make sure you are doing it right. Stretch your calves to the point of mild discomfort but not pain. Hold each stretch for about twenty to thirty seconds.
Watch this instructional stretching video to stretch the hamstrings. The hamstring stretch is a simple and efficient leg exercise, but you should make sure you are doing it right. Repeat this stretching exercise in several positions to extend different aspects of the hamstrings. Hold each stretch for about twenty to thirty seconds.
Watch this instructional stretching video to hyperextend the back. This dorsal exercise is also known as superman. The back stretch is a simple and efficient exercise, but you should make sure you are doing it right. Repeat this hyperextension exercise about ten to twelve times.
Watch this instructional pilates video to do the grab and snatch exercise. The pilates grab and snatch is a simple and efficient exercise, but you should make sure you are doing it right. It's important to pull your navel in toward you spine, round your back and breathe properly.
Watch this instructional pilates video to do the full teaser exercise. The full teaser is a simple and efficient exercise, but you should make sure you are doing it right. It's important to pull your navel in toward you spine, round your back and breathe properly.
Watch this instructional fitness video to learn how to run steps. You need to find a stairwell to learn how to run steps. Running up stairs is a simple and efficient exercise, but you should make sure you are doing it right. It's important to walk down the stairs quickly but safely. Try a more advanced stair run by skipping steps.
Watch this instructional fitness video to learn how to jog faster. Running is a simple and efficient exercise, but you should make sure you are doing it right. Work on tempo runs, repeats and hills. It's important to stay relaxed when running and use all of your tense energy for moving forward. In order to run faster, you will have to push yourself, so take periodical breaks to regain breath and strength.
Watch this instructional fitness video to learn how to sprint. Sprinting is a simple and efficient exercise, but more complex and ballistic than jogging. It's important to keep an active arm swing when keep you knees high to use all of your tense energy for sprinting forward.
Watch this instructional fitness video to learn how to jog. Jogging is a simple and efficient exercise, but you should make sure you are doing it right. It's important to stay relaxed when running and use all of your tense energy for moving forward. With this how to video you can incorporate jogging into your workout.
Are you as efficient going uphill as you are going downhill? Learn what to look out for the next time you're riding uphill with this instructional cycling video. There really isn't a right or wrong as far as being seated or standing when approaching a hill. Follow a few simple checks and techniques with this cycling tutorial video.
Watch this instructional crocheting video to crochet a classic solid granny square with your left hand. Now, if you're not left handed , this simple crochet lesson may prove to be quite difficult. If you are left handed, these instructions provide an efficient way to crochet creative granny squares for blankets, pot holders, hats, scarves, and other crochet projects.
The garage is the largest uninsulated part of the home. Make your garage energy efficient and help cut heating and cooling bills with a little insulation. Watch this how to video and learn how easy it is to use reflective foil or foam core to keep the effects of the weather out of your home. Insulating also helps reduce noise reduction.
Outdated thermostats promote temperature swings and higher utility bills. Why not choose a programmable energy efficient thermostat for you home. Watch this Home & Garden how to video to learn how to choose and install a programmable thermostat for your home.
Want to put some electronics into your terrain piece or diorama? LED lights are great. You can use tiny watch batteries, which are small and efficient. LED lights are cheap, they come in colours, and you can find them in all kinds of broken gadgets. Watch this instructional video to illuminate your miniature dioramas, doll houses, and miniature war game terrain.
Need an easy, efficient and inexpensive way to layout your garden beds? This how to video shows you how to use regular old kitchen flour and paint string to mark layout lines. Drawing layout lines with flour comes in handy when you run out of chalk and don't have time to run to the store.
The strings on your tennis racket can become less taut and efficient over long term use. It may be time to get some new strings. Take a look at this instructional video and learn how to start the mains on the tennis racket.
Be prepared in case of a disaster by properly storing items in mylar bags. This how to video demonstrates how to seal mylar bags with a clothing iron. This is a quick and efficient way of storing items for long term storage. Place your sealed bag in a bucket and store it away for later.
Egg yolk mixed with your egg white? Bits of shell in your egg yolk? Here's an efficient and nearly foolproof way to separate whole eggs. With an added bonus...you get to play with your food! Watch this how to video to learn a great way to separate eggs.
Correct posture plays a vital roll in golf, putting you in position for balanced, powerful, and consistent golf ball striking. See some tips for correcting and perfecting your posture for an efficient swing.
Proper breast feeding position is necessary for the baby to be able to latch on properly during nursing. Nursing mothers are recommended to watch this video to learn three efficient breastfeeding positions.
Tekzilla shows you a more efficient way to switch between all those open Finder windows cluttering your workspace.
English bread - no sugar here and perfect for vegans! This simple, hand-made bread is perfect for beans on toast, or with some nice yeast extract and a good cup of tea. It's so English, you'll be whistling Monty Python and driving small, fuel efficient cars before you finish the loaf.
Learn about stride rapidity (turnovers), quick movement of the arms which cause legs to cycle. Doing this properly will make you more efficient when running cross country.
Need a more effective and efficient mouse trap to cure your home of a rodent infestation? Here's a trick. Really all you need is some duct tape!
Ryan and Thomas aged 13 and 9 demonstrate how easy it is to install an E85 ethanol FlexFuel conversion kit in to a vehicle. This converter kit is a Full Flex Gold and will allow the car to run on E85, Gas, or any mixture of the two. Full Flex Gold is the only EPA compliant kit available and makes your car more fuel efficient and environment friendly.
Now that your video is edited, learn how to export it in the most efficient and appropriate way for your medium- whether web or email, share the highest quality product with your audience.
PA Waggle out of Singleback Tight Flex is a strong offensive play with a couple of Hot Routes. Try it out in Madden NFL 12 and take a look at this tutorial to find out where to position your players.
If you're still playing Call of Duty 4: Modern Warfare, then this video from NextGenTactics will hopefully help your gaming on the Ambush map. This covers Ambush gameplay on the PlayStation 3, and will show you some easy routes that you can use to move about the map, minimize enemy confrontation, and increase your chances of surprising the enemy.
There are so many computers available today, from laptops to desktops to netbooks and everywhere in between. If you are considering going the stationary route, check out this tutorial. In this video, learn how to choose a desktop PC that is right for you. The experts at PCWorld will walk you through brands, capabilities and price ranges so that you can walk into your local office store with confidence and pick out your model.
Board game enthusiast Scott Nicholson reviews a new game each week showing you the pieces and rules of play, as well and demonstrating the game with friends. This weeks game, Ticket to Ride, is about collecting cards and claiming routes.
Trapster is a cool website that works just like Google Maps or MapQuest, with a twist! In addition to turn by turn driving directions, you will also get the locations of police speed traps along your route. Stay safe and in control- and avoid a costly ticket - with this free web based service.
It's a little freaky that ahanhbarbie34, who narrates this hair tutorial, actually looks like Audrina Patridge, but that makes the resulting look even more like a spot-on match.
Customize your directions on Google Maps. Drag and drop the default directions to your preferred roads or highways, get walking or public transit directions, route around traffic, or add multiple stops on your way.
Customize your directions on Google Maps. Drag and drop the default directions to your preferred roads or highways, get walking or public transit directions, route around traffic, or add multiple stops on your way. Print directions with Street View, photos included.