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 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 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 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 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...
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...
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?).
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.
In this tutorial, Science Bob shows us how to do a science experiment with dry ice. First, take a block of dry ice and place a quarter on top of it. Make sure you are using rubber gloves when you do this, it's dangerous to touch gloves with your bare hands. When you press the quarter down, it will cause it to vibrate very quickly. You can put any type of metal on top of the dry ice and it will make different noises. This is only one of the many things you can do with dry ice. You can also use...
In this tutorial, we learn how to apply full coverage evening foundation. First, you will want to apply a cream that has Silica in it, which will fill in any fine lines. Next, you will want to apply a powder foundation, something like Mac StudioFix Full Coverage Foundation. Make sure you use a brush on your skin to apply evenly. Next, if have you have light skin, you can apply your favorite type of powder bronzer on your cheeks with a kabuki brush. Now, apply concealer underneath your eyes on...
Why would you blow upwards of $200 or $300 on a bikini when you can craft a perfect good one yourself? Don't believe us? Then watch this video by fashion DIY expert Gianny L to prove yourself wrong.
The 3-inch wacky rigged senko is a good type of bait, but like most it has a specialized technique that you need to use to get the most out of it. This video features a former bass guide explaining how to properly use one of these lures to catch big bass. Get out to the lake and catch some big ones! But, as our host says, throw back the big ones so that they can breed and keep our lakes and rivers populated.
David Beckham is known around the world for his incredible curved shot in soccer. In this tutorial, learn exactly what you need to do with your body to inspire the same curve from your free kick.
The cool thing about Just Cause 2, is not only do you play a shoot first, ask questions later type of character, but the game is stocked with a lot of hidden secrets. Or as they are referred to, easter eggs. This video tutorial is presented by the guys at Achievement Hunter and they show you how to find the "Baby" Panay Moustache easter egg. It's easy to find and involves some interesting art. Enjoy!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
Just because you are following a healthy raw diet, doesn't mean you are exempt from weight gain. A lot of times when people first transition to a raw lifestyle, they overeat because they are not used to the different types of food. While this is better than say, binging on unhealthy snacks, it is still not good to bombard your system with too much.
In order to de-hull leafy bean sprouts, you will need a salad spinner. The type of salad spinner you use will make a big difference. Separate the sprouts. Work your way through the sprouts. Separate them as much as you can.
In this video tutorial, viewers learn how to measure the long-board clearance to determine the correct trucks to use. Users will need a measuring tape. The board clearance is a term used to describe the width of the deck, over top of the trucks. There will be 4 holes that make up the bracket. Users will be measuring the distance in between those holes. Measure both the front and tail of the board. The 3 types of trucks to decide from are: S6 truck, S8 truck and S10 truck. This video will bene...
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...