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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
This film from Woman's Weekly shows you how to line a round cake tin. First you take non stick baking parchment. Fold the paper to double thickness, then rest the tin on top and draw around it with a pencil. After that, then cut just inside the pencil line to compensate for the thickness of the tin. For the sides, you roll the tin on its edge, allowing some extra for overlap and a little extra height above the tin. Make a fold a couple of centimeters from the top and then make some cuts from ...
In this video from Polymer Clay Productions, we are shown how to make earrings out of polymer clay marshmallow Peeps. They use holographic yellow glitter for the sugar, polymer clay, and Sunny Side Up yellow coloring. Use a clay color and glitter color that match. Have some real Peeps handy for reference.
As a kid, I was always interested in what was beyond our world. I remember lying down on the top of my dad's car and watching the stars for hour, gleefully excited whenever a shooting star streaked across the night sky.
In this video tutorial, viewers learn how to use googly eyes to liven up household items. This video provides 3 crafts that viewers can make with the googly eyes. The first craft is a homemade snake with googly eyes. The snake is made from a draft blocker that is stuffed with rive. The second craft is to apply two googly eyes on your footwear. The third craft is glue the googly eye around the frame of a pair of glasses. This video will benefit those viewers who enjoy making arts and crafts, a...
The HP App Catalog features thousands of apps ripe for downloading and installation on HP's webOS tablet--the TouchPad. Take a look at this guide to find out how to search for apps using HP's version of the app store. The walkthrough will even teach you how to install them, so get ready for a few rounds of Angry Birds!
Many sewing machine repairs can be made at home, and most repairs can be completely avoided through routine sewing machine maintenance. This tutorial shows you how to carefully disassemble your machine to give it a round of maintenance. You will need a screwdriver - make sure not to lose any of the screws!
We never thought it was even possible to fold a hedgehog out of paper. After all, a hedgehog is very round in shape and has spikes that jut out all over its body, making it hard to translate into paper.
In this 41 minute tutorial, learn how to build a spherical glass mesh with softbody physical properties (and filled with round particles) that enable it to bounce without breaking in Cinema 4D. Nick from Greyscale Gorilla shows how.
A standard straight up and down Beyblade launch usually sends your Beyblade spinning around the edge of the Bey Stadium. If your opponent's Beyblade is in the center of the stadium this means that you will lose a lot of power before you hit them and probably lose the round. This video will show you how you can angle your launcher to do a sliding shot that will cross the middle of the stadium and win you more Beyblade.
Need to insert a scrollable gallery of thumbnails into your website or web project? You've come to the right place. In this tutorial, learn how to build a scrolling thumbnails video and take it to the next level by building a fully functional gallery with a bonus randomizer button. Learn about using variables and rounding numbers and navigating time lines within a flash movie with actionscript.
Want to do some cool gymnastic martial arts. This video will teach you how to do an aerial cartwheel and aerial round off.
All the dentil molding is on and now it's time to add another layer. Tommy shows how the applied dentil molding looks and how the soffit and quarter round fit over it. He then attaches them to the case. Tommy cleans up the dentil molding with a chisel so it is flush with the quarter round. After gluing the final corner in place, the first part of the crown is done and Tommy can enjoy a victory cigar.
Ching-He Huang shows us how to make a Five Spice Chicken Stir-Fry. Start with chicken breast, oyster sauce, corn flour, carrot, ground white pepper and salt.
This is part one of two in how to make a beautiful tree of life pendant. It is very easy, and you'll only need a few items. Things you'll need: wire 2-3 mm thick, Round nose pliers, 4 pieces of thin wire, 12 inches long, wire cutters. With your round nose pliers, bend the thick wire about an inch form the end. Make a question mark shape, and twist the end around. Go down about 5mm, and make a 90 degree bend. Go across as far as you want, and make another 90 degree bend. Keep making bends unti...
Smartglasses are the future of augmented reality, and Samsung is betting on waveguide maker DigiLens to emerge as a leader in the growing AR wearable industry.
Investors are ready to throw their money at augmented and virtual use cases that demonstrate a business purpose and a return on investment.
In this video, we learn how to pierce your lip with a flat or round back. First, purchase some flat backs from the store, don't use normal earrings because this will damage your skin. Flat backs don't hurt when you pierce them. To start, you will need to find the spot where you want to pierce, don't hit a vein. After this, use ice to numb the spot until you think that you are ready. Then, poke the needle through the hole after cleaning it off with alcohol. Make sure to clean the lip area when...
In this video, we learn how to draw anime eyes in MS Paint. First, draw the round circle for the head and draw a line in the middle for reference of where the eyes will go. To draw large eyes, draw two round circles and then a small pupil at the top. Color the pupils in black and color the rest any color you'd like. For female eyes, make the pupils much larger and add in eyelashes on the eyelids. Shade in underneath the lids and add white to show they are glossy. These are both great looks fo...
In this tutorial, we learn how to clip curves when sewing with rounded seams or edges. First, you will take your piece of clothing, then grab your scissors. Put the edge of the clothing (with the seam) and lay it flat. Then, put the scissors onto the seams with the very back of the scissors over the fabric. Clip close to the seam, but do not clip through the seam as you are cutting. Once you are finished, you will be able to sew in curves and will be able to easily get around the seams withou...
Disney starlet Selena Gomez was once called "the next Miley Cyrus," but over the past year or two she's really stepped out on her own as a bonafide movie star and pop singer. With recent hits like "Naturally" and "Round and Round" to add to her long list of accomplishments, the actress is setting the curve for a new era of stars.
In order to make an adjustable cable necklace, you will need the following: 20 inch adjustable cable chain, a slide bead frame, 2 head pins, 8 mm bi-cone, 8 mm crystal, 2 6-mm round rondells, 2 7-mm jump rings, a pair of nipper tools, a pair of round nose pliers, and a pair of chain nose pliers.
If you're an advanced jewelry maker who's looking for a beautiful challenge, then you've come to the right place. This Egyptian clasp, which features a rounded loop head pin, a bunch of spiral curls, and a longer rounded loop headpin, is among the more difficult clasps you can make, but as you can see, the results are quite spectacular.
In order to make a hook for an earring, you will need the following: round nose pliers, a wire cutter, a nail file or sand paper, an ink pen, 20-22 gauge wire. With your round nose pliers, make little hook, in the end of the wire. Bend it, until it makes a little loop.
This video shows us how to make paper flower with ease. Here are the following steps: Step 1: Gather paper, glue, scissors.
This video shows us how to perform a round off back somersault. Firstly you have to make sure that your leading leg must be wide when you put your hands down. And when you place your hands down, don’t place them parallel to each other but just place them slightly tilted. While you place your hands down, keep your head within your shoulders and when you place your hands down your back leg kicks back and you will rotate on your hand. When you go down, both your legs will be kicked to the back a...
Artbeads demonstrates how to make a simple loop using eye pins. Simple loops on head pins or eye pins are great ways to attach charms to your jewelry. To make a simple loop use chain nose pliers to make a 90 degree bend in the pin above the bead. Then, cut the wire so that there is a 3/4 inch tail on the wire. With round nose pliers, create a loop on the end of the wire. Use chain nose pliers to open and close the loop to attach it to a chain or clasp. You can also make a loop by using the ro...
Fimo expert Corinne Bradd and Emma Ward with The Crafts Channel and magazine Craft Beautiful demonstrate how to create a striped cane in 5 minutes. To create the stripes, cut out rectangles of black and white clay and stack them in alternating colors. Then, roll out a cane in a nice, bright color so that it matches the length of the stacked clay rectangle. Then, cut the rectangle into slices. Then, press the rectangle stripes onto the bright cane so that it completely wraps the cane. Squeeze ...
Televisions are an amazing innovation that allow for endless hours of entertainment and information dissemination, but sometimes you just want them off! Make a TV remote jammer as a joke, to get a few hours of quite or just for fun.
This video demonstrates the making of zebra beads presented by Garden of Imagination. To make zebra beads, take white and black clay. First take the white clay and flatten it and then do the same with the black clay. Arrange them in five flatten layers one white strip and other black strip respectively. Cut it with cutter and fold around (up, down, right, left) the round bead of white clay and roll it in your palm to make it round. To make it as a bead poke it with pokeyard from both the side...
Marianna takes us through the process of creating a beautiful set of earrings! For this project you will need two sterling silver head pins, four fresh water pearls, some gemstones of your choice, two sterling silver ear wires, round nose pliers, flat nose pliers, and a cutter. Take your head pin and string your beads and gemstones on the head pin. Next using the flat nose plier, bend the end of the head pin to create a 90 degree angle. Then make a simple loop where the ear wires will be plac...
This video teaches the method to add a virtual frame in Lightroom. The frames can be black or white. Go to the 'Develop' module. Open your Vignettes box. Go to the post-crop section. Slide the last three sliders to the leftmost position. Move the 'Amount' slider to the left to choose black frame and to the right side to choose white frame. The frame is rounded on the upper two corners. The 'Roundness' slider is used to round the frame inwards until a complete circle is obtained when the slide...
This Diet and Health video tutorial will demonstrate to you how to do an ankle tape job. Take two pads and put them on top and back of the ankle with the toe facing up. Then take the tape and pull it tight. Start about two to three fingers below the calf. Wrap the tape nice and tight around the leg going round and round all the way down to the ankle. Then dive down under the foot and come around under the back of the heel and cut it off. Now you put the first anchor right around the foot. The...
is a video presentation about "Shaping Pizza Dough" and to mastering great at home is shaping and stretching the dough. Put the dough in plastic cover for 6 to 8 hours in room temperature or 12 to 24 hours in refrigerator in an sticky form. Then, sprinkle little bit flour and peel the dough into small pieces. Then, take your fingers and punch down the dough and forming a round shape. By using the rolling pan, make smooth edge dough in round shape and then...
This video describes the ways people hold onto fat. There are three main types of bodies. There are naturally skinny, round with an easy time gaining weight and overly round with a hard time losing weight. Each person is different but in certain body groups there is an easier time to maintain a lean appearance. Fat cells in your body also play a part in you getting fat and staying thin. It is said that all of your fat cells have been fully grown in your puberty years. There are some new studi...
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...
Mangoes are not easy to peel. This technique shows how to preserve them in the freezer. Mangoes start off green and become purple and then finally orange. When they are brilliant colored, it's time to pick them or buy them. They have a clear almost sticky juice when they're ready. The central stone is flat and round. It's quite hard to remove. Use a thin flexible life to follow the contour of the mango. Lie it down on one of its flat sides. Then peel it in small sections, holding it still wit...
This video demonstrates how to draw eyelashes using Adobe Photoshop and a graphics tablet. You need three tools to draw eyelashes: Soft Round Brush, Smudge Tool, and Eraser. Create a new layer. On the upper eyelid, draw each eyelash with Soft Round Brush (color: black, width 17px, opacity 100%). Use Smudge Tool (width 45 and straight 25%) on the eyelashes to straighten them. Use Eraser (width 65 and opacity 100%) if necessary. Create a new layer and use the same tools for the bottom of the ey...
This video is one of a series of steps involved in crocheting cute woolen baby socks. In the beginning of this step, which is in fact step number seven, the shape of the baby socks can already be seen quite clearly. Use yarn or woolen thread of the thickness and color of your preference. Also prepare the hook you are going to use to make the stitches. Start by applying a chaining up twice. Then you have to apply half double crochet in each step around, always going round and round the circumf...
With the '70s gaining major fashion momentum in the recent Spring/Summer 2011 shows, big hair is here to stay. While voluminous, Beyonce-like locks has always been popular, it's especially hot this season.
