Jan 25, 2007 (Th)
We covered the following topics. See the Excel Formulas powerpoint presentation on yrosenthal.com for more info.
- Overview of Excel data types
- numeric
- text
- date-time
- logical (AKA boolean)
- Each type has specific types of
- literal values (i.e. actual values - not cell references)
- operators
- functions
- Overview of function editor (i.e. fx button)
- Min, Max functions
- Left, Right functions
- & - concatenation operator