In this video, we learn how to use a text box in Excel 2007. To do this, you will go to the insert tab and then go to the text box and select text box. Now, draw yourself a text box then highlight and copy the text you want, then paste it in. now you will have a paragraph of text written on top of your cells. You don't have to copy and paste, you can type it in as well. If you want to format the text, right click in the box and then change the preferences you want to change to format the text...
If you're a beginner when it comes to cycling or just enjoy taking a nice bike ride, something that should not be ignored is stretching. Stretching is a smart and safe thing to do before do anything athletic. It prevents the chances that you will suffer from any type of injury.
In this video, we learn how to create a free Weebly website. First, type a title in that you want for your website. After this, you will be brought to a new page where you can change the elements and designs. The design can easily be changed until you find one that works for you. After this, you can start to customize the template that you have chose and add in new paragraphs, columns, pictures, and more. Next, you can change the pages and add in links and more information. Adjust the setting...
In this tutorial, we learn how to measure your petticoat size for a sari. First, measure around the waist with a measuring tape. This will be a simple measurement of your natural waistline. Next, you will need to measure the length of the petticoat. Measure from the waist down to the ankle. After this, measure out the hip area. The hip is roughly 9" lower than your waist is. After this, you will have all the measurements you need to make the petticoat the right size for your sari. Use your fa...
In this tutorial, we learn how to create and edit tasks in MS Project 2007. Before you begin, you need to set the start date by going into project information and changing the start date and end date. After this, type in your first task name, then enter in the information that goes with it. After you have entered this, press the check mark to set it up. After this, enter in the other task names that you need to specify in your project. When you are finished, you will need to save this onto yo...
In this tutorial, we learn how to make a fabric gift bag for any occasion. First, you will need to grab any type of fabric with any design that you want the bag to be in. Next, you will fold in the edges of the fabric so it has a hemmed look, then sew them down. After you do this, sew the two sides of the bag together, then sew the bottom. Next, grab a piece of ribbon that you don't want and wrap it around the bag. Top it off with a felt flower and sew a button into the middle of it. Glue thi...
In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...
Yes, we know, most manga girls look innocent anyways (though the same isn't always true for their personalities), but this manga girl is truly adorable and friendly-looking. Of course, the big, bright childish eyes and pursed lips probably help with that.
Chances are, if you have some elder relatives who have paid you a visit during the holidays, then you probably have more than your fair share of cable-knit sweaters in various ugly Christmas designs. While we're certainly not a fan of these types of sweaters, the cable-knit technique is one that is used very commonly in knitting and is one of the most basic.
Wire jewelry is one of the most beautiful types out there. With a delicate appearance and ability to bend into gorgeous curvalinear patterns or wrap endlessly around necklace pendants, wire jewelry is also easy to maneuver for beginners.
In a sense, cardio intervals are God's gift to lazy exercisers everywhere. Why? Well, rather than commiting yourself to an excrutiatingly long exercise routine every day, you can actually cut down the time you exercise in half if you add cardio intervals.
In this tutorial, we learn how to create links between tasks in MS Project 2007. First, select the task you want to link, then click on the link task button on the toolbar. You will now see a finished task link between these tasks. In the entry table, you will see the predecessor, which is task two. You can also type the numbers in the predecessor column and enter the information in. You may want to create a link that is different, so you don't confuse two things that will start at the same t...
Shelley Lovett teaches us how to make a thumbprint butterfly clay pot in this tutorial. First, start off with a medium sized clay pot and several different colored paints. To make the butterflies, have your kids dip their thumbprint into paint and make a butterfly. Make two thumbprints on each side of the butterfly body. Use a paintbrush to paint in the body and head of the butterfly. When finished, use a sealer to secure the paint on the pot, then let dry completely. You can now use these po...
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
In this tutorial, we learn how to design a fall centerpiece in a watering can for a home. Start off by cutting branches off of a willow and placing it into a watering can. Next, arrange Japanese lanterns around. After this, cut alstromeria and seeded eucalyptus and place them around the can where you feel they fit best. The best part of this arrangement is that you can arrange it however you want! You can add different types of fall flowers and add more or less of flowers you prefer. When fin...
In this tutorial, Shawn Powers shows us hot to update ISOs with Zsync. First, download and install this, then type in "i" and enter in the c file. Then, enter the http address where the zsync file lives, and press enter. After this, it will download the file and compare it to your 'c' file. You can also use a desktop CD as a seed and use the change for an alternate CD if you prefer. When finished, exit out of the program and you will be done. This will save you bandwidth and only take a few s...
In this tutorial, we learn how to set up work resources in MS Project 2007. First, go into your chart and click on the resource sheet from the file menu. Now, you will be able to change the different sections that show up on this sheet. Go through the different columns to change the information and type in additional information, the more you insert the better. When you click on the tabs, you will have more options where you can enter in notes and make custom fields. Go through the entire she...
In this tutorial, we learn how to crochet a left hand radiant flower. First, make a slipknot, then chain four. After this, join the beginning chain and then chain three. Slip stitch through the center of the chain, then chain three and slip stitch again. Do this over again five times on your row. After this, continue making stitches until you have the shape of a flower. Add on green yarn to the back of the flower, by doing the same type of stitch. Work as many stitches as you would like. The ...
In this video, we learn how to crochet a left handed dainty angel. Use a size H 5mm crochet hook. Add a slipknot to the crochet hook, then chain three, join, and chain one. After this, work 6 single crochet through the center of the chain three. Next, join two single crochet for each stitch around for a total of 12.Now do 12 more single crochets and work an additional round with the single crochet. Continue this process until you finish, then create the dress by doing the same type of crochet...
In this tutorial, we learn how to use Linux: Commandline Dependencies with gdebi. First, download a Deb file then use dpackage to install the package on the command line. If this fails, you will be able to use gdebi to install all the dependencies in command mode. This will save you time from trying to figure out how to open your file any other way. When you are finished, you will be able to open you file and enjoy what's inside. If you aren't familiar with how this works, search the internet...
In this tutorial, we learn how to prevent edits or changed in documents in MS Word 2007. Start by going to the review tab, then click on protect documents. Then, click restrict formatting and adjust the different settings. Click on the check marks to choose what types of settings you want to restrict from being changed. This can make it impossible for anyone else to edit the pages except for the original author. You can also make an enforcing protection password so only the document creator c...
In this tutorial, we learn how to make a Halloween card using Cricut Paper Doll. First, cut a skeleton out of the PaperDoll Dressup package, then cut it out two more times. Glue these together to make the skeleton thicker, so it pops out of the page. You can place this next to a paper sentiment that says "bone to be wild", with a black card stock underneath it. You can use die cuts with a view papers to make it look more interesting. Use any other type of decorations you like to decorate your...
In this tutorial, we learn how to create "viva la diva" lip art. First, prime your lips and blend it out with clean fingers. Next, take your favorite type of lipstick and then use lip liner on the edges. Blot the lipstick on the back of your hand, then apply the lipstick again. Next, grab rhinestones and apply them on your lips using a q-tip and Duo glue. When you are done with this, apply a clear lip gloss to the top of your lips. This will give you a glam look with beautiful rhinestones on ...
In this tutorial, we learn how to give personality to your puppets with Paul Louis. Personality is everything when it comes to puppets. Your design should give the puppet a certain type of personality. Create a voice when you put the puppet onto your arm and use it to become a new character. Use different styles of clothing and jewelry accessories to make the character different. Give the puppet the look of the voice you are going to give it. If you want it to look tough, give it a leather ja...
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
This video tutorial is in the Computers & Programming category where you will learn how to save multiple locations in Yelp. Yelp is great for finding businesses in your neighborhood. You can also search for something in other cities. You can enter the location in the 'near' box to search for something somewhere else. You can also save locations to easily search later. Click on 'account' and then on 'manage saved locations'. Here you click on 'add new location', type in the location name and t...
In order to make a mini cappuccino machine for a dollhouse, you will need the following: a copper fitting (from the hardware store), glue, pliers, and old jewelry.
In this tutorial, we learn how to delete your Gmail account. First, log onto your Gmail account and click on "settings". Now, click on "accounts", then go to "Google account settings". Once you click this, you will be directed a new page with your information. Under "my products" you will see an option to click "edit". After you click on this, click on "remove Gmail permanently" under the "delete a product" heading. You will now have a deletion warning, if you are sure about deleting, check t...
In this tutorial, we learn how to make tequila cake with edible puke. This is a great cake to make for a college graduation. You will make the bottle by using Rice Krispies that are shaped into the bottle. Place fondant over the bottle and color it into the right colors. Place a cake underneath the bottle of tequila, and then make the puke by coloring different types of icing. You can place pistachios inside the icing to make it look more like puke as well. Squeeze this icing onto the tequila...
One of the few technical advantage the Nintendo Wii has against its high-tech rival the XBox 360 is that it allows users to browse the web on their console. Trying to do so using only a Wiimote, however, is impractical. Did you know that you could use a USB keyboard instead? This video will show you how to connect a USB keyboard to your Wii, making it MUCH easier and more practical to use the Opera web browser available in the Wii Store. Now can surf the web on a giant screen while reclined o...
Expand your crocheting repertoire by learning how to crochet a crinkle stitch, which does indeed replicate fabric crinkles. With very hole-y yet tightly woven vertical lines of yarn intersection with horizontal ones, this type of stitch creates excellent warm fabric for scarves and cold weather gear.
Margie McCoy teaches us how to make flower corsages in this tutorial. Start by using three of your favorite flowers and take a wire and place it on the top of the flower until it reaches half way through. Then, take your floral take and tire it as tight as possible around the top of the stem until you reach the bottom, stretching as you go. Next, combine all the flowers together, and tie them together until you have the type of arrangement you want for the corsage. Now, add this on a ribbon s...
Mark Wallace shows us how to use a wide lens for portrait photography. A longer lens minimizes distortion in your picture and it maximizes what type of view you can see, so you can see more of the thing you are taking a picture of and less of the background. These lenses help keep the picture clean and uncluttered. You can see the difference between a wide and short angle lens by taking pictures with them and looking at the differences between them. There is also a zoom available, which makes...
This video tutorial is in the Home & Garden category which will show you how to use a multimeter to check for continuity, measure resistance and voltage and many more values. Multimeters are like the electrical engineer's Swiss army knife. Multimeters can be of digital or analog types. Before using the multimeter, make sure there is continuity between the two probes. When you connect the two probes with each other, it will beep indicating that there is continuity and then you can go ahead. To...
In this Autos, Motorcycles & Planes video tutorial you will learn how to apply fiberglass filler to a welded area. Fiberglass or aluminum filler should always be added to an area that is welded. This will ensure proper sealing and prevent moisture ingress. There are two types of fiberglass fillers; long haired and short haired. Long haired is stronger than short haired filler. First you got to mix the filler and hardener together as per directions on the containers. Wear rubber gloves and a p...
Learn how to calculate BPM for different types of DNB. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions,
You've probably seen old t-shirts being turned into dresses, miniskirts, and if you're a fan of Gianny L, even two-piece bikinis, but you've probably never even thought about it transforming them into underwear. It may seem a bit odd at first, but making these intimate pieces from t-shirts means you can customize the pattern as well as the type of cut (cheeky, granny top, or thong?).
The tutorial shows how to use trigger grouping in QuicKeys, which essentially means instead of assigning a single trigger to activate shortcuts, you can use a group of keys as a trigger. In this example, you'll see how to set up a macro to launch Calculator by simply typing the letters “cal” (short for Calculator) in the Finder. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be wel...
Forget dogs - tripods are a man's best friend (well, if he's a photographer). Eliminating many of the factors that create crappy photos, including the instability of holding the camera up by hand, photo blurs, and general strain of weilding those hulking digital SLRs, tripods are always there to lend a helping leg. Or three.
Achieve alluring and sexy waves rather than Shirley Temple-esque tight finger curls by watching this hairstyle tutorial on how to do a deconstructive waving technique. Girls with longer hair should opt for a smaller barrel curling iron, since a larger barrel will not create the same type of wave that we are trying to achieve.
