Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
This video demonstrates a way to cook a sirloin steak with a gravy sauce as a main course. In a large frying pan put some oil to sear the steak. You will know that the oil is hot and ready for the meat when it begins to smoke. Season with salt, pepper, and sear the steak until each side is brown. Next place the meat in an oven and cook at 350 degrees for six minutes. While the meat is cooking is a good time to make the gravy. In the pan that you used to sear the steak add some red wine, veal ...
Curtis Smith provides information on how to use chickens to control garden pests. Using chickens keeps the use of pesticides to a minimum and keeps plants healthier. In the organic garden, chickens are used because they'll eat any insect as well. The process is known as Integrated Pest Management, Curtis explains that its basically knowing your pest. It also reduces the amount of feed that has to be purchased for the chickens because they're eating the insects in the garden. It also controls ...
In this Disaster Preparation video tutorial you will learn how to tie a double bowline knot step by step. Robert Segundo, knot tying expert, presents this video. This knot is stronger than the regular bowline knot. When you put a knot on a rope, its strength reduces. This knot will retain about 70-75 % of the original strength of the rope. For this knot you will need a piece of rope or twine. Start off by putting a loop on the rope and then put a double loop. Then take the working end of the ...
Whether you're new to Adobe Photoshop or a seasoned digital photographer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...
Learn how to simulate snow in your photograph in this video tutorial by photoshopuniverse. For this you'll need a photo depicting winter scenery. Add a new layer, fill it in with black, go to filer noise and add noise as shown using the given amounts. Go to filter effects and add blur to the layer. Go to images and adjust the levels to reduce the snow-flakes as shown. And add some motion blur to it. Change the blend mode to screen, duplicate the layer, rotate the new layer, apply the filter c...
Photoshopuniverse shows how to remove JPEG Artifacts in photoshop. It's simple. Sometimes it happens that, you get the best picture which is related with your work, but unfortunately its low quality or small. If you zoom in a small picture it will pixilated. You will see some blocks. Luckily there is a way to remove it from photoshop. Go to- filter, then noise, then reduce noise. There will be an options of removing JPEG artifact. Check that. After watching the video you can remove JPEG artif...
Ingredients: 4 cups uncooked white rice
This how-to video is about how to remove a hickey with a battery. This is useful if you want to hide it from your boss, your mom, or even your girlfriend (shame on you, really).
What could possibly make shooting home videos even easier than they already are? A camcorder handle. This is a cheap, easy, legit way on making a camcorder handle.
Doug Simms gives a demonstration of multiplying fraction in a simple and easy manner. The simplest problems have proper fractions to be multiplied by proper fractions, and the answer can be arrived at by simply multiplying the numerator (upper value) of one fraction with the numerator of the other, carrying out the same operation with the denominators (lower values) of the two fractions, and finally, reducing the resultant fraction by a common factor, if any. Doug also gives three other examp...
Fresh sautéed spinach will help wash the taste of 14 consecutive nights of pizza out of your mouth. You will need:
Want to learn how to make thermite? Just watch this science experiment video to see how to make thermite from iron-oxide and aluminum.
According to a study released 6/24/08 by PLoS Medicine, watching a video in an STD clinic waiting room can reduce the risk for a new STD by almost 10%. In a large multi-center intervention trial, Dr. Lee Warner from the Centers for Disease control and Prevention and a team of researchers at different institutions in the U.S. studied the effect of a carefully crafted, 23-minute waiting room video on the risk for new STDs among 40,000 patients in 3 STD clinics in the country. This is brought to...
Watch this instructional hobby video to properly set up and fly a remote control helicopter. Transmitter switches and servo wires should all be set up this way. Charge the flight pack and you are ready. If you are a beginner, leaving the flybar weights at the outer position will dampen the controls and make the helicopter easier to fly. As you improve, move the weights in for quicker response. The swashplate has a metal ball for reduced wear and precise control. The servos are screwed to the ...
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
Watch this automotive video tutorial to see how to scan your automobile for diagnostic trouble codes.
If you have a taste for sweets, you have at least one thing in common with mosquitoes. While too much sugar is unhealthy for humans, a new product makes sweets deadly to mosquitoes.
I've never had a black eye, but I was in a car accident that turned my entire ear dark purple a few years ago. Believe me; it was enough to get more than a few funny looks.
Minimalists are the opposite of pack rats. Whereas pack rats thrive on the philosophy of "more is more," minimalists belive emphatically that "less is more." And if you're a decorating minimalist, that means using the fewest decorative objects possible to achieve a satisfying and cohesive room.
In this video we learn how to do a heelside pendulum in snowboarding. Start by sideslipping on your heal edge. Then, tap on one leg to increase pressure on that foot. Reduce the angle and then you can slide your board down where you are facing. Look and point in the direction of desired travel. Tapping on both legs means even pressure distribution on both feet. Increase edge angle with even pressure on both feet to slow down and stop. Although you will start out slow at first, these are great...
The aerator on your faucet serves a very important function: by adding air bubbles, it helps to fuse the water and give it a softer feel. It also helps reduce the amount of water you use. So if you're faucet's water stream is acting funny (like a drop in pressure), it might be time to either clean or replace your aerator. If you're having trouble with your shower head, too, a little vinegar might do the trick.
In this video, we learn the truth and myths about ab workouts. The first myth is that you can get six pack abs just by doing ab exercises. This is not true. You need to eat less and work out more to lose fat on your body that will show the abs underneath your fat. It doesn't matter if you do a super ab workout, unless you get rid of body fat, you won't be able to see your abs. You also need to learn that you cannot do spot fat removal, fat will fall off your body when you start to lose weight...
If you're the new owner of a snowboard or plan on purchasing one, an important part of maintaining it is by waxing. Waxing a snowboard is one of the easiest things that anybody can do in order to increase the overall performance of your board. Waxing a board can also prolong the life of the board and reduce any minor damages it accrues.
In order to prepare Bay Scallops with White Wine Lemon Caper Sauce, you will need the following: scallops, lemon and pepper corns, olive oil, pre-prepared pasta, capers, parsley, butter, and lemon juice.
In this tutorial, we learn how to use a zigzag stitch as an overlocking stitch. First, put your fabric under the sewing machine and place the edge close to the needle. Sew the side of the fabric and when you are done, you will have the overlocking stitch. This will stop your edge from being raw and there won't be any frays on the side, which will reduce unraveling. This is very easy to do and just takes a few minutes. Make sure you prepare your fabric before you do this stitch and you will be...
In this tutorial, we learn how to use card view on the Palm Pre. To use this feature, you want to flick up or press the center button on the phone. After you do this you can move between cards by sweeping left to right. Maximize an application by flicking down and return to card view by pressing on the center button again. To reduce the size of cards, tap while holding the screen. To reorder the cards, drag them to different destinations along the card line up. doing this will help you work y...
This tutorial looks at streamlining your C4D workflow, organizing your assets and working with groups. Xrefs can be incredibly useful and as well as helping you to stay organized can also hugely reduce hard drive space used. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this tr...
Yanik Chauvin teaches us how to add texture to a reflection in Photoshop in this tutorial. To start, add a basic reflection to the item you want a reflection on. Now, reduce the opacity of the layer and bring it down to 25%. Next, add a new layer and paint in a gradient white to transparent. Make sure your first gradient selection is selected. Now, click and drag and you will see the reflection diffused. Next select the blur option, then click on motion blur and put the distance at 20 pixels....
In this clip, you'll learn how to reduce pack pain through use of a Pilates Reformer exercise device. With Pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body Pilates. For complete instructions, give this free...
Could you use a little help figuring out how to work with polynomials in algebra? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this free math tutorial, you'll learn how to subtract, multiply and reduce polynomials in a...
Acid reflux can be painful and irritating, and did you know that toddlers can be affected by it too?
In order to make flower magnets and faux brads, you will need the following: card stock, a hole punch, a sponge applicator, and crystal effects.
A pregnant woman's feet tend to be one thing you can always count on to ache. In this video, learn how to give a great foot massage to a woman who's pregnant with help from licensed massage therapist, Willow Hajicek. When giving a foot massage during pregnancy, one should use some reflexology, as well as lymphatic, techniques to loosen up the muscles and reduce the swelling that occurs during a soon to be mother's second and third trimesters. Learn in this video how to administer a great food...
The Caldesis shows us how to cook Duck with Cherry Sauce, in this video.To get strated,reduce some Gabbiano red wine and sugar in a pan.On a baking tray put in some tinned cherries and pour its juice on the top.To this,add some orange juice and sprinkle some sugar on top.Put this in the oven,for 10-15 minutes,at 180 degrees F and cook until the cherries are browned and the sugar is caramelized. Take four duck breasts and trim off the excess fat on the sides.Sprinkle some salt and pepper on it...
What can you do with a cucumber, yogurt, oats and honey? You can make a facial mask which keeps your skin moistened and protected during the summer months.
How to Make Anything demonstrates how to use a three prong XLR mic with your camcorder. The XLR plug on the mic is not going to fit into the 1/8 inch plug on your camcorder so you will need an adapter. You can find an XLR to 1/8 inch adapter for about 10 dollars. Try to get an adapter with as short of a cord as possible to reduce noise and radio interference. You can also get an XLR box which is an interface which goes between your camera and the microphone. The XLR box will be about 180 doll...
How do you salvage a clogged caulk tube? In this Quick Tips with Chuck Miller video, you will see there is an ingenious and simple way to salvage a clogged caulk tube. Take a utility knife and simply make a slice on the side of the caulk tube nozzle. Probably the entire length of the nozzle is clogged and you may not be able to clear it with a wire or nail. After slicing it, take a sharp tool and remove the clogged material from the nozzle and clean it up. Then wrap the nozzle with electrical...
Woodland areas provide a personal forest where you can ramble about and relax. This video tutorial teaches you how to chop down a tree in your woodland area and what to do with trunk afterwards. First, you'll need to have the tools and proper safety equipment. Next, thin the trees to allow more light and encourage growth. Then use your chainsaw to cut a gap on the side of the tree that you want the trunk to fall. Finally, sned the tree by cutting off branches and reducing it to manageable 2 m...
Lose your double chin with a simple neck exercise. Cynthia Rowland, anti-aging expert, demonstrates some exercises for strengthening the neck muscles, thereby reducing the double chin.
