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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
How to prepare bok choy for Chinese food
to transfer ice plants, take a Styrofoam cup with holes in bottom and sides for drainage. fill cup with potting soil. place cuttings of ice plants into pot, about 2-3 cuttings per cup. keep moist. for African violets, snap off an entire leaf including the stem. fill a Styrofoam cup with water. cover with saran wrap with a rubber band around the edge to keep it tight. cover completely with aluminum foil to keep inside of cup dark. place hole in center of plastic/aluminum foil with a pencil. pl...
Rather than throwing out your old furniture, learn how to give your old dresser a modern makeover by following this video tutorial. To begin, pull off all of the old drawers and other pieces that do not work. You will need to sand down the frame of the dresser and then replace all of the problematic parts. You may also need to rebuild the center supports so that your dresser drawers slide in and out easily. Wipe down the dresser with a cloth and then coat it with a latex primer. The primer is...
Pixie Litt, from Mama Do Nails helps us learn how to get a leopard printed nails. Firstly, using a E.L.F nail varnish in 'Blush', give a gentle coat on the nails starting from the tip of the nails go down to as close to the cuticle as possible leaving some edge space. Now, for the second coat use the brush in the same way but here you will be going down just half way so that it gives a more prominent look for the nails. Now for the leopard print, just use an ordinary black color nail polish f...
Use geometry to make an adorable and fun heel klickin' friend using McCormick vertex elements! You will need:
Surprise your loved ones by giving them hand made an origami bouquet of paper tulips. WHAT YOU NEED:
Is the water dripping or running in your bathtub shower? This video will show you how to remove and replace the shower valve stem and also how to replace the seal that on it. Usually the seal deteriorated over time causing your shower to leak.
This magic trick is really not so much a feat of illusion as a dizzying demonstration of physics. This video will show you how to do this easy trick with only a humble coin and coat hanger as props that will dazzle your audience for about 20 seconds with practice.
Gwyneth Paltrow joins Chef Lee Gross in the kitchen for a mouth-watering Vietnamese salad, a healthy, quick Vietnamese salad that has a great crunch and lots of refreshing flavors. This video recipe was made for Paltrow's website: GOOP.
Check out this DIY video tutorial from Curbly, the best place to share pictures of your home, find design ideas, and get expert home-improvement advice.
In order to paint nails with funky hot pink design, you will need the following: a base coat, a purple nail polish, a nail plate, stamping nail polish, a stamp, a top coat, gold glitter nail color, and a scraper.
In order to paint palm trees on your nails, you will need the following: white matte base nail polish and a variety of other colors. You will need toothpicks, if you do not have fine brushes in your polish.
DYI-FYI #57 teaches you how to fix a leaky faucet in this video. First, have to distinguish if the water drips from the tap or from the handle. If the water is leaking form the tap you need a new washer; if it drips from the handle you need a new o-ring. First, turn the water off using the valves under the sink. Next, drain the faucet by turning it on of course and grab a towel to place in the sink to prevent scratching while you work! Next, you'll have to remove the decorative topping to rev...
To decorate a fall flower centerpiece for your home, create a table centerpiece. Get some dry flowers with attractive colors of your choice. Take a metallic pot for centerpiece. Place a Styrofoam ring in the bottom of pot or vase. Carefully insert stems of dried flowers into the foam. The interior design technique is to be perfect to fall, so that it looks natural. Make sure to have the tallest flower at the center of the pot. Work from the center outwards applying more flowers and stems. Mak...
He starts with a pumpkin and some flowers from the supermarket, and some greens that he trimmed from a bush in his yard. He first cuts off the top of the pumpkin and cleans it out. He put newspaper in the bottom of the pumpkin, then puts a container with floral foam inside the pumpkin so the foam is sticking up a bit. He attaches the lid of the pumpkin to the foam with a piece of wire. He starts with the foliage and then begins adding flowers. He puts a tall stem of Japanese Lantern in the mi...
First, apply base coat to your nails. Then apply 2 coats of pink bubble gum acrylic paint to the nails. Then use a thin brush to draw an off centered cross on the nail with caramel candy acrylic paint. Using a dotting tool, apply hot pink and metallic antique copper acrylic paint in alternating dots along the cross. Then use the caramel candy color again and make a bow in the center of the cross and outline it with brown oxide paint. Let the paint dry and then apply a coat of base coat to sea...
Here's a guide in helping you store a lettuce properly and prolong its freshness. Place a paper towel on top of the lettuce and beat the stem portion with a hammer. Remove the stem of the lettuce by prying it out with your hands. Tear the lettuce into two sections or into small ones. Put all of it inside a zip lock bag and then place it inside a refrigerator. Take them out when the lettuce is needed for cooking. With these easy to do tips, you are now ready to cook those well preserved lettuc...
Need a change from your boring French manicure? Learn how you can paint this glittery leopard print nail art with this tutorial. You will need a base coat (Orly calcium base coat,) normal plain transparent tape or you can use those premade french manicure nail stickers, white nail polish, black nail art polish
Want to get a salon quality French manicure at home? This tutorial teaches you how you can get a perfect French manicure with regular clear tape. You will need base coat (Orly - calcium base coat,) tape or you can use those pre-made French manicure stickers, white polish, top coat. The trick to a perfect manicure is to wait for the white polish to DRY before applying top coat to prevent smudging. With this how to video you will be able to paint your nails in a perfect French manicure.
This article is for anyone wanting to learn how to do gel nails at home. Although it is easy. It is time consuming, so be prepared to have at least 30 minutes to do all the steps. We chose to do gel nails with a french press tip.
Mac OS X has convinced many traditional PC users to switch platforms. While Windows 7 may do something to stem that tide, a lot of you PC users reading this have probably thought about switching right? If you have, watch this video. It will give you a PC-user centric rundown of OS X and allow you to make a more informed decision about what operating system is best for you.
Rust protection doesn't have to cost a fortune. With a little zinc and some electricity, you can protect your precious metals from rust by galvanization. When you galvanize something, you're giving it a protective coating, and in this case, it's a zinc coating.
Check out this short video tutorial from Rouxbe on how to pit and dice an avocado. This video will support your cooking experience and will provide you with additional relevant information during your culinary time pitting and dicing avocados.
The feather stitch is an easy stitch for hand embroidery. It's worked vertically, from top to bottom in a kind of back-and-forth, right-and-left motion. You can use the feather stitch in hand embroidery for edges and borders, it's used often in crazy quilting as a seam embellishment, and it also makes a good foundation of foliage or stems in flower designs, in Brazilian embroidery, and more. Watch this video from Needle 'n Thread to see how it's done.
Sometimes an ordinary coleslaw just doesn't do it, so that's when you try out different ethnic recipes. And this Asian spin on slaw is sure to be added to your list of favorites, from the dressing to the actual salad mix. Check out the recipe for this delicious Asian coleslaw with peanut dressing.
Bill D., the tech lead at all3sports.com takes us through the steps involved in unpacking and assembling a brand new bicycle. The first he says is to set up or insert the seat post. He recommends using a work stand if you have one at home. He says not to unpack everything at the beginning, but to just expose the seat pack first. Use a wire-cutter to get rid of the film protection used for packing. He has mounted the frame-set on the work stand. The seat post goes into the frame-set. He asks t...
He says that he is soling to make some foliage, flowers and leaves draping out of the vase so that it gives you a feeling that you are in Greece when seen from the balconies of houses in the hillside or something. He first puts some lemon leaves to cover sides of the vase making them drape out, them he puts some comatose leaves on the sides along with the lemon leaves and asks you to make them hang outside from the sides of the vase so that it gives a real delicate look. He says that all thes...
Want a change from your boring old pink and white French manicure? Learn how to create red French style nail tips with white polka dots with this manicure tutorial. You will need base coat and top coat, red and white nail polishes, and Q-tips or corrector to clean up corners. With this how to video you will be able to create a red French manicure style nail tips with white polka dots.
Plasti Dip coating is a rubber like coating that can be dipped or sprayed on. I first remember the coating available as a dip years ago. It was first introduced as a coating used to dip tool handles in to provide a grip. However, since then, the coating has became available in a spray can. It has also became popular on car parts, such as wheels, emblems, and even entire cars.
In this tutorial, we learn how to make a paper flower using napkins. First, roll the paper over to one side and then start to roll it up with the other side as well. As you do this, the napkin will start to roll into the shape of a rose. When finished, you will pull out the edges to create different lengths with the petals. After this, use a green napkin to create the stem of the flower, making a small leaf in the stem by ripping it. When finished, continue to make these to create a beautiful...
Swiss chard comes into season over the next few months, meaning the leafy green vegetable will be deliciously ripe, crunchy, and tasty. Take advantage of this in-season veggie by throwing it into your next dish.
In this tutorial, we learn how to draw an apple. Start by drawing the outline shape of the apple. It looks like a slight heart shape in the middle of the apple where the stem is. After this, start to fill in the apple with lines to make it look more realistic, then draw the stem and a leaf coming out of the top middle of it. Color in the leaf with browns, blacks, and green. Then, draw lines on the bottom of the paper to make it look like the surface. Finish by coloring the apple red, making d...
In this tutorial, we learn how to draw a rose, step by step. start off drawing the petals of the rose, making the inside of the flower first. After this, start to draw in more details and draw around the inside of the flower, making the rose larger and larger. After you have done this, draw on the stem underneath where the petals are, and add leaves onto the stem. Continue to add in any details that you see fit throughout the picture. When you are done drawing, color it if you prefer, then si...
In this tutorial, we learn how to make a paper rose with a paper towel. First, roll one end to the other, then stick your finger inside one end and pinch the tip while twisting a few inches down. This will be your bud and your stem for the flower. Keep twisting down until you reach halfway to the end of the flower. Now, fold the loose piece on the bottom so it's parallel to the stem. Then, twist the leaf and wrap it around the bud. Then, shape the bud to the type of flower you want, then enjo...
In this tutorial, we learn how to make a paper cigarette from a cigarette foil. First, fold a piece of foil length wise, then flatten out the creases. After this, unfold the paper and tear it in half. Now, fold half of it in half again to make the stem of the flower and twist the top. Use the other half of the foil to make blossoms and flower petals. When you are finished shaping these, attach to the stem of the flower and shape more to make the flower look more realistic. Attach more leaves ...
Jonathan Wallace demonstrates how to pickle beet root and store garlic. First, boil the beet root. Keep the root and about three to six centimeters of the stem on the beets during the boiling process. Next, create a spiced pickling vinegar by using 2 1/4 liters of vinegar, cinnamon powder, 12 cloves, two tablespoons of coriander seed, one tablespoon of mustard seed, four dried red chilies and two teaspoons of black peppercorn. Boil the ingredients together and then let it simmer for 15 minute...
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.
Simple Kids Crafts demonstrates how to make a decorative painted tin case for a mom's jewelry. To make the decorative case, you will need one recycled tin case with a lid, paint, and thick and thin paintbrushes. First, use the thin paintbrush to paint green stems of grass on the tin. Then, use the blue paint and a thick brush to paint grass blades on the tin. Use the red paint to paint a large red flower on the tin case. Let the paint dry. Use a thin paintbrush to accent and outline your flow...
In this particular video, a small girl named Kayla, describes how to draw flowers. First, we need a pad of paper and some kind of a drawing instrument, like pen or a pencil. Then, make a circle and draw some flower petals. Then, put some dots in the middle of the circle to make a shade. You may color it to make it look better. Then, she makes a rose with a stem, a couple of flowers, and a flower top with some petals. Then, she explains it. To make a rose, make a big dark spot in the paper, ma...
