Skills outline

Excel Workspace

Primary Tools Skills
  1. Excel screen
  2. Toolbars
  1. Explore Excel screen
    1. Title bar
    2. Menu bar
    3. Standard toolbar
    4. Formatting toolbar
    5. Ask a question textbox
    6. Formula bar
    7. Worksheet frame
    8. Task pane
    9. Sheet tab
    10. Status bar
  2. Commands
    1. Menus
    2. Toolbars
    3. Shortcut menus
    4. Keyboard shortcuts
  3. Worksheets
    1. Cells
    2. Data entry
    3. Cell pointer
    4. Mouse pointer
Activity Find bottom row and right column.
Use tab, enter and arrow keys.
Use AutoFill.

Formatting

Primary Tools Skills
  1. Formatting toolbar
  2. Format menu
  3. Insert/Rows
  4. Insert/Columns
  5. Edit/Delete
  1. Cells
    1. Number
    2. Alignment
    3. Font
    4. Borders
    5. Patterns
    6. Merge cells
  2. Copy and Move
  3. Rows and columns
    1. Column width
    2. Row height
    3. Insert rows and columns
    4. Delete rows and columns
  4. Worksheets
    1. Background
    2. Gridlines
  5. Conditional formatting
Activity Ten effects project

Formulas

Primary Tools Skills
  1. Formatting toolbar
  2. Format menu
  3. Style list box
  1. Cells
    2. references
    1. single cell
    2. row
    3. column
    4. block
    5. non-contiguous block
    6. 3D
  2. Formulas
  3. Functions
    1. Financial
    2. Date and time
    3. Math and Trig
    4. Statistical
    5. Lookup
    6. Database
    7. Text
    8. Logical
    9. Information
    10. Engineering
  4. Copying formulas
    1. Relative references
    2. Absolute references
  5. Display formulas
  6. Array formulas
Activities Budget, Financial (Amortization, annuities,
sinking funds), Statistical (Univariate, bivariate),
Grade book, Plot math and engineering functions,
use logical and information functions.

Charts

Primary Tools Skills
  1. Chart wizard
  2. Chart menu
  1. Chart type
  2. Chart data
  3. Chart options
  4. Location
  5. Trendlines
Activities Budget (pie chart),
Statistical (bar chart)
Math, Engineering (XY scatter)

Databases

Tools Skills
  1. Data menu
  1. Design data form
  2. Add records
  3. Locate records
  4. Sort records
  5. Filter records
Activities Thesis

More worksheets

Tools Skills
  1. Insert/Worksheet
  2. Worksheet tab
  3. Window menu
  1. Insert and delete worksheets.
  2. Move and rename worksheets.
  3. Edit multiple worksheets simultaneously.
  4. 3D formulas
Activities Budget with quarterly report.

Additional stuff