Excel 2007 Advanced November 4, 2009

Goal – Geared for those that are already comfortable writing different types of formulas, formatting spreadsheets and text and working across multiple worksheets.
Microsoft Excel 2007 Syllabus
Access a list of all Excel functions
Text functions (IF Conditional, Nesting IF statements, Concatenate Functions, IF Concatenate text functions, IS functions)
arrays
label formulas
Add ins
look up values
transposing data
PivotTables
PivotTable charts
multiple series charts
adding pictures to charts
moving average charts
validations
custom views
adding custom views to the toolbar
grouping columns
AutoFilters
custom lists
embedding
linking
linking as icon
locking cells
protecting worksheets and workbooks.

Official Website: http://www.mcstech.net/training/calendar/viewevent.cfm?EventID=428