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