Skill Ratings - Blackbelts 2012

DON'T GRADE YOURSELF HERE - NOT A SELF ASSESSMENT

Question Title

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

Question Title

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: