Wednesday, April 14, 2010

Excel Skills

I am working on creating identifying Excel skills at the basic, intermediate, and advanced levels.  Please comment/edit the following:
Basic Spreadsheet Skills
·         Design a simple table
·         Name a worksheet tab
·         Apply a template
·         Insert a new worksheet
·         Create a simple formula (Add, subtract, multiply, divide)
·         Use basic functions (SUM, AVG, MIN, MAX, COUNT)
·         Resize columns and rows to display data
·         Sort cell data
·         Use search and replace
·         Freeze rows and columns
·         Use automatic data entry
·         Use spell-check
·         Use a chart
·         Save a workbook
·         Print a worksheet

Intermediate Spreadsheet Skills
·         Customize the spreadsheet menu
·         Design spreadsheets using data validation features
·         Customize a spreadsheet using conditional formatting features
·         Create/modify a chart
·         Import/export data in text format
·         Link spreadsheet data from other sources
·         Apply principles of effective spreadsheet design
·         Create complex formulas
·         Create/modify a pivot table
·         Create a form
·         Create a report
·         Link and embed tables into word processing documents
·         Use data protection
·         Password protect a workbook
·         Demonstrate competency using two spreadsheet applications
·         Share/collaborate with others on a spreadsheet design

Advanced Spreadsheet Skills
·         Create formulas that use logical and statistical operations
·         Use advanced data analysis tools
·         Create a dashboard
·         Create a new template
·         Create macros
·         Create new functions using Visual Basic expressions
·         Demonstrate competency using more than two spreadsheet applications

2 comments :

  1. My suggested changes:

    beginner:
    *apply principles of effective sp sheet design
    *create/modify graphs
    *apply principles of effective graph design

    intermed:
    *macros

    advanced:
    *pivot tables
    *2 spreadsheet designs

    ReplyDelete
  2. Thank you for the suggestions.

    ReplyDelete