Excel Training by Mission Critical Systems

Microsoft Excel 2007 Advanced 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.