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