1. Computing
If you store large amount in spreadsheets, Excel’s VLOOKUP is a handy function to know. It allows you to easily locate specific data in a database or list.

For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.

For details on how to setup and use the VLOOKUP function in your spreadsheets, follow the Excel 2007 VLOOKUP Step by Step Tutorial.

Related Articles
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.