See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...
The inspiration behind Gwen Stefani's Harajuku Girls fragrance, real Harajuku girls are gals from the Harajuku region of Japan who dress up all crazy like in the Lolita, Ganguro, or Cosplay styles.
Dragons are one of the most fun, traditional, and challenging things an artist can draw. Fortunately, Drawing Now is here to help you get started with this tutorial on how to draw a cute, simple, Western-style dragon. Here are their step-by step instructions:
Grey hair doesn't hold hair dye very well, within a few days it always returns back to a greyish color. If you have trouble keeping those stubborn greys covered, check out this tutorial.
In this Software video tutorial you will learn how to create a vector RSS icon in Illustrator. Open illustrator and open a new document. Select the ‘rounded rectangle tool’ from the rectangle menu. Click and drag to draw a rounded square. Select the gradient fill on the left side and change the color to orange on the right side and make it dark to light from top to bottom. Next grab the corner and turn it around 180 degrees. Move the picture to one side and select the ellipse tool. Draw a...
Make an adorable puppy dog out of two balloons, perfect to entertain children with! You can make your balloon creation more interesting and more detailed by adding more balloons. This balloon figure can become any number of different types of dogs if it's decided to change the colors and proportions. Your Balloon Man, Mr. Fudge, is full of balloon tricks! Be sure to find other balloon videos on WonderHowTo from Mr. Fudge teaching everything from animals to planes! In a few twists and a few ti...
In this video,we learn how to make pan toasted millet. You will need 1 c water for 1/2 c millet. Grab a pot and turn it on high heat. Add your millet and keep stirring continuously so it doesn't burn. It will start to turn a golden brown color and you will smell a nutty flavor coming from them. After it is completely toasted, add in your water and stir the mixture until it boils. Add in cinnamon and any other flavors or items you prefer in the millet. Stir again and put the lid on, then turn ...
The Caldesis shows us how to cook Duck with Cherry Sauce, in this video.To get strated,reduce some Gabbiano red wine and sugar in a pan.On a baking tray put in some tinned cherries and pour its juice on the top.To this,add some orange juice and sprinkle some sugar on top.Put this in the oven,for 10-15 minutes,at 180 degrees F and cook until the cherries are browned and the sugar is caramelized. Take four duck breasts and trim off the excess fat on the sides.Sprinkle some salt and pepper on it...
This video from Liaison College demonstrates how to make coconut macaroons. The ingredients needed are egg whites, granulated sugar, salt, vanilla, sifted cake flour and sweetened shredded coconut.
Hilah Johnson demonstrates how to make a quick and easy recipe called Hush Puppies,in this video.In a bowl take some leftover corn dog batter add an egg to it.Also add 1/2 cup of cornmeal,three nicely chopped green onions and a tablespoon of sugar.Mix the ingredients thoroughly.In a deep fryer add anough oil for deep friyng and heat it.When the temp gets to 375,take some of the batter mixture in a spoon add it to the oil.Keep turning the hush puppies to avoid them from burning.When they are g...
Did you know that Jennifer Lopez, also known as "J. Lo", got her start as one of the "fly girl" dancers on the comedy sketch show, "In Loving Color"? To become a backup pop dancer, you need to get yourself out there and meet people with similar interests or join a dance team. Discover some steps one can take to getting closer to their goal of ecoming a backup dancer with advice from one expert.
This video shows the method to make buttercream icing. Take a cup of white shortening so that mixing it with the other ingredients will make the color white. If you like the taste of butter, you can use half a cup of butter and half a cup of shortening. Start mixing the mixture. Add one teaspoon of vanilla, lemon, orange or almond extract. Add four cups of confectioner's sugar or powder sugar to the mixture. Add it slowly to the mixture so that there is no smoke which forms by adding the whol...
In this Family video tutorial you will learn how to do leaf rubbings for a children's activity. For this you will need a flat surface. If the table top in slightly uneven, put a sheet of construction paper on it. The materials you will need are sheets of paper, crayons and leaves. You can also use fabric leaves if your area doesn’t have any leaves. Take a leaf; put it upside down on a flat surface so that the veins are on top. Put a sheet of paper over the leaf and hold it down with one hand....
This video shows us the method to draw a fashion concept sketch. You must show the figure of the person you are drawing. You can draw the figure wearing a scarf you have designed. You can draw the flowers on it. A lot of sketches are very long. There are a lot of vertical lines and plates in the sketch. There are long legs at the bottom of the sketch. The parts of the body are not in human proportion. You can draw bracelets and a purse in the sketch. The sketch would be finished with color, v...
In this video tutorial, viewers learn how to make a Christmas countdown chain. The materials required for this craft are: construction paper, paper cut into small circles, glue and marker (optional). Begin by cutting the green and red construction paper into even strips. Users may choose to write out the numbers or print them out onto paper. Then cut out the numbers into small circles and glue them in the middle of the strips. Alternate the color of the strips each day. Then put the edges of ...
In this tutorial, Kandee shows us how to tie a wrist bandanna. First, roll up your bandanna and lay it on your hand. Wrap it around your wrist several times and tie at the bottom of your wrist! This is not only a cute way to make a fashion statement, it can also be used for when you're doing your makeup! If you mess up, it's an easy way to clean up any messes. You can choose different colors and designs for your bandanna and match them to your different outfits. You can also wear bracelets an...
In this video tutorial, viewers learn how to make a foam collage. The materials required for this project are: card stock paper, several different colors of foam paper, scissors and glue. The project focuses on preschool, kindergarten, and elementary school crafts. Begin by cutting the pieces of paper foam into different shapes and sizes. Then simply apply glue on the pieces and stick it onto the card stock paper. Continue doing this to cover the entire sheet of card stock. This video will be...
This is a demonstration of making a wreath with tissue paper. For this you will require tissue papers cut into squares, golden colored yarn, golden dust. For tools you require a pair of scissors, a hole punch, glue, paper dish. To start with cut the bottom of the paper dish neatly so that the uniform rim remains. Now apply glue to the rim in the form of spots and streaks. Now take each of the tissue paper pieces crush them and press on the glue. When the whole rim is covered with crushed tiss...
According to Shelley Lovett Pop Beads are a wonderful addition to any early learning environment. In this video Lovett starts by showing all of the different shapes, sizes and colors the Pop Beads come in. She also explains to the viewer where the beads can be purchased. Lovett then demonstrates how the unique construction of the beads makes it somewhat difficult to snap them together. Yet is it the required pinching and grasping that makes playing with Pop Beads so beneficial to developing a...
In this Hairtalk episode you are shown how to get Taylor Swifts curly hair using hair extensions. The extensions used are a 16 inch 10 piece Wavy Clip in Extensions by POP. Simply by putting the larger of the pressure sensitive clips in, part by part, starting at back side bottom going upwards, ending with the smaller clips filling in where it's needed and around the face, you get a fuller and longer hair, with weather proof waves. The hair in the extensions are made by synthetic fibers, that...
This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...
In this video tutorial, viewers will learn how to make a milk carton lantern. This lantern uses recycled items. The materials required for this lamp are: a milk carton, unryu paper, colored newspaper, raffia, ruler, glue gun, hole puncher, X-acto knife, glue stick and scissors. Flatten the milk carton. Draw a rectangle with each panel and measure about 1/2" form each of the sides. Measure about 3/4" from bottom and top. Cut out the rectangles with the X-acto knife. Glue the newspaper to the c...
Each player starts with 15 marbles that are a color distinct from his opponents marbles. Toss a coin to choose a start line, placed 3 meters from the hole. The players then take turns shooting marbles, first from the start lines, then from wherever the marbles land on the field, all the while trying to make their marbles in to the hole. The player to shoot all his marbles in to the hole first wins. In a case where both players have 1 marble left and the final shot is made by the person who to...
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
In this Modern Mom video, costume designer and fashion consultant Cate Adair shows how to wear a spring scarf. She shows how to use a long thin scarf as a belt. She threads the scarf through belt loops and tying it in a simple knot around the belt loop at the end. During the video, she discusses using fabric as a scarf, or changing the width of the scarf depending on body shape. Finally, she uses a large square scarf folded in half from corner to corner to tie a "sarong" style splash of color...
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
The metal clay must be completely dry before you begin the torch fire procedure. Set up your work space in a well-ventilated area with your metal clay on a fire brick. Start your flame and move around the piece in a circular motion, not staying on one point for long. You might see little flashes of flame. Don't panic. That is to be expected. Time yourself for about a minute. Your metal clay should take on a peach color. It is important not to use a butane torch and metal clays that contain or...
Showing how to make of a cucumber out of polymer clay. The instructor begins with the color of clay she is going to be using, greens and translucent. She makes six inner 'seeds', then she shapes them around a core piece. Around the middle, she wraps 2 layers of translucent clay, then a light green, and the final dark green outside. The whole time she's lightly shaping the piece into a tighter compact whole, saying this needs to be done while the clay is warm, and not to walk away or take any ...
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...
This tutorial demonstrates how to make simple yet beautiful paper roses using only a few materials. The image displayed at the end of this video is just one example of how realistic a paper rose can look. In order to do this, you will need at least one sheet of plain or colored paper, tacky glue, wire and a pair of scissors. Initially, you must first cut your paper in to the shape of your pedals, then crumple them up. Crumpling your pedals not only makes them more flexible, but can also add a...
In this video tutorial, viewers learn how to make a Japanese-style sushi roller flower vase. This flower vase uses recycled items. The materials required to makes this vase are: a newspaper, scissors, raffia, sushi roller, acrylic paint, brush, tin foil, tape (or glue gun) and an empty bottle (300 ml). Cut the newspaper to about 3" x 12". Paint the newspaper to your preferred color. Cut the top part of the bottle. Roll the bottle in the sushi roller. Wrap the newspaper around it and tape it. ...
Yanik Chauvin shows viewers how to add a reflection using Photoshop. This tutorial focuses on how to do a reflection on a white background. You can do this with objects as well as people. Bring up your image with a white background to add the reflection to. First, you should press ctrl+j to add a second layer. In order to do a reflection, you need room, so you need to increase your canvas size. To do this click image, click canvas size, and click the bottom arrow so it can expand downward. Yo...
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...
Classroomnext describes how to create a Google form with your own custom colors and designs to give it a personal touch. Once you are logged into the Google Docs main screen, click on the button that says "New" and choose the option "Form" from the dropdown menu. Once your new form appears onscreen, type in a simple test name in the title field and a placeholder question. Save the document. Click on the button that says "Theme" and you will be shown a variety of styles to choose from. Save th...
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...
Decorating Tips demonstrates how to use the star tip to decorate a cake or cookies. Use a medium consistency icing and position the bag at a 90 degree angle. Hold the tip 1/4 of an inch above the surface of the cake or cookie. Use the count squeeze, stop squeezing and stop to create a delicate star look with a size #13 star tip. With a size #18 star tip, shorten the count and put the icing stars right next to each other to fill in a cake. Use different colored icings as accents. You can also ...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
This video will show you how to create a flow chart in MS Word 2007. First click on the Insert tab. You can see the smart art option, click on it. A "Smart Art Graphic" window will appear.
You can't be dumb to pull off this ventriloquist dummy look. This is a perfect look for any Halloween party or event, or even if you just want to scare a couple of friends. In this video Youtube user goldiestarling gives us an instructional video on how to emulate a ventriloquist dummy look for any occasion. To achieve this look you will need a number of colored matte shadows, your application brushes, and about 15 minutes to get this awesomely spooky look.
