1. SSG Skill Level Definition : Excel for Business - Intermediate Skill Level Version 1.0 29th June 2012
2. Manipulating Data
   1. Sorting Data
   2. Extracting relevant data
      1. Filtering data
         1. Auto Filter
         2. Advanced Filter
      2. Look up Functions
3. Analyse Data
   1. Pivot Tables
   2. Sub totals
   3. Consolidate
   4. Slicer
   5. Summing and Counting when defined criteria met
4. Building Flexibility into a spreadsheet
   1. Match Function
   2. Index Function
   3. Tables
5. Documenting and Auditing
   1. Understanding Error Messages
   2. Auditing Features
   3. Comments in Cells and Workbooks
   4. Protection
   5. Using iferror
6. Usefull Tools
   1. Go To Special Function
   2. Paste Special Functions
   3. Time-related Functions
   4. Conditional Formatting
   5. Remove Duplicates
7. Present Data Using Charts
   1. Built in Charts and Modifications
   2. Sparklines in Excel 2010
   3. Incell Charting
   4. Selecting Charts
8. Tools for Efficiency
   1. Working with Tables
   2. Range Names
   3. Creating and Managing Templates
9. Structuring a Workbook
   1. Data Worksheet
   2. Control Worksheet
   3. Report Worksheet