|
Skill Level-Beginning Excel
Mastered
Needs Work
Required for my job
Select rows, columns,
and cells
Edit text and
numbers in a cell
AutoFill a series
Create a graph with the
Chart Wizard
Add numbers with the
AutoSum tool
Calculate a simple
equation “by hand”
Sort data in a list
Print a spreadsheet
Beginning Excel
is recommended if you selected “needs work” on three or more skills.
Skill Level-Intermediate
Excel
Mastered
Needs Work
Required for my job
AutoFill data and
formulas
Link Spreadsheets
Use Relative and
Absolute cell references
Use conditional
formatting
Create a drop down list
Use the auditing toolbar
Intermediate Excel
is recommended if you selected “needs work” on three or more skills.
Skill Level-Advanced
Mastered
Needs Work
Required for my job
Create a Pivot Table for
data analysis
Format, group and graph
Pivot Tables
Use the What If tool
Use Goal Seeking
Import from Access or
another database
Use HLOOKUP and VLOOKUP
Advanced Excel
is recommended if you selected “needs work” on three or more skills. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
