Skill Ratings - Blackbelts 2012


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