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
If you've ever gone Christmas tree shopping before at a Christmas tree lot, then you're probably more than familiar with Noble Firs, Douglas Firs, Grand Firs, and maybe even Blue Spruce and boxwood (used for wreaths). But have you ever considered using other varieties of evergreens in your decorating?
In this video, we learn how to arrange a flower wedding corsage. First, grab a white flower and cut the stem off of it, then wrap floral tape around it. From here, grab a pink flower and do the same process. Next, grab baby's breath and other small leaves and add them to the pink flower and the rose. Use floral tape to wrap these all together until they are all stuck together. When finished, cut off any excess stems to the flowers and you can wear as a corsage! Use pins inside the stems and o...
In this tutorial, we learn how to design a winter themed flower centerpiece for home. First, you will use florist foam to place some winter branches from pine trees on the bottom. After this, stick some bare branches standing up on the inside. Then, you will grab some large pinecones and lay these around the side of the arrangement. From here, grab some short stem red roses and then apply these around the branches until everything is covered. This will finish up your arrangement and you can p...
Origami flowers, whether they're roses or hyacinths, are gorgeous on their own, but even more realistic when a stem and leaves are added. Unfortunately, the art of leaf folding in origami circles is usually othered in favor of folding the actual pretty flower.
This video is a tutorial on how to arrange a dozen yellow roses for a vase. The speed of the video is increased four times faster than the normal rate of speed. The man arranging the flowers does not explain the step-by-step process of his arrangement. The viewer sees the man first arranging green leaves in the vase. Second, he dips the yellow roses into a liquid solution in a separate container before putting them into the vase. The tallest yellow rose is the center rose in the arrangement, ...
This video is a demonstration of how to create a Grecian style flower arrangement in an urn. He starts with a green urn on a pedestal and puts in some craft foam. He uses two different kinds of green foliage, one with large leaves and one with lighter green smaller leaves around the base. He then adds some pale beige stalks that drape down on all four sides. He adds some big fluffy deep yellow flowers and smaller red ones, keeping the arrangement in a low round shape. He puts in white roses a...
This origami lily fits perfectly atop several models of origami stems. The origami lily is a fairly complex origami endeavor, but these visual guidelines will allow you to complete come of the more difficult folds. Watch this video origami tutorial and learn how to use the Japanese art of paper folding to make a paper lily.
Make a bouquet of origami flowers with an explanation of how to fold a stem that is made of paper.
Fold an origami tulip with a stem with the design by Joost Langeveld.
Learn about creating an air twist stem on a goblet with Corning Museum of Glass experts.
Michele Knaus, from EatLikeAChef, shows how to prep an artichoke. 1. Remove thorny pieces on the ends with kitchen shears. 2. Remove out-most layer of artichoke leaves. 3. Prep the stem by peeling with a peeler. Peel like a carrot. It is good to leave the stem on because it has a nice taste and it is a good way to tell if an artichoke is done. The stem will bend when tender. 4. To get inside of the artichoke, take the entire top off. Use a large, sharp knife to do this. 5. Gently slide open w...
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.
John Campbell, from azbushman, demonstrates how to make a quick bow and arrow in the wilderness by collecting natural materials and constructing them with cord. He starts by finding seep willow (also called coyote willow) that grows in clumps near rivers. He cuts ten willow sticks and ranges their lengths from about five feet down to about one foot, each a couple of inches shorter than the next.
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...
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...
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...
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.
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...
Learn the art of drawing a ‘Lotus Flower’ on your computer, by watching this video. Begin by drawing a faint outline of the flower at the outset. This is done by drawing an oval shape first. Then a straight line is drawn below the oval, along the center. A semi-circle comes next, touching the extreme ends of the oval shape. Similarly, a mirror image of the semi-circle is drawn, below it. The petals of the lotus flower are then outlined in dark, from the center and on either side symmetrically...
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...
This is a quick and easy way to prepare healthy broccoli. On your chopping board, lay broccoli crowns upside down. Cut around the broccoli in its flower heads using a knife holding up the stem/stalk. (Set aside flower heads). Cut out the stem to get the edible white part of the stalk. (It's your option to include this with the flower heads.) Use this on your favorite dish.
Victoria Walsh from Chatelaine TV will show you how to cook an artichoke in this very simple video. To begin you want to make sure to remove any dried leaves from the artichoke, and then proceed to clip the rough ends of the remaining leaves on the artichoke. Next, you want to cut the top off, and then cut the stem off leaving only about three quarters of an inch. Now, you want to prepare a boiling pot of water and let the artichokes stem in the pot to tender for 25-45mins. To check the tende...
How to make decorative roses out of baby socks. All you need is a baby sock and some floral wire and green floral tape. Watch the video to learn how to wrap the sock to look like a rosebud around a wire stem, and then tape the base of the sock well with the floral tape. Continue to wrap the tape all the way down the wire so it looks like a nice green stem. Makes a great gift for expectant mothers as it's not only cute but they can also unwrap them and use the socks for their new baby boy or g...
CHOW Associate Editor Corinne Trang teaches you how to use lemongrass in your cooking. 1. To use your lemongrass in your cooking, first strip away the dry outer leaves, and cut away the stumpy end and the dry leafy ends.
Have an itch for a kumquat? Don't know what a kumquat is? It's a fruit. Venture out of of your everyday apple, and follow these steps to impress your friends with your knowledge of this funnily named fruit.
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.
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.
