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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
This video shows you how to make, a home made fruit smoothie hair mask is proven to prevent hair loss and cure itchy scalp and dandruff. Helps to regrow hair and also to strengthen and fortify your hair.
In this tutorial from brickboy518, viewers are shown how to construct a table out of fourteen LEGO bricks. The following bricks are required: 4 1x1 spokes, two 4x1 strips, a 4x6 thin, a 2x4 thin, two 4x1 thins from the LEGO Racing Legacy sets, and 4 1x1 spokes. First, the builder must apply the 2x4 thin to the center of the of the 4x6 then. Next, they must attach one of the spokes on each corner of the 4x6. Then, the car strips must be applied face-inwards to the sides of the 4x6. Thus, this ...
In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square and you wish to simplify it, the key is to write it as the product of a perfect square or another number. This video is very descriptive and clearly explains the functions of the formula. This video will benefit those v...
This video shows how to toast pumpkin seeds whose flavor is greatly enhanced by the toasting process. They are also very nutritious and add texture to meals. You don't need any oil as pumpkins have their own oil. You will need a hot skillet and a cup full of pumpkins which will pop as they heat. Once they are toasted brown they can be put in a container with tamari soy sauce. This is a film clip from the narrator's own kitchen and you can see how they could be used on salads, stews, pasta dis...
This video teaches you how to make glitter wands using a simple and fast method. For a wand measuring about 18 inches long, you will need a sheet of A4 printer paper, glue, 2 strips of 1 inch wide 2 ply tissue paper, a pair of scissors, black and gold paint, an old sponge and glitter. First roll the sheet of paper and stick it so you have one small end tapering towards a slighter bigger end. Stick tissue rolls on the rolled paper and seal off the ends by twisting gently. When the glue dries a...
Using an antique distressing paint finish technique on furniture is a good way to revive a piece of furniture that other wise might just be discarded. This video is part of a series of videos taking viewers through the process of distressing furniture and focuses on accent technique. You’ll want to accent the select parts of the furniture you want to accentuate that distressed look. Our expert recommends painting the edges of this table. You’ll want to pick a complimentary color and when you ...
If you need to wear a tuxedo vest, measuring is something that does not have to be spot-on. It will be adjustable at the neck and waist area. Most vests are offered on a small, medium, large, and extra large range. The chest and overarm measurement that's taken for your jacket might effect the girth or size of the vest, but this shouldn't be much of a problem since its adjustable. Whether or not its a full-back may also effect the fit. Children's sizes are measured on the same basis and can b...
Those interested in learning how to make their own jewelry, can learn how to make a floating illusion necklace by following the steps in this video tutorial. You will need a beading board, beading wire, crimp beads, beads of your choice, a barrel clasp, wire cutters, and crimping/flat-nosed pliers. First measure out how much wire you will need. The tutorial is making a 16-inch necklace. Make sure to cut extra wire. For a 16-inch necklace, this means you should cut approximately 20 inches of w...
This video demonstrates the easiest and fastest smoke bomb that a person can make. Supplies include aluminum foil, standard ping pong ball, a pen or pencil, and a flame lighter. Wrap the ping pong ball with foil, being extra careful not to tear the aluminum foil. Use the pen to create a funnel shape with the foil. Remove the pen. Now, light the bottom while holding the top. The smoke is toxic, so don't inhale. Make sure the smoke bomb is on a non-flammable surface as it gets very hot. Also, w...
To do a back handspring, raise your hands over your head in a standing position. Then, stretch your arms out in front of your while lowering yourself, with knees bent, to a simulated sitting position. Use propulsion from your legs to jump into the back handspring. If you don't jump into the back handspring you may hit your head on the ground. Reach back as far as you can go, keep your body tight and keep your toes pointed. Keep your arms extended over your head and reach back to flip your bod...
In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...
In this tutorial from Mark the Shark, viewers are shown how to apply a hook to a fishing pole. One such method is using a Fishermen's knot, and wrapping the hook around the line eight times, and then wetting it with saliva, before it is tightened. Then, the user must make sure than the knot comes all the way down to the hook, to make sure it does not rotate. Next, pliers must be used to eliminate excessive line, and then the line must be searched for crinks, or any imperfections. Mark the Sha...
This Spirituality video clip will show you how to wrap a Wiccan cinnamon stick bundle for protection. You need some cinnamon sticks, scissors and ribbon. Cut a very long piece of ribbon, lay it down on a table, place the cinnamon sticks on the ribbon, tie a basic knot flip it over and tie another knot. With one end of the ribbon, go over and in between the sticks and with the other end, go under and in between the sticks. Now put one more knot in between the sticks. One more time go under or ...
In this video tutorial, viewers learn how to use widgets on the Nokia N900. Widgets are small applications that enhance the desktop. You can add, remove or move them by going into the desktop editing mode. On the desktop, click on the editing mode. Click on Add Widget and select the application that you want. Then click on Done to use it. Clicking on the X removes the widgets. You can download extra widgets from the Ovi store. You can move widgets in edit mode and adjust their settings. This ...
In this video tutorial, viewers learn how to graph a linear equation. The linear equations example used in this video is y= 1/3x-3. The equation to graph a linear equation is y= mx+b. Now substitute each number into the equation. Therefore, m= 1/3 and b= -3. Begin by graphing the Y-intercept. M is the slope and b is the y-intercept. Plot the y-intercept on the -3 axis. Then move up once and to the side 3 times. This video will benefit those viewers who are struggling with this math unit and a...
Nine inch storage shelves are spaced and constructed in a practical way. It shows the right screws. This requires a drill some wood. The viewer is shown how to make a good back brace for the shelves. It shows how to make the shelving unit level. You learn the screw head must be flat. You are also shown how to put in a good support for underneath the shelves. It shows the center support being constructed. He shows how to set the shelves up so there is support from all sides and to make the she...
In this video tutorial, viewers learn how to create a faux suede technique on cardstock. Users will need a plastic stamp pad. This stamp pad will be used for rubbing, so it should be an extra or an old stamp pad. Users will need to re-ink the pad once in a while. This will give the cardstock a textured look. It will give an old age, distress look. Simply take the stamp pad and rub it over the cardstock. This will pick up the texture of the cardstock. This video will benefit those viewers who ...
In this video tutorial, viewers learn how to save money on beauty products. In-store cards and frequent buyer programs can save a lot of money. When you scan the CVS Extra Care card at checkout or in-store kiosk, coupons based on your purchase will be printed automatically. It will give good discounts. Web only offers are becoming popular. Private sale sites have also become popular. You simply sign up on the site and take offers that the site has. This video will benefit those viewers who ar...
In this video tutorial, viewers learn how to add hemp twine to accent a scrapbook photo. Users will only need a line of twine and tape. Put the twine on one side of the picture and tape the back to hold it. Now wrap the twine in a diagonal pattern (right and left). Then wrap it down the middle and tape the back again to hold it. Trim off the extra twine and tape all the strings of twine at the back, so that it won't move. This video will benefit those viewers who want to add an embellishment ...
The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...
The Kitchen Nut YouTube user shows all the steps needed for preparing roasted sweet potato fries, with various tips for getting better result.
Ilysa Bierer and Kira Slye with Polymer Clay TV demonstrate how to make polymer clay business card holders. You can work cabochons into polymer clay to create business card holders. Stamp on clay and use clay with inclusions in it for a different look. First, get a plain business card case and work the clay over it. Add pigment inks, textured stamps and canes to dress up your business card holder. The clay can be baked right onto the metal and will adhere to it. Polymer clay adheres better to...
This video is a tutorial on how to make a baby diaper cake. To begin, you will need to roll all your baby diapers from the waist down and secure them with rubber bands. Your top tier will have 8 diapers, the middle tier will have 19 diapers, and the bottom tier will have 40 diapers. Use rubber bands to secure all your tiers together. Next, glue thick ribbon around the tiers over your rubber bands. Follow up with decorations such as bows and extra ribbons. Use a cake stick to secure the tiers ...
This instructional video shows us how to make a Japanese flag fan. The materials required are: Foamy (Red and white), four popsicle sticks, glue and scissors. First cut two circular shapes (with one straight edge) from the white foamy, then glue on the popsicle sticks to the straight edge of one of the circles to make the handle. After this, glue down the other white circular piece of foamy to cover the tops of the popsicle sticks. Then cut out two smaller circles from the red foamy and glue ...
In general, this video is approximately one minute and eight seconds long. The host speaks about personal hygiene by using a small packet of antibacterial wipes. She generalizes the use of this product, which includes hand sanitation, cleanup, and emergency antibacterial use. She specifically speaks about deodorizing the underarms. She relates to the audience about forgetting to use deodorant and how using the antibacterial wipes will help fight bacterial body odor, but clearly states it won'...
The video shows you how to draw a Homer Simpson cartoon. Start off with a big circle and a smaller circle below. Draw two slightly diagonal lines to the sides, a slightly curved line below and two lines for the lower part of the head. Then add another circle on the left side of the smaller circle. Draw a small pickle shaped nose and an eyebrow above the left circle. Draw the ear just below the eye line. The hair is drawn above the ear, like an M shape. Draw the mouth and the lower lip and ext...
Viewers learn that a net is the shape formed by "unfolding" a 3-dimensional figure, so a net shows all the faces that make up the surface area of the figure. Viewers are then asked to determine what type of 3-dimensional figure can be made from a given net (note that a cylinder has 2 circular bases, a pyramid has triangular faces, a cone has 1 circular base, and a prism has rectangular faces). Students are also asked to determine if a given net can be used to make a cube. This video will bene...
In this video from HippyGourmet we learn how to make a chardonnay portability mushroom polenta. Grill the morel mushrooms grill side down first! Throw mushrooms in a pan, with extra virgin olive oil, onion, lemon, lime, sea salt, spoon your polenta onto mushroom, add another layer. Olive tapeline on to throughout as well. Add cheese as well. To make it vegan, take away that cheese. In this video they try this meal and some wine on a Napa Valley Wine Train.
Bob DeMaria shows us how to cook up some easy and delicious Brussels sprouts. Start by browning some onions chopped into large chunks and some halved mushrooms in a skillet. This can be done on your grill. Add the Brussels sprouts whole and steam them in the skillet for about 20 minutes. Then put them on the grill and brown them further. Brussels sprouts are a healthy cruciferous vegetables that contain lots of sulfur and also helps to eliminate extra estrogen from the body. If you experience...
In this video from Patricia Stark of Craving Confidence teaches how to build confidence by untangling a necklace or bracelet. She says that the last thing you need before a big meeting or interview or event when you are on the road is to be untangling a necklace. She recommends saving the tiny Ziploc bad that is used to carry extra buttons for clothes and clothing. Small plastic space seems to keep the jewelry from tangling to itself. You can also use them as small compartments from keeping t...
In a mixing bowl put 1 cup of pancake mix, 3/4 cup of milk, 1 egg, and 2 teaspoons of oil. Use a wooden spoon to mix the ingredients together in the bowl. Then use a whisk to mix the ingredients some more. Next heat a sauce pan with some oil on the stove. If you have a vent over your stove it would probably be good to turn that vent on. Take the Oreos and dip them in the mixture bowl. Flip them over several times to make sure they are coated. Then put them in the pan of oil and begin frying t...
Wrapping your wrists for boxing is very important to provide protection and support when you are throwing your punches. This video shows you the right way to wrap your wrists to prevent injury. You'll be putting the seam side of the wrap against your skin, and start by putting the loop at the end over your thumb. You will start by wrapping the wrist a few times, depending on how long your wrap is. Watch to see the correct way to cover the knuckles and secure the wrap against your hand before ...
Be the center of attention at your Halloween party by putting together a slamming she-devil look. Let the other girls have the cheerleader and nurse outfits. You can outdo all of them by showing off your confidence with this stylish outfit. You will need some pale foundation, thick eyeliner, some good false eyelashes, blush, and some intense dark red lip gloss. For an extra effect, get a hold of some cosmetic contact lenses. This video will show you to achieve a gothic she-devil look.
In this video tutorial, viewers learn how to play the theme song from the Ellen DeGeneres Show on the piano. This video provides the order that the keys are needed to be played, in order to execute the song. This video provides voice narration and a visual demonstration for viewers to easily understand and follow along. It is at a step-by-step slow pace for viewers to easily stay connected with the video and keep up. In the video description, it also contains piano tab for this tutorial if vi...
This video demonstrates how to style short hair and get volume. If you have side bangs, part them around and up from the arch of the eyebrow. Make sure you have a blow-dryer and a large round brush, as well as a hair serum, and clips. Rub a quarter size amount of the serum on the ends of your hair, trying to avoid the roots. Put mousse on the hair roots near the top of your hair where the volume will matter the most. Section your hair off at the top and begin blow-drying by lifting the hair u...
This tutorial will help you uninstall software or programs from Windows XP. It can be used easily by beginners who have limited knowledge of the operating system. The instructor shows a visual step-by-step tutorial on how to find and use the Add or Remove Programs feature, clearly explaining and showing what you need to do, including some extra advice on follow-up checking. Make sure that when you do go to Uninstall a Program that it is the correct one and read all of the screens during the p...
Learn how to recycle and reconstruct your denim jeans: Craft side Look, Learn and Create with Stefanie Girard and Jean Therapy with Scathe G. Allison demonstrate how to recycle and reconstruct your denim jeans. You can make a bag out of your jeans by using the leg as the strap. Customize jeans by adding patches to the legs and ruffles to the bottom. All the projects use simple sewing machines and stitches and don't require extra tools. A skirt can also be made by sewing together 14 pairs of d...
If you have a shirt you no longer wear because it is too baggy, make sure to watch this video to learn how to readjust it so that you can start wearing it again. Place the top on a level surface so that its back is facing you, as you will start working on the back part of the top. Calculate the width of the top and pinch a third from each side. Join these points that you marked towards the middle part of the shirt. The next step will then involve sewing these two points together at the back o...
This is video showing you how to prepare a dirty martini drink. For making this drink, you need some 3 oz. vodka, 1/2 oz. of extra dry vermouth, olive brine, green olives. Start first with putting ice in the shaker. Put 3/4th portion of ice to get the liquor very cold fast. Now pour 3 oz. of vodka into the shaker, and put a splash of olive juice. Now start shaking the shaker. About 15 shakes should give a nice cold liquor. Now before serving put little dry vermouth, turn round the glass and t...
