In this software video tutorial you will learn how to merge and unmerge cells in Excel. A cell in an Excel spread sheet is assigned a row and a column number. You will mostly need to merge cells when you are trying to create headers that span across two or more cells. For this select the cells that you want to merge by clicking and holding down the left mouse key on the first cell and then dragging it across the other cells that you want to merge. Then go to the 'home' tab, click on 'alignmen...
In this video, we learn how to do a kettlebell for beginners. The first exercise you can do is a kettlebell front swing. Stand while opening your legs, then pick up your kettlebell and swing it through the middle of the legs. Use a tight movement and use momentum to control your upwards and downwards movements. The next exercise you can do is a single arm front swing. You will do the same movements as in the first exercise, except holding the kettlebell with one hand and having the other plac...
Make sure your camera is set to the Manual Mode. Then, adjust your camera to your desired shutter and aperture settings. Make sure the pop-out flash button in your camera works. Prepare night lights such as sparklers, glow sticks, and flash lights as props.
In this tutorial, we learn how to do a half up and half down hair look. First, grab the top middle of your hair and comb it up, then hair spray it and tease it up. After this, curl while still holding up, the repeat this for the rest of the hair on your head. To finish, spray hair spray all over the hair to keep it in place. Next, pull half the hair up and push upwards, then use bobby pins to clip it into place. Check in the mirror to make sure it's even and move your head to make sure it's s...
In this video, we learn how to understand the basic golf swing. If your contact with the ball is good, your shot will be played out correctly. In a full shot, you would make your back swing, then shift your weight onto your left foot along with your belt buckle. Using your body in a swift swing is the key to having a good swing and making the ball fly where you want it to. Give yourself enough time to practice, because it takes your body a few tries to get used to this stance. When you are do...
In this video, we learn how to draw a Final Fantasy character. Start out by drawing a rough outline of the entire body, starting with the head then doing the rest of the body and ending with the hands and arms. After this, draw over the initial markings with a black paint brush. Draw in eyes and hair, then start to draw in the details of the body armor and clothing. Make sure to draw on pants and make a sword that the character is holding. After this, fill in the painting with different color...
We love shiny things. Pretty baubles, Swavarski crystals, long link chains holding art deco pendants. And that's why we also have an extremely messy jewelry storage system. Basicall this is how it goes: we buy a necklace, wear it once or twice, and then toss it into a sort of bin type thingy.
In this tutorial, we learn how to cut up a raw chicken. First, start with a very sharp knife and a complete whole chicken. First, cut the legs from the chicken by pulling the skin taut at first between the drumstick and the breast. Next, remove the wings by holding the chicken on its wing and looking for the armpit. Slit into this, and bend back the wing, then cut through. After this, remove the back from the chicken and then you will be left with your chicken breast halves. Turn it over skin...
In this video, we learn how to make a snowboard box. The box will be 10 ft long by 1.5 feet wide and 2 feet tall. For the box structure, make small cube like structures that are surrounded by large boards holding them up. Screw all the pieces of wood together, then cut out your plywood and place it on the wood to make a shell. Check to make sure the box is sturdy by standing on it, then place plastic on the bottom of the wood to keep it away from snow or rain. When finished, use the board to ...
In this video tutorial, viewers learn how to a horizontal line in Microsoft Office 2007. Begin by clicking on the Page Layout tab and select Page Borders. Then click on Horizontal Line. Scroll through the list and select a type of horizontal line. When finished, click on OK. Users are able to drag the horizontal line around by holding down the left button on the mouse and moving it. When users highlight the line, right-click on it and select Format Horizontal Line. There users will be able to...
In this Education video tutorial you will learn how to make smoke or fog rings with a rubbish bin. This is really very easy and simple to do and takes practically no time. For this you will need a smoke machine like the ones used in night clubs, a rubbish bin, piece of oil cloth and a strap. Cut out the bottom of the bin and cover the top of the bin with the oil cloth and strap it up. When you push on the oil cloth, air will go out of the hole at the bottom. Now fill the bin with smoke from t...
This video tutorial is in the Video Games category which will show you how to unban your Xbox 350 live account. For this you will need the eXen card and the eXen Neox card with the USB cable. Turn off your Xbox and plug in the eXen card in to the front of the Xbox with the USB. Turn on the Xbox by pressing and holding the red button on the eXen card. Once the Xbox turns on, immediately press the white button next to the red button. When the blank screen comes up, press the button 3 times and ...
In this tutorial, we learn how to use a forehand ground stroke while playing tennis with Carl Hart. Take your racket and turn on your right foot. Drop the ball out in front of you and make contact following through in your shoulders. You should be able to see your elbow and see the back of your hand facing toward your cheek. You should be doing "step, drop, then follow through". To correctly place your hand on the racket, place your open hand on the racket and slide it down to hold it on the ...
In this video tutorial, viewers learn how to curve a bowling ball. When holding the ball, users will only be using 2 fingers: the middle and index finger. Place the middle finger in the left hole and index finger in the right hole. Make sure that the bowling ball is not too heavy. Do not use your thumb to hold the third hole. When you let go of the ball, spin the ball really hard with just one finger. This video will benefit those viewers who enjoy bowling, and would like to learn how to curv...
In this video, Dina Prioste shows us how to your booty with a yoga wall-sit chair pose. Start off by sitting flat against the wall with your feet hip width apart. Hold this position for a few breaths. You shouldn't be sitting on an actual chair, just an invisible one. Now, grab a book and place it between your thighs, then squeeze as hard as you can while still breathing and focusing as much as you can. When finished, take a break and get back into the position and do that same move once agai...
In this tutorial, we learn how to sharpen your chainsaw with a hand file. First, take the cover off of the chainsaw and jam something into place so the chain stays in place. Put gloves on before you touch the chain, and use a hand file to file down on the chain. Look for the shortest tooth and put the file in, holding it well and giving it two or three strokes. When filing, be consistent on each different tooth you are sharpening. You will be able to feel the blade being taken off. You might ...
In this video tutorial, viewers learn how to do the drop coin vanish magic trick. The magician begin by holding onto a coin and shows the audience that the other hands is empty. Then the magician takes the coin with the other hand and starts to rub it. When he opens his hand, the coin has been vanished. To do this trick, hold onto the coin in between your thumb, index and middle fingers. The coin should be down about half way. They key is to create an illusion that you're taking the coin, whe...
In this video, Ozzie Jacobs shows how to activate your upper back muscles in order to tone them effectively when at the gym. As Ozzie explains, this is often more difficult to achieve due to the tendency of your shoulders to slump forward due to the effect of gravity. In order to properly activate your upper back muscles at a machine like a rowing machine, Ozzie advises her viewers to make sure that their back muscles are tightened, focusing and consciously trying to pull your shoulder blades...
To perform the pigeon pose in yoga safely, you will need the following: a mat, a small pillow or folded blanket, and a strap.
You've serenaded her with Harry Connick Jr.'s "Love" while holding a red rose in your mouth, opened more doors than beer cans when you were in a college frat, and told her of your undying devotion to her, only to have her text you that "she's not ready to commit right now."
In this fitness video tutorial you will learn how to do the "shoulder stretch" on the yoga trapeze. Sit on the strap and lower back slowly while holding on to the straps. While doing this, wrap your feet around the straps and bring them together. Then get hold of the longest of the straps, rotate around, get your hands side by side so that the handles are in a straight line. Keep your head straight down and hang in this upside down position for about 50 seconds. Then try out a little variatio...
In this tutorial, Karina Hayes-Blakely tells us how to get your body ready for singing. It's important to be relaxed, since singing is something that allows sound to come out. First, drop your shoulders and elongate your neck. You will want it to feel like there is a cord on your head that is holding you up straight. Think about where you feel shy singing, and work with the part you are shy about. If it's your face, massage your jaw until you feel relaxed and comfortable. Also, deep breathe a...
In this tutorial, Kandee shows us how to tease hair and get a lot of volume. First, take a small section of hair and use a round bristle brush to brush the underneath of your hair inwards. After doing this, make sure to use hair spray and style your hair as you like. You can use this technique on both the underneath and top sections of your hair, as well as on the back. When you tease the back of your hair, just pull it straight up and comb against the hair while you're holding it up. When yo...
In this tutorial, we learn how to do a back pain prevention workout. The first exercise you can do is a low back stretch with pull. First, sit down with your legs parallel to each other. Then, round back and bring your head below your needs and clasp your hands together under the knees. Hold this pose for 20-30 seconds and then pull chest up and away from knees, holding again for another 30 seconds. The next exercise you can do is a twisted hip stretch. For this, lie down on your back with yo...
In this video tutorial, viewers learn how to draw anime women with weapons. Users will needed paper and a pencil. Begin by sketching the basic form, how you want the character to stand. Then draw the weapons that the character will be holding. Now add in the facial features and detailed hair. Add some extra details, such as some accessories. Then give the character a uniform to wear. Finish by adding all the details to the entire character. This video will benefit those viewers who enjoy draw...
From Fat Loss Lifestyle, learn how to get great abs through a core exercise. To begin, lie on your back with your knees bent at a 90, feet flat on the floor and the small of your back pushed flat into the floor. Take in a
Ninjas has captured the imagination of both East and West with a combination of flair, combat effectiveness, and secrecy unlike any other type of warrior in the world. In this three-part video you will learn how to draw a rather muscular example of the group, holding a massive sword and adorned with shruiken, in pencil.
The first step is to select a photo of a black, glossy car. Using the Lasso- polygonal tool, select the outline of the car. Once the image outline is complete, the dots animate around the image. The next step is to deselect the areas on the car where the chrome paint is not required. To do this, follow the same procedure as above holding the ‘Alt’ key (a minus sign appears next to the cursor). Once the selections are done, go to ‘Image’ menu, select ‘Adjustments’ and click on ‘B...
In this how to video, you will learn how to dismantle an Xbox 360 vision camera. First, take off the sticker on the bottom with a knife. Next, unscrew the the screws on the bottom. You should note that the sticker is really easy to place back on. There will be two screws revealed once the sticker is off. Unscrew these to access the inside of the camera. The bottom plate will come right off now. There are two more screws holding the inside of the camera. Unscrew these to entirely dismantle the...
The video describes to make wire hoop earrings. Take a steel metal of anything and take a eighteen gauge wire and wrap a few length of it around the taken piece of metal which is cylindrical in shape. Cut the wire at the desired part and remove from metal.The wire takes the shape of a standard spring. Again cut it into two or three pieces. Hold the wire again and straighten the edge and after that once again bend it down holding at the place where bent begins. Put some on it to design and the...
Moshezuchter demonstrates how to do a legato bass technique on an accordion which will add drama to your playing. Legato means tying it together. When playing staccato, you touch the keys like they are hot with short strokes to get the punctuated effect. Try playing an alternate base pattern using A, A minor, E to A minor for an oompah sound. Hold your finger on the A while pumping the A minor key. Then, hit the E major key while continuing to hole the A key down. You can also transition to o...
This video demonstrates us the method to throw a boomerang. Firstly, hold the boomerang properly. It should be done by holding it in your hand from one of its arms. Hold it vertically at an angle to the ground. The hand, while releasing it, must be slight above your head. See the wind by dropping the grass. It can also be felt on one side of the face. Throw the boomerang at forty five degree angle into the wind. Safety of the people around must be taken care of as they might get hurt with the...
If that old chair is covered in holes or stains, or boasts a pattern that can best be described as "70s chic" it may be time to update it a bit. In this video learn how to save your favorite comfy chair and recover or reupholster it like a pro. By recovering your furniture yourself you can avoid the cost of buying a new one or paying a professional, with the added bonus of holding on to a long-loved piece of decor.
This video teaches you how to replace a LCD screen for the 5th generation iPod. The tools you will need are a soft cloth, a mini screwdriver, a plastic or metal putty knife, and of course your iPod. First, pry your iPod open with your putty knife. Place the knife in between the metal base and white case and pull the knife around the iPod, to undo the clips holding the case together. Once open, lift up the hardware, remove the headphone assembly, and take out the screws on the side. Take the e...
This video is a tutorial on how to set a table in a restaurant. The table should first be wiped thoroughly with a product called Thieves, a mixture of organic oils that contains no chemicals. Be sure it is dry before people are seated.
In this how-to video, you will learn how to single out a color in an image with Photoshop. First, go to select and click Color Range. Select all the color of the image by clicking around the object while holding shift. Once it is selected, click okay. Your selection will be made. Go to the magic wand tool. Hold shift and select the color areas that you have missed. Now, go to select and press inverse. This will select everything but the object. Go to image and adjustments. Now, drag the satur...
This how to video will show you how to jail break the iPod Touch or iPhone to the 3.0 firmware with Redsn0w. First, download Redsn0w and the firmware. Open the file and double click the program. Click browse and navigate to the firmware. Open it and let it load. Once this is done, press next. Let the data load and then make sure Cydia is clicked. Click next and then turn off your device and plug it in. Click next and then hold the power button for 3 seconds. Without releasing the button, hold...
This video demonstrates the new technique of threading, an alternative to waxing, shaving or electrolysis. Threading uses two threads to pluck unwanted hairs in a fast and painless manner. First the technician will follow the natural arch of your eyebrow removing any stray hairs above the arch. Holding your eyelid slightly taught will allow the technician to remove any unwanted overgrowth underneath your arch, as well as between the eyebrows. Threading is also used to remove unsightly hairs f...
Meggan and Ettore Ravazzolo from kissthecook.com shows us how to dice an onion using the proper technique.
This video illustrate us how to draw a female assassin. Here are the following steps: Step 1: First of all take a sheet of paper and pencil.
