DON'T GRADE YOURSELF HERE - NOT A SELF ASSESSMENT

Please rate each skill on a scale from 1-5, with...
"1" = the most "BASIC" of skill levels, and...
"5" = the most "ADVANCED" of skill levels.
NOTE: This is NOT a question about how well "YOU" know these skills, but rather how advanced these skills are (e.g. if 'addition' is a "BASIC" skill, the 'ability to work with complex systems of differential equations' might be an "ADVANCED" skill.)

PLEASE select "Don't Know" (last column) if you feel you are not familiar enough with an item to rate it.
For example, if you don't know enough about VBA to say whether the skill is 'advanced' in your mind - select 'Don't Know' for related items

  1 2 3 4 5 Don't Know
Sparklines (new 2010 feature)
Using the Data Analysis tool pack
Data Table usage for scenario analysis
Locking/Protecting spreadsheet cells, sheets, workbooks
Merge and split cells
Create and modify custom lists
Using range references for copying/pasting in VBA
Meaningfully integrating DataTables and Iteration mode
Conversions between drawn line objects and plotted data (VBA)
Math programming and optimization with standard Solver
Adding trendlines to plots
Hot keys : Ctrl-"X" shortcuts, Shft-space, Alt-"X-Y-Z", etc.
Basic graphics (scatterplot, bar chart, etc.)
Recording a Macro for use in the spreadsheet
Built-in array/matrix functions (e.g. LINEST)
Integrating embedded application objects in spreadsheets
Opening text files as delimited data sources
Splitting / Freezing frames
Error identification and handling in VBA
Setting up PowerPivot for automated updates
Apply and manipulate hyperlinks in sheet
Conditional formatting
Use of the OUtCoMES roadmap
Applying the autofill capability
Pre-setting print ranges with headers, footers, breaks, etc.
Knowlege of scope/limitations of DoEvents (VBA)
Knowledge of using PowerPivot basics
Developing a User-defined Function (VBA)
Automated pareto charting of selected data or data updates
Create and apply styles
Using the iterative calculation mode in Excel
Naming/Labeling cell ranges
Use of the FAST modeling standard
Automating manipulations and calls to Palisades apps (VBA)
VSTO integration (and associated coding)
Rolling time-window tables/graphs (e.g. t1-->t2 linked & variable)
Tracing precedents and dependents
Building/changing embedded forms/controls
Manual or manual-triggered pull of external data into spreadsheet
Pivot Table (& Chart) for data summarization
Generating/Editing a dialogue pop-up (user-form pop-up)
Automating embedded MapPoint objects (VBA)
Manual export of spreadsheet data to other applications
Manipulating Solver and specializing Solver reports (via VBA)
Data validation rule application
Standard built-in non-array functions (e.g. SUM, MATCH, etc.)
Using basic loops (For-Next, While-Do) in VBA
Manipulating ribbons, menu items, etc. (VBA)
Extraction and data parsing from web queries
Using the Sort and Filter tools

REMEMBER ! : This is NOT a self-assessment. All we are doing here is judging how 'basic' or 'advanced' a skill seems to be (NOT how 'you' are at something). Please modify your answers above if necessary at this point.

ALSO - Please check to make sure you used the last column above ONLY for "Don't Know" responses. Provide additional notes on your responses here if needed:

T