1. SSG Skill Level Definition : Excel for Business - Basic Skill Level Version 1.1 8th August 2012
  2. Understanding / Managing the working Environment
    1. Understanding the Ribbon
    2. Workbook and Worksheet
    3. Minimizing Ribbon
    4. Context specific Tab
    5. Renaming WorkSheet
  3. Working with Data
    1. Entering Data
    2. Using the fill handle
    3. Formatting
      1. Font
      2. Alignment
        1. Centering a heading over a range of cell
        2. orientation
        3. Text Wrapping
        4. Format Painter
      3. Numbers
    4. Borders
  4. Using in-built Functions
    1. Getting help with Functions
    2. Categories of functions
      1. Mathematical
        1. Sum
        2. Round
      2. Statistical
        1. Average
        2. Min
        3. Max
        4. Count
        5. CountA
        6. Rank
      3. Time and Date
        1. Today
        2. Now
        3. Day
        4. Month
        5. Year
      4. Text
        1. Left
        2. Right
        3. Mid
      5. Logical
        1. IF
        2. AND
        3. OR
      6. Financial
        1. NPV
        2. IRR
        3. PMT
    3. Nested Functions
  5. Creating and Using Formulas
    1. Absolute and Relative Reference
    2. Date formulas
    3. Concatenation of Text
    4. Common errors in entering formulas
    5. Using Operators
  6. Manipulation of Data and Formulas
    1. Copy and Paste
    2. Hiding Rows and Columns
    3. Sorting
    4. Filtering basics
  7. Basics of Charting
    1. Chart types in Excel
    2. Creating a Chart
  8. Tools for Efficiency
    1. Keyboard shortcuts
    2. Freeze Panes
    3. Find and Replace
    4. range name
    5. Copying and moving worksheets
  9. Page Set Up and Printing
    1. Worksheet Margin
    2. Headers and Footers
    3. Title Row and Columns
    4. Print Preview