Looking for values and formulas in Excel

July 25th, 2010 by admin

Dealing with numbers, formulas and equations is a difficult task especially when we are trying to create something just by ourselves.  Personally, I lways measured in inches and weight in pounds.  So when putting those entries in paper with those standards that need equivalents in the metric system, it is time consuming to use a conversion table and calculator.  Putting them excel makes it a lot easier.  You must know though how to vlookup in excel.  It helps very much on how to do it to avoid mistakes in the process.  In the case of searching values of inches to the metric system it can show from millimeters, centimeters or meters in equivalent values.

The basic information that we put in excel at the start of the process will make the system make a match of constant and consistent entries.  For example products for sale could have codes, item description price and mark-up.  If the information is put in each column side-by-side, excel will be coming up with a formula or a constant.  In this way it helps organize the work that needs doing.  Usually when typing an entry, excel will give or offer options to fill the space.  To know more about this you will need help with vlookup in excel.  It will help more on how to organize the information and have you do more conveniently the work on excel.  At first it will seem difficult to understand but once you see that excel is giving the right options on the entry in a cell, that’s where you start feeling at ease.

Working on excel is quite tedious at the start.  When you get the hang of it, everything just seem to fall in place.

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Posted in Reference and Education | | Comments Off

Comments are closed.

Sorry, the comment form is closed at this time.