Visual BasicTips

Database Functions Index, Match, etc. When working large amount of data in a tabular format (such as when postprocessing software output) it is often convenient to use Index, Match and other Excel "database functions" to retrieve desired values. Refer to Excel help for more information about these functions.
Goal Seek Need to quickly solve equation with one unknown? Use Tools > Goal Seek function.
Macros Macros can be used as a great starting point for learning Visual Basic. Record several macros, study their Visual Basic code (Tools > Macro > Macros > Edit) and soon you will be able to write your own functions in Visual Basic!