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
My suggested changes:
ReplyDeletebeginner:
*apply principles of effective sp sheet design
*create/modify graphs
*apply principles of effective graph design
intermed:
*macros
advanced:
*pivot tables
*2 spreadsheet designs
Thank you for the suggestions.
ReplyDelete