Beyond+the+Basics+-+Excel+2007

**Excel 2007 - Beyond the Basics**
File for Class - Download to Use



__**Objectives:**__ []
 * Freeze panes**
 * Conditional formatting**

__Concatenate__ The **CONCATENATE** function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person's first name in cell A1 and the person's last name in cell B1, you can combine the two values in another cell by using the following formula:
 * Functions**

=CONCATENATE(A1," ",B1)

__ IF __ []

If(condition, value_if_true, value_if_false ) =IF(E2>89,"A",IF(E2>79,"B", IF(E2>69,"C",IF(E2>59,"D","F"))))

[|Excel beyond the basics.doc]

[|Excel Basics and Beyond.doc]

__Single Use Spreadsheets__ [] [|tripcost.xls]