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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
Pecan prailines are the foodstuff our ice cream parlor dreams are made of. With copious amounts of sugar, deliciously sweet prailines, and a nice toffee crunch that accompanies every bite, pecan prailines are the perfect treat to serve alongside plain vanilla ice cream and a soda pop (yes, we're piggies like that).
In this tutorial, we learn how to wash your hands the correct way. First, let the water run for a few seconds until it gets hot or warm. After it's done warming up, run your hands through the water, make sure to get your wrists wet as well. Next, apply a quarter sized amount to your hands and scrub through your fingers as well as underneath your fingernails and around your wrists. When you are finished scrubbing, rinse your hands with the warm water and then pat dry with a towel. If you are i...
In this tutorial, we learn how to manage a fever in children. When your child has a fever, this means their body is fighting an infection. The fever will vary depending on what it is, but it will usually peak at 106 degrees. Don't bring the fever down with Tylenol, because it could make the cold last for a longer amount of time. This can be a greater threat to health than the illness was in the first place. If the child starts to get a higher fever, this is a good sign that the body is killin...
Even though Christmas and the winter holidays have now passed, January is just as chilly and requires equal amounts of hot chocolate and steaming hot baked goods from the oven to warm your kids up after getting a good chill outside.
In order to make a striped dress out of t-shirts, you will need the following: t-shirt dress, measuring tape or a ruler, pins, scissors, thread, needles, and sequins.
Wearing layers and layers of makeup during the day is just asking for disaster, especially now that the humidity is soaring and temperatures are climbing up higher and higher.
If you're anything like us, then you find it pretty ridiculous that whenever you purchase a gift card, you have to shell out nearly twice the amount of the gift card in order to put it into a neat, pretty gift card holder.
Just like all living organisms, lawns need the proper amount of food and water in order to survive. Not giving them enough can lead to a dead looking yard that is unpleasant to look at.
If you haven't made the switch to compact fluorescent bulbs, what are you waiting for? These bulbs produce the same amount of light as the old bulbs, but produce less heat and zap less energy away from your home. That can lead to you saving money and doing more for the environment.
In this clip, learn all about pet fish from pet expert, Marc Morrone. Marc will walk you through the rows and rows of fish food at your pet store so you know exactly what type is best for your pet fish. Make sure your little buddies live long, healthy and happy lives with the right amount and variety of fish food. Not sure if your fish needs pellets or flakes? Marc is here to help!
Spooky Halloween parties necessitate a certain amount of creeptastic spider webs, but the cheap cottony stuff that comes in plastic bags at most retailers feel fake and have been overused over the last few years.
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 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.
This video describes how to make Thai Pasta Noodles. The commentator first lays out all of the ingredients on the table and tells the amounts required for the recipe. The cooking begins with the preparation of the sauce by combining chicken broth, soy sauce, and peanut butter in a measuring cup. Then, garlic and ginger are added in a pan with vegetable oil along with the red pepper, red chile flakes, and finally, the chicken breasts. Once the chicken is almost done, the cilantro and green bel...
This video is about how to create colorful leopard print nails. So the first thing that you will have to do is to choose any colors of the nail polish that you want. After deciding for the first color of the nail polish, apply it to your nails and let it dry. The next step is to get a plastic plate and place a bit of a small amount of the second color that you chose. With the use of the nail art brush, carefully start forming small random spots on the nail. Apply these to the rest of your nai...
This video illustrates how to apply foundation quickly and easily everyday. This process is done by using the following steps.
This is a tutorial on how to style your hair using styling gel and hair spray in the style known as "scene/emo". This is basic information on how to spike your hair, how much gel to use, and techniques on how to apply the gel to your hair. As explained in the video, gel from the roots of your hair to the tips, only applying a small amount when needed. Then, as also described, coat hair in hairspray to ensure it will hold for a while. Repeat this process until the style you are looking for is ...
This video makes suggestions in how to choose colorful flowers and shrubs in your garden. Bowle’s Mauve is a purple flowering plant that will grow and bloom until fall. It will become bushy. Another colorful choice is the Rock Rose, a pinkish flower. The Blue Salvia has blue flowers. A Bank’s Rose, only bloom for a short time. It has yellow or white flowers. Aphids tend to attack it, but it is hearty.
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 ...
For frizzy and wavy hair, you can create a hairstyle using wide flat irons using the right techniques. Firstly, apply a good amount of moisturizer on your hair. One new equipment out on the market that you can use is Cloud Nine. To use it, you have to make different sections of your hair and then start with the one nearest to your face. With the flat iron in place on your dominant hand, grab a section of your hair and loop it around the flat iron. Hold it in place for a few seconds and let it...
This video explains how tree growth rings function and what they can tell us.The growth rings are formed in 2 (sometimes 3) layers of wood that are the spring growth and the summer growth. Ring width can vary depending on the specie of the tree, the environment in which it has grown and the amount of water it has used. By counting the rings you can tell the age of the tree.By analyzing the growth rings, you can see the years in which there was a drought where the tree once stood, because the ...
In this video tutorial, viewers learn how to play a recorder. The mouthpiece of the recorder goes onto your bottom lip and in front of your bottom teeth. Do not bite on it. You rest your mouth on it. Only the tip of the mouthpiece goes in your mouth. When you blow on the recorder, blow with a steady air stream with a small amount of air. Squeaking is caused when you blow too hard and if you finger are not covering the holes completely. This video will benefit those viewers who are interested ...
New to 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 Excel tutorial from ExcelIsFun, the 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
This video shows the viewer how make frizzy hair straight. This is done using a straightening iron, a comb and a small amount of hair ‘silicone sealant’. The first stage is to comb the hair and ensure that it is not tangled or matted. Secondly take a section of hair around one inch wide and pass the straightening irons from the root to the ends taking no more than a few seconds -if the iron is held on the hair for too long it will burn. This process should be repeated for all of the remaining...
This video demonstrates how to do a wet foot test and how to choose running shoes with the results of a wet foot test. The wet foot test is simple. Get your foot wet and place it on a piece of heavy duty paper which will create a foot print. The foot print shows what type of arch you have. There are three types of arches: high, medium and low. High arches require a lot of cushion for running. Medium arches require a reasonable amount of cushion for running. Individuals with low arches or flat...
In this video tutorial, viewers learn how to make "hot ice". Users will need sodium acetate. Begin by putting the sodium acetate into a pan. Add a small amount water to the sodium acetate. Heat the mixture on a stove until the sodium acetate has dissolved. Pour the solution into a container. Do not pour in any undissolved crystals. Put the container into the freezer or refrigerator for a while. When the solution cools down to room temperature, take it out. Touch the sodium acetate and it will...
This video helps us understand the organic molecules and elimination reaction. Take some sugar in a beaker. Sugar has 12 carbon atoms, 22 hydrogen atoms and 11 atoms of oxygen. The sulphuric acid is poured into the sugar and the color change is observed. The color of the sugar gradually changes into black. The sulphuric acid causes an exothermic reaction which releases a large amount of sulphur dioxide gas. All the water (containing hydrogen and oxygen atoms) is eliminated out of the sugar du...
artjewelrymag teaches you how to use a liver of sulfur solution to create a patina. First, be sure to wear protective gloves and eye gear. Be sure to perform this operation in a well-ventilated area because sulfur smells like rotten eggs. To get started, add a few small pieces of liver of sulfur to a small dish of warm water. Use a wooden stick or a small PVC pipe and stir. The temperature and the amount of time you leave the metal in the solution will affect the patina. You can dip the metal...
Having trouble with The Heist 2? Well in this quick and easy tutorial by Trevor4Ever595 you can kiss your troubles goodbye. In this video Trevor4Ever595 shows you how to hack the credit amount so credit is no longer in your way to buying all the upgrades you need to fly through the game. He shows you how to do this using Cheat Engine 5.5 you can edit your credit to your satisfaction. Trevor4Ever595 would be happy to help you with any questions you may have regarding the tutorial. Simply leave...
Are you looking for a way to take your salad to the next level? Try making your very own vinaigrette salad dressing to impress your family and friends. This great recipe will give you the inspiration to be creative in the kitchen.
Properly measure liquid and dry ingredients Diane Morgan describes the basic technique for measuring ingredients, which is critical to baking. There are two types of measuring cups, one for liquids and a different type for dry ingredients that need to be leveled off, such as flour or sugar.
In this video tutorial, viewers learn how to hack the flash game, Palisade Guardian 2: Modern Combat with Cheat Engine. Begin the game by entering your name and play the first level. After that, open up Cheat Engine and select your internet in the process list. Change the Value Type to Double and Truncated to Rounded (default). Enter in the value of your cash and press First Scan. Then buy something to lower your cash and enter in your new value. There should be only 1 address. Check the froz...
Diane Morgan shows us the right way to cook a nice fluffy omelet. Break the eggs into a bowl and beat them with a fork until they are fluffy, adding a small amount of milk and some salt and pepper. Add a little butter to a non-stick omelet pan; let it melt on low heat and drop in the eggs. When the skin starts to form, begin tilting the pan as you scoop the cooked parts of the egg into the center with a spatula. When all of the egg is cooked you can start adding the fillings over the top. To ...
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...
Lindsay Johnson, from lush life shows us how to make a gin based Bee's Knees cocktail in just 12 seconds. Firstly take 2 ounces of gin and then stir it with 3 bar spoons of running honey. Following that add 3 quarters of an ounce of fresh squeezed lemon juice. Shake and stream and it are ready to serve. She also shows us to make running honey which is really very simple. Boil some water and then add equal amount of honey to it. Then stir it together and put it into your cocktail. This adds so...
Nili Nathan demonstrates how to create your own homemade rosemary facial spray. 1. Start by adding 3 oz of distilled water to a spray bottle. Add 1 tablespoon of olive oil. 2. Take rosemary essential oil and add 6 drops to the bottle. 3. Gather up some fresh rosemary (possibly from your garden or a friends garden or a nearby store) and add that to the bottle. Close the bottle tightly and shake it up. 4. Now you are ready to spray desired amount to body and face!
The truss rod is a big metal bar that goes through the whole neck on your guitar and is used to control the amount of arch that the neck of your instrument gets. You will want the neck to be essentially straight, with a tiny bit of curve. Lots of things can cause your wood to arc..weather, storage, age.. and the truss rod is used to fix this and keep the neck straight allowing you to play your piece properly. All guitars come with a truss rod and they are easy to adjust if need be. This tutor...
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...
This video tutorial, by photoshopuniverse, shows you how to reduce the depth of field after a photo is taken using Photoshop. This enables you to ensure that your main subject is clearly in focus while the background is out of focus or blurry. First duplicate the layer using the short cut that was mentioned and apply the filter lens blur to the new layer and adjust the radius so that an adequate amount of blurring is achieved. Add a layer mask and bring the subject to focus by selecting the b...
