Description:

*Prerequisite: Must have either previously taken Excel (Basic) Training course or show competency of topics taught in 1.       

Working with LIST (flat database of date in EXCEL)
3.        Format as a Table-new list capabilities in 2007 (review)
5.        Add subtotals to worksheets without writing any formulas
7.        Examine the new filtering options for Dates and Numbers
9.        Protect a workbook by enabling a password and locking cells to prevent unauthorized changes
11.     Format charts with themes and styles
13.     Large Spreadsheet
15.     Freeze panes & print titles (review)
17.     Grouping worksheets for moving, copying or printing
19.     Links to perform calculations on data from multiple worksheets and /or workbooks
21.     Naming ranges for functions
23.     VLOOKUP function
25.     PMT & FV functions