Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...
In this video, we learn how to transfer songs from an iPod to your personal computer. First, open up your computer and go into the folder with your iPod. Now, go to tools, folder options, view, and hidden files/folders. Apply this, then the folder with all of your music will show up! You can now unplug your iPod and then select all of the folders on your computer. Right click then and go to properties, then uncheck the hidden. Hit 'apply' and then transfer all the music to your computer. Now ...
One of the coolest features on a Blackberry is BBM or Blackberry Messenger. BBM allows you to talk to anyone with a Blackberry, anywhere in the world, absolutely free! You can send messages back and forth and you phone will even keep a record of the conversation in case you need to reference something later.
Do you need to restore all of your digital music on your computer? Computer crashes are a pain, but if you also had all of your music on your Apple iPod, then there's a chance for you to get it back. And if you also need to get back all of your personal contacts, personal notes and calendar information, believe it or not, it's totally possible.
There are quite a few references in the Old World Blues DLC for Fallout New Vegas, and almost all of them require the Wild Wasteland perk. Take a look at this video to learn where to find these stealthily hidden easter eggs.
When you first buy a corset from a retailer, you will need to give the thread and fabric the chance to shape itself according to your own personal shape. Here is the best way to break in or season a new corset to make it last longer.
These are great, personal gifts that you can hand out to friends this holiday season. Find a picture and a quote you like, then dress them up in a picture frame! All you really need is the frame, some paint, a few old magazines and some paper!
Before you know it, old Saint Nick's reindeer will be tapping on top of your roof and a Salvation Army bell ringer, festooned with a Santa Hat, will be around every corner. That's right, guys and gals, Christmastime is almost at our front door, which means you should get prepared for all the holiday gifting.
The Genoese Zipper Sinnet is actually a fusion of both the single Genoese Bar and the Zipper Sinnet, obvious reasons for the name. This knot can be great for making a strap, bracelet, or necklace. In this video you will learn how to tie the knot up close and personal, giving the video great detail and insight into the knot tying process.
Learn how to create and configure a new email account on a BlackBerry Torch 9800 smartphone running version 6 of the BlackBerry OS. This clip will teach you everything you'll need to know. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.
Grow Valley is an educational but fun flash game where you develop a valley with all the niceties of modern life, from cars to dams.
Want to allow someone to use your computer without giving them free reign of your personal documents? Then you'll want to set up a guest account. This helpful home-computing how-to from the folks at MacMost presents a complete step-by-step overview of the process. For the details, and to get started creating and using guest accounts on your own OS X computer, watch this video guide.
It's been proven that your body adjusts to any new workout you start doing within a week. Though that means less muscle aches and pain for you, it also means less results.
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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...
Want to protect your investment and add some personal style to your cell phone, but aren't quite sure how to install that cool new skin? We've got you covered - just check out this quick video on how to install and remove an iPhone case. If only getting ready for work could be so easy!
Watch this science video tutorial from Nurd Rage on how to find chemicals for science experiments with Dr. Lithium.
Data thieves don't have to be programming wizards to get their hands on your personal information. They often find hard drives that contain financial and other sensitive data at flea markets, charity shops, the city dump—even on eBay. In this video tutorial, PC World explains how to completely erase sensitive data from old drives before recycling or discarding them. Wipe your old hard drives with this how-to.
Watch this instructional violin video to learn how to play the "Lost Woods" song from the Zelda: Ocarina of Time video game on the violin. This tutorial video is great for violinist enthusiasts who love the video game. Find the sheet music for this song in the Downloads section of this user's personal website.
In order to connect two personal computers to each other, you will need a crossover cable. If you don't have one, that's not a problem. Take a look at this instructional video and learn how to make a crossover cable from and ordinary LAN cable with a small connector block, a knife, tape, and a lighter.
Add personal touches to you projects by creating crochet flowers. This how to video is a crocheting tutorial that will show you how to create a marigold flower. Crochet several of them, and use them to decorate your scarves, bags, or sweaters.
Add even more personal touches to your crocheted items. This how to video is a tutorial on how to make pom pom balls out of yarn. These pom pom balls are super easy to make and are a great way to decorate scarves and hats.
This is a tutorial on how to free up more space on your hard drive. Some of the issues that take up space include system restore, disk cleanup, wallpapers and personal information.
Lost in the wilderness? Did you forget your emergency personal beacon (EPERB)? Learn from the BBC how to start a signal fire using your car battery and a piece of wire wool. Let's just hope you have a car . . .
Over 2 million people are anxiously awaiting the arrival of their new iPhone 5, which has caused a few shipping problems, to say the least. There has been a considerable amount of confusion about when, exactly, the iPhone is going to ship, depending on where it was bought and how it's being delivered.
In this tutorial, we learn how to draw curvy steps using pens. To start, you will first draw a horizontal line with a point in it. From here, you will need to draw lines coming out of the point. These lines will act as your reference point for the different items in the drawing. Next, draw the steps using the reference points. The one at the bottom should be larger, getting smaller as you work your way up. Draw these using the triangle shape in sort of a wedge. Shade in the bottom area to cre...
In this video, we learn how to draw Ino from Naruto. Start off by drawing a circle for the head, then drawing lines in the middle to create reference for where the facial features will go. After this, draw in the hair on the top of the head along with the eyes, eyebrows, and creases of the eye. Then, draw the jaw line around the face and erase the lines you used for reference. After this, add in additional lines and hair to make it look more realistic. Use shading around the face to show ligh...
In this video we learn how to draw hands without references. First, draw the basic structure of the hand using a photo to make sure it's true to size. After this, draw on boxes and circles to create the wrist, hand, and the knuckles. Then, you will draw on straight lines for the bones in the thumb. After this, start to add details of the fingers and make out their basic shape. As you continue with details, erase any background lines and start to add lines in for wrinkles on the skin. Finish t...
In this tutorial, we learn how to draw Ino Yamanaka. Start off by drawing the head, drawing lines in the center to use as reference points. After this, draw the rest of the body, including the hands, torso, and neck. Now start to draw in all of the details. Draw the eyes evenly apart, then add in frown lines, a mouth, eyebrows, and any other details of the face to make it complete. Next, start to erase the reference lines and draw in the hair of the character. Draw around your basic outline t...
In this tutorial, we learn how to draw Stitchpunk. Start out by drawing the outline of the entire body. After you do this, draw in the details of the feet and the hand. Next, start to draw in further details of the hands so you can clearly see the claws and the hand area. Once finished with this, draw in the details of the face. After you do this, you can erase any reference lines that you drew and fill in further details. Draw in any other details needed throughout the character, then erase ...
In order to create a bibliography with Microsoft Word 2007, you will need to access the reference tool bar, at the top of your screen. Click on references. Open your document. Put your cursor where you want to make the entry. Then, click on Manage sources. Fill in the pop-up that comes up. This will ask you for all of the information needed for the type of citation you are using. Click OK.
See how to insert a hyperlinked reference to a Wikipedia article in your blog post or page with this free video blogger's guide. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
This video tutorial will show you how to add citations and bibliographies in MS Word 2007. 1. Select desired text.
Matching a photo allows you to import and align the SketchUp axes to match the photo perspective you want to use as a modeling reference. With this done, you can create models using the photo as a direct reference. PART ONE covers the basics of importing and aligning the axis to start modeling in Google SketchUp.
There are some very powerful tools in CINEMA 4D that you can use very quickly to create some 3D graphic elements. Once you start practicing you'll find it may be easier to create your own reference than to find the "just right" one on the web. So, if you're in need of some barbed wire, for reference or otherwise, check this tutorial out. Of course, it takes quite a bit longer to actually SHOW you how to create the barbed wire (creating the barb, wrapping it around the wire, using MOGRAPH in o...
Sometimes, you just have to wear a tie. But you don't have to sacrifice your personal style. This video will show you how to make a clip-on tie out of duct tape that you can customize however you like. No one will mistake you for a square in this duct tape clip-on tie.
Depending on your personal technique, you might find that you are a tight crocheter, or that you often end up with looser projects. This tutorial shows you the difference between using a tight or loose technique. Here is how you can determine the gauge of your projects, as well.
Tell your friend you hope you feels better in the sweetest and cutest way possible by crafting this bandaid greeting card. A paper bandaid, embellished with a sparkly red heart, says it all.
