Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
In this tutorial, we learn how to style hair on an American Girl w/ long wavy hair. First, brush the hair out and then grab the top left section of the hair. Split this into three and then twist these together. This will be like a French braid, but you will be twisting it as you braid. Continue this until you reach the bottom of the head, then tie it with a rubber band. After this, do the same thing on the other side of the head. Then, tie it with a rubber band in the back and you're done!
In this video, we learn how to do a double twist flip on your American Girl doll. First, part the hair down the middle and then brush it out. From here, pull out the rubber band one side and then split the middle of the hair in half. Push the rubber band with the hair through this, then tighten it up. Do this on the other side of the hair to make them both even. This will finish the hairstyle on your doll! The great thing is that you can do this on dolls that have short hair or long hair and ...
In this video, we learn how to do a basic French braid on your American Girl doll. First, comb the hair back on the doll and then take the top section and split it into three. From here, you will start like a regular braid, going over three times. After this, you will take a little bit of the hair from one side and pick it up. Add this to the section that is closest and pull it over the middle piece. Continue to do this on the opposite side and then go back and forth. As you go down, you will...
In this video, we learn how to do a French braid wrap around on your American Girl. First, brush the hair out and then grab the section on the right side of the hair. Split this into three sections and then start to braid down four times. After this, you will start to French braid the hair, adding more hair in as you go down. Incorporate the middle strands in and go to the other side as you continue to braid. Pretty soon, you will incorporate all the hair into the braid. Finish this off by ty...
In this video we learn how to do a ponytail veil on your American Girl doll. To start, you will take the top front section of the hair, then brush it back. After this, you will tie it in a rubber band and then repeat these steps on both sides of the head. Then, you will take the hair that's in the ponytail of each one and split it into two. From here, you will tie these with another piece from another side and then tie together with a rubber band. do this once more on the very back and then t...
In this video, we learn how to do a single French braid on your American Girl Doll. First, brush the doll's hair back and make sure it's smooth with no bumps. After this, grab a small section of hair at the top middle of the head. Split this into three pieces and then start braiding like normal. From here, grab some hair from one side of the head and braid the hair sections over each other. Then, grab hair from the opposite side and braid the sections over each other. Continue to do this, alt...
In this tutorial, we learn how to do floating braids on your American Girl doll. First, take a small section from the top right side of the head. After this, brush it out and split it into three parts. Then, braid over three times and take a piece from the top and instead of adding it in, put it in the front over her arm. After that, braid over and take a section from underneath. Add this into the braid and then go over. Now, repeat the same process by putting the section of hair to the front...
In this video, Sarah teaches us how to do a spider web hairstyle on your American Girl. You can do this with any doll, even if they have short hair. To start, you will pull the hair from the front of the head back and then clip it in the middle. Next, take the sides of the hair and do the same process. Repeat this on the other side of the hair, doing the same process. Next, you will split the hair in half from each clip and then meet it up with the half of another piece. Continue to do this a...
In this video, we learn how to do a reverse French braid on your American Girl doll. First, part the hair in half and put one half to the side. Then, take a piece of the front on one section and split it into three. From here, you will go under the hair instead of over like a regular braid. Then, start to pick up pieces from the sides on the left and right. Put it underneath the whole braid and then go under with it to the other side. Continue to do this until you reach all the way down the h...
In this tutorial, we learn how to do twist braid pigtails on your American Girl doll. Start by brushing the hair out and combing it in the middle. Then, take a small section in the font and split that in half. Start twisting it towards her face and then twist them together away from her face twice. Then, pick up a piece from the bottom and twist it into the braid. Continue to add in hair from the bottom until you have all the hair inside the twist braid. When finished, tie off at the end and ...
In this tutorial, we learn how to redo American Girl doll, Mia's, braid. First, you will need to brush out the hair for the doll. After you do this, you will take a little section of the hair from the front and split it into three. Then, take another little section from underneath this and clip it away. From here, you will start to braid the hair, clipping off the sections underneath separately so they don't get mixed together. Then, you will take the rest of the hair and put it into a ponyta...
In this tutorial, we learn how to do a Y braid on your American Girl doll. First, brush your doll's hair out and then put the hair in pig tails. From here, you will split the tail in half on both sides. Then, you will combine the two middle pieces and start to braid the hair like normal. Do this all the way down until you reach the bottom of the hair. When finished, tie the end with a rubber band to keep in place. This will finish the Y braid look for your American Girl doll, enjoy! Decorate ...
In this tutorial, we learn how to use MIDI in Record. First, automatically find your controller keyboard and set it up in your software. With this set up, create an ID8 instrument by clicking on the icon. Settle for a grand piano and record something to test it out. All clips are recorded and save mini notes, data, automation, and more. Clips can be moved, resized, duplicated, split, and joined through Record. These make up the arrangement and make the music. You can automate anything you wan...
As little girls, we always read stories about beautiful princesses with neverending long hair, some with hair so long they could turn it into a rope to aid their prince to rescue them.
In this tutorial, we learn how to play the Native American kiowa flute. This is a very easy flute to play and has a very melodic sound to it. It is a double chambered flute and has soft and sensitive tones. There are knots that separate the chambers of the flute from each other. You will place your fingers on top of the different holes as you are blowing into the flute to make different sounds come out. When the air splits, you will hear different sounds coming out and can learn the notes tha...
Bananas + cake and whipped topping = Foodie heaven. We don't know why we've always loved the combination of bananas and cake/ice cream/whipped anything (maybe it stems from having thousands of banana splits as a kid?), but we do know it's delicious!
Do the Hamman count card trick
In this video tutorial, viewers learn how to use the MP4 video converter software, ImTOO. Begin by downloading the program from the link provided in the video. Once downloaded and installed, open the program. On the right side under Profile Settings, users are able to select name, video size, video quality, audio quality, channel and split of the video file. Then click on the Profile combo box and select an output format for the video. Now click Add Files to import a video into the software. ...
In this tutorial, we learn how to copy any DVD movie with Clone DVD. First, you need to go to this website to purchase the software, RegNow. When you are done with this, download and install the software. Now, open up the software to your computer and place your DVD inside of your computer. Now you have the option of copying the entire disk, or splitting it and creating a customized movie. After this, you can copy the entire movie onto another disc or you can simply rip it onto your computer ...
In this tutorial, we learn how to compress files on a Mac using Simply RAR v1.09. First, go to this website and download this software from http://www.macupdate.com/info.php/id/21430. Now, drag and drop this into your application and open it up. now, make a new folder where you want and name it anything you want. Next, drag and drop your movie into the SimplyRAR software, then choose a compression method. After this, choose the options you want that are on the lower right hand corner. Next, c...
In this tutorial, we learn how to do an elegant french braid. Start off by grabbing the top section of your hair and splitting it up into three sections. After this, start to braid your hair by grabbing hair from each side and gathering it into the braid as you are going down. Once you reach the bottom of the hair, just do a normal braid and then tie it at the bottom. After you do this, you can hair spray your bangs back and tease them, or you can let them hang loose on the front of your face...
In this video, you'll learn how to field dress a deer. Put on gloves. Use Ozark trail hunting knife for dressing the deer. Place deer on its back, head facing away from you. Starting from the anus, split the deer up the middle to the chest. Use left had to prevent cutting or nicking the internal organs. Stretch the cavity open. Loosen organs from cavity wall. Cut out the entrails and all organs. Make an anal incision. Use the butt tool to remove the butt/final portion of intestine. Saw the pe...
In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...
Ian Castle tells us how to sing well in a mixed voice style. This helps smooth out the transition between your voices and split the chest and head voice. This helps anyone who has cracks while they are singing. You will start off by doing vocal exercises that go from low to high on the piano. Remember to go high when the piano does, and low as it goes low. The more you practice these vocal exercises, the stronger your voice will get and the better you will get at changing your voice style. Th...
To start a kinky or Senegalese twist, create a one inch square section of hair and split it into two pieces. Drape a piece of weave over the strands. Twist the right piece of weave over the right strand with a clockwise motion. Twist the left piece of weave over the left strand also using a clockwise motion. Then twist the right strand over the left. Continue twisting each strand to the right before twisting the strands together as you go down the section. The twists can continue down to the ...
In this Home & Garden video tutorial you will learn how to divide hosta. Hostas are one of the best plants for your garden. They grow very fast. Hence, you have to divide them to keep them healthy. The best time to do this is either early spring or during fall. Take a flat shovel and dig a hole about 3-5 inches around the base of the plant and then pull it out. You can use a big knife, your hands or even the shovel to divide the bunch of plants. Move the foliage a bit so that you can see the ...
In this video Megan shows how a curling iron can be used to make small changes to straight hair. She applies Heat Tamer Spray by Tresemme to her hair before starting. She also recommends using a conditioner on your hair if you have split ends.
In this Business & Money video tutorial you will learn how to read a balance sheet in accounting. Yu can learn to read it quickly and easily as to where the company’s came from, where it went and where it is now. There are four main financial statements; balance sheets, income statements, cash flow statements and statements of shareholder equity. In the balance sheet, under assets are listed things that the company owns that have value. Liabilities are amounts of money company owes to other...
In this video, we learn how to get a hairstyle like Zac Efron with Dean Banowetz. To do this, you want to take a guy with a full head of hair brushed forward. First, take a big chunk of hair and twist it. Next, cut the hair upwards while splitting it. This will give your hair a great texture. Zac Efron has his hair brushed to the front of his head, so while blow drying, don't brush the hair back. you will also want to cut a long bang and push it to the side of the head still covering one eye....
In this Magic & Parlor Tricks video tutorial you will learn how to do about face card trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. The presenter displays a deck of cards and counts the 52 cards. He then splits the deck in to two and puts one-half face up and other face down. The deck is now shuffled twice so that some cards are face up and some are face down. He then takes out any card that is face up, which is the jack of clubs and slides it back ...
How to grow sweet potatoes
In this video tutorial, viewers learn how to remove the vocals from a song using the program, Audacity. Begin by opening Audacity and import the song into the program. On the left side of the track, click on the downward arrow and select Split Stereo Track.
This video demonstrates how to prepare a Brown Rice Medley. For this recipe, you will need the following ingredients: green lentils, brown rice, wild rice, and yellow and green split peas. You can find these ingredients in the bulk section, at the grocery store. You will want to combine them in equal parts in a container. Extract 2 cups of the combined mixture. Soak it in water. Let it sit for 6-12 hours. Rinse well. Drain.
In this how-to video, you will learn how to clean your car paint with a clay bar. This will help you clean contaminants, bug parts, and other debris from your paint. First, you will need a car to clean, a clay bar, and a lubricant for the clay. Split the clay into a smaller piece and mold into a bottle. Spray the lubricant on the area you are going to clean. Move from left to right and up and down over the section two or three times with the clay. Once this is done, wipe off the lubricant wit...
In this how-to video, you will learn how to make a simple cost-saving planter for a small kitchen garden. First you will need a plastic milk jug. Cut at the opening of the jug and split it in half vertically. Next, place soil inside the half of the jug. Water this part well, but do not have a standing puddle underneath the jug. Use a chopstick to poke holes into the soil. This will allow you to plant about 35 seeds in the plastic planter. Viewing this video will show you the easiest way to ma...
In this video tutorial, viewers learn how to perform the self-working Soul Mates card trick. The magician begins 12 cards. He/she continues to cut the deck until the spectator tells them to stop. The cards are split into two piles of 6 cards. The spectator takes the top card of the packs and lays it down. Then the magician put the other pack on top of the selected pack and takes out the top and bottom card. When he flips each pair over, they are the same cards with the same color. This video ...
In this video tutorial, viewers learn how to create a light-saber effect using Adobe Premiere Elements. Begin by adding your video into the program. Then go to the effects and select the lightning effect. Configure the effect settings to the settings provided in the video. Now play the video frame by frame until you see the sword in the video. Then go to the start and end points, and drag the points to the sword. Go 1 frame forward each time and click the split button. Then drag the points to...
In this tutorial, Yanik Chauvin teaches us how to create an old-style looking photo starting from a grayish, underexposed one, using the software "Lightroom". He starts by creating a virtual copy of it, and then he adds a Camera Calibration preset named Camera Landscape and increases the exposure. After that, he crops the image removing the blank parts of the photo, and adjusts Contrast, Blacks and Clarity to strength the image borders.
To repair damaged hair. Cut off the dead ends. When shopping, remember that you get what you pay for in hair care products. Use a shampoo and conditioner that says "Strengthening" or "Repair" to rebuild the bonds in your hair. Use a leave-in conditioner that protects your hair from the heat, and protects from sun and wind. To keep it healthy, do not blow dry your hair. It causes too much damage. When you use a heat iron, use a heat protectant. Don't wash your hair every day. If your hair is f...
