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 634th installment in their series of digital spreadsheet magic tricks, you'll learn how to build logical formulas for counting with criteria or conditional formatting so that the comparison is between text and text or numbers and numbers. Text-to-number comparisons (e.g., 2003 to "2003") do not yield matches. Learn h...
Stuffed bell peppers can be prepared in an infinite number of delicious ways. Whole peppers, half peppers, red or green peppers, meat or vegetables or both? The debate will rage as long as chefs like to talk, and that's not going to change any time soon. This particular recipe calls for beef sausage and rice as the principal elements of the stuffing, and halved green peppers for the shell. As always, the dish is easy to prepare, takes quite some time to cook, but yields a delicious, hearty re...
This video explains how to force flower bulbs to bloom. The instructor first takes a pot and fills the bottom of it with gravel, which then the bulbs are placed right on top of the set gravel. The rest of the bowl is filled with polished show rocks mid way up the bulb to set them properly inside the pot so they are unable to move freely. The instructor then explains that using the gravel and rock filling forces the bulbs to bloom faster then with standard potting soil. The instructor explains...
Food Network star and host of Good Eats, Alton Brown, shows how the perfect corn-dog does not need fancy ingredients to be delicious. All you need to make the perfect corn-dog are regular all-beef hot dogs, chopsticks from Chinese takeout (left together), batter, and a fryer. Brown shows us his recipe for a spicy batter with jalapenos and provides guidance on the assembly line process that involves rolling the wieners in corn starch, dipping them in batter, and then frying them for four to fi...
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
For anyone interested in learning a new jewelry technique, this video tutorial shows how to crochet a bead rope necklace. You can use large pony beads like the video tutorial, or use much smaller beads. The pony beads are suggested for beginners so that you can see what you are doing. To begin, thread all of the beads you will use onto your yarn. You can alternate colors or place them onto the string at random. Both techniques will yield two different effects. Begin with six chains slip stitc...
Open Xara 3D. Hit show or hide cursor. Type the name JRR Tolkien. Open Animation Options. Set to swing 2. 4 frames per cycle. 1 frame per second. No pause. Angle 0. Select the second "R" and change the animation. Flip the "R" around so it is a mirror image. Go from frame one to frame two. Select the "J". Move the line spacing down to the middle. This yields the JRR Tolkien logo in Xara 3d. You can also flip around the logo using the view menu.
Giada De Laurentiis shows you how to make delicious baked mini frittatas. This recipe yields 40 mini frittatas. Beat eight eggs, and add a half cup milk. Add some diced ham, or any other meat of your choice to the egg and milk mixture. Chop up some fresh parsley and add to the mix. You may substitute here with any fresh herb of your choice. Grate some fresh parmesan cheese over the mixture, and add a touch of salt and some freshly ground black pepper. Whisk gently. Spray your mini muffin cups...
Every gallop of vanilla ice cream could use a little drizzle of butterscotch sauce. In this video, learn how to make a delicious version of this garnish with help from Majories Candies. Follow the recipe below for a sweet & tasty treat.
You've never had mayonnaise like this before. Watch this video to learn how to make homemade mayonnaise from scratch. The secret ingredient is a few drops of hot sauce, to add a nice, fresh spicy kick to your sandwiches or potato salad.
Scott from Spring Hill Nursery with Step by Step Gardening talks about planting fall bulbs. Planting bulbs is very easy. You just need a shovel, good soil, and lots of water. The bulbs he plants are tulips bulbs, lily bulbs, glad corms, and iris rhizomes. All of these must be planted in the fall to bloom in the spring. It's easiest to dig one big hole - about 6-8" deep - and plant all of your bulbs at once. A random pattern yields a natural look. Once you've placed your bulbs, put about 2"-3"...
Master Gardener Valois Pearce advises how to identify problems with pecans. 1. Look for webworms. One control is to cut the branch off if you can. You can break the web with a strong blast of water. 2. Shiny leaves indicate there may be a problem with Aphids. 3. Check for Pecan-nut Casebearer. Should you decide to use insecticide for any of these problems, please check with your local county extension office to confirm spray dates. Even with these precautions trees normally do not give a hund...
Make the perfect side vegetable dish this evening with this divine recipe for glazed carrots. Serve your man course with a complimentary dish that will have your guest's mouths watering. This recipe yields 6 servings.
In this math tutorial, you will learn how to simplify square roots with product and quotient rules. To begin, you will need to multiply the square roots so that the two square roots in your equation are reduced down into one. The rule for non-negative "A" and "B" is that the square root of "A" multiplied by the square root of "B" yields the square root of A x B.
Golf Link demonstrates how to correct a golf slice. Golf slices are most caused by a player's grip. If the grip is yielding a slice, the players hands are turned too far to the left so when you come back to impact, your hands will naturally open and create a slice. Get the correct grip by turning your hand around so your thumb is towards the back of the shaft with your left hand on top of the grip and your right hand facing the direction that you would like to go. Use golf tees to determine i...
Milking a cow can yield multiple gallons of milk per session. This video tutorial demonstrates how to milk a grass fed cow by hand, and provides ways to make your cow more cooperative throughout the process. All you'll need is a cow, a stool, and a patient work ethic.
Reuse an expired credit or empty gift card to make a guitar pick instead of buying a brand new pick. You will need a pick, nail file (or sandpaper), card, and sharp scissors. Each card will probably yield about four or five picks. With a pen or Sharpie, outline your pick onto the card, centering it around whatever design or logo you want on the pick. Then, cut out this shape with your scissors. With the file, go back and file down the edges so that they are smooth, making sure that all sides ...
Need a new recipe for a crispy batter for fried fish? The Original Naked Chef uses a simple seasoned flour and water base with an extra twist. He adds a healthy dose of Guinness beer to the mix. This affords a rich and fragrant batter. Chef believes that the perfect surface for cooking fish is in a shallow skillet with very hot oil. Simply dipping the fillets in the batter and allowing them to fry several minutes per side yields a mouth-watering main course. Serve with chips and Guinness beer...
This video shows you everything you need to know and need to make this delicious Korean classic. You'll learn how to make yummy napa cabbage kimchi right in your own home from scratch. For the whole family to enjoy this spicy tasty dish.
In this video HeightSecrets shows how you can actually grow taller. He explains how he has done research on how to make yourself taller. He starts off by explaining how changing your posture can add one to two inches instantly by just changing your posture. He then goes on to show exercises that can stretch you out a good bit. Not only does he talk about posture and exercise but he then goes on to tell you about how drinking plenty of water and resting can yield better results.
Watch this video to learn how to make a penny operated nitric acid fountain. Nitric acid acts upon copper to yield nitric oxide in an exothermic reaction. The expanding gas displaces water from another flask; actually bubbles in this set up. When the gas cools, the water is drawn back into the flask, dissolving the nitric oxide and forming a blue solution with the copper ions still there. Very cool science experiment with a neat reaction.
On October 17, 1943, a story in the New York Herald Tribune read "Many laymen — husbands, wives, parents, brothers, sisters, friends — beg Dr. Keefer for penicillin," according to the American Chemical Society. Dr. Chester Keefer of Boston was responsible for rationing the new miracle drug, penicillin.
How to hack and mod a Microsoft Zune Mp3 player and upgrade the hard drive to anywhere up to 100GB Part 1 of 2 - How to Hack a Microsoft Zune for a larger hard drive.
Puppy chow is not for your puppies! It is a sweet, chocolate and crunchy treat made from Chexmix coated in a mixture of peanut butter, chocolate chips and butter. This is a very decadent treat that can be stored in a plastic bag.
Many wonder how driverless cars will ever be able to navigate through any driving condition imaginable — but the point is self-taught machines, in theory, have the innate ability to adapt to chaotic and extreme driving conditions in ways far superior to what humans are capable of.
This is a magic trick in which you turn one small coin into two larger coins. First you need to place the two larger coins horizontally between your index finger and your thumb. Then you need to place the smaller coin vertically against your index finger and thumb as to conceal the two larger coins. Then when you make a motion with your hand you can slide the smaller coin down and have two larger coins.
Watch this science video tutorial from Nurd Rage on how to make nitric acid. They show three ways to make nitric acid based on two different chemical approaches, both of which can be done using easily accessible materials.
Plastic bags on their own aren't quite strong enough to hold anything too heavy (at least not for an extended period of time), but when broken down into "plarn" - plastic yarn - they can be woven into some very sturdy fabric.
In this segment of Southwest Yard and Garden, John White and Bill Alford are going to be talking about fruit production and how to harvest figs in southern New Mexico. Bill starts off by talking about his nine year old Black Turkey tree. He says he digs holes and arbor each spring, then uses half a cup of fertilizer per hole. The roots of a fig tree usually grow out past the outer parts of the tree so it's important to make sure you plant has adequate room to grow correctly. A person can mayb...
If all things go well, you'll only have to take your road test once. That's the goal: to ace your test on the first try and then start driving on your own. Granted, it's a nerve-racking experience, but keep in mind that the California Department of Motor Vehicles wants you to pass. So much so, they give you the examination answers ahead of time! All you have to do is study.
Pie crust can be tricky... If it's overcooked in the slightest, it will come out tough and break easily. In this video, learn how to make the perfect flaky homemade pie crust that will be the perfect compliment to any pie filling.
In this tutorial from the TyingItAllTogether Channel, you can learn how to make double and quadruple looped pendent knots. These knots are commonly found in Celtic designs. Once you learn how to create these knots, you can use them in arts and crafts projects for necklaces or bracelets. To begin, the double looped knot is done by taking a piece of rope and folding it in half, allowing the two sides to be next to each other. With one side of the rope, loop it around the other side of the rope,...
Tired of losing your gardening efforts to snails and slugs? Use these methods to banish the pests. You Will Need
If you have pictures, videos, or a presentation you want to share with a larger audience, or enjoy on a larger screen than the one that your Nokia Booklet 3G comes equipped with, grab an HDMI cable.
This free video science lesson from YouTube's bionerd23 demonstrates a simple technique for modding a Bresser Biolux NG or Bresser Biolux AL microscope to view larger objects like minerals. You'll also learn how to mod your microscope to allow you to take pictures and shoot video through it. For all of the relevant details and detailed, step-by-step instructions, watch this home-science how-to.
This video demonstrates the quotient rule as applied to exponential expressions that appear in the form of, to use the word loosely, a fraction. The name, "quotient rule", refers to the fact that it applies to expressions which are divided by other expressions. The video begins by explaining that the quotient rule allows expressions in this form to be simplified if they contain like bases (i.e., the terms are of the same variable). The quotient rule allows the expression to be simplified by s...
Angie shows you how to make delicious vanilla cupcakes and frosting like a pro - from scratch Preheat oven to 350 degrees. Combine dry ingredients: 1 tsp. baking soda, 1 3/4 cups flour, and 1/2 tsp. salt, and set aside. Using a mixer, cream 1/2 cup unsalted butter and 1 cup sugar, until sugar granules dissolve. Add 2 eggs, one at a time, and 1 tsp. pure vanilla extract. Add 1/3 of the dry mixture, followed by 3/4 cup milk. Mix well to smooth out any air pockets. Add remaining flour mixture, t...
Looking to buy a home? Why leave your current digs? Using technology has made it easier than ever before to find the home of your dreams. Learn how to buy a home online with help from this how-to video.
This is a very simple fudge recipe using evaporated milk, marshmallows, and chocolate chips that brings raves. It is a classic candy recipe that is often requested. Instructions are also given for butterscotch and mint flavors.
