Skills inventory for Excel 2003: Advanced

Use the following form to gauge students’ skill level entering the class (students have copies in the introductions of their student manuals). For each skill listed, have students rate their familiarity from 1 to 5, with five being the most familiar. Emphasize that this is not a test. Rather, it’s intended to provide students with an idea of where they’re starting from at the beginning of class. If a student is wholly unfamiliar with all the skills, he or she might not be ready for the class. A student who seems to understand every skill, on the other hand, might need to move on to the next course in the series.

 

Skill

1

2

3

4

5

Defining and applying names

 

 

 

 

 

Using the IF, SUMIF, and ROUND functions

 

 

 

 

 

Using the PMT function

 

 

 

 

 

Using the VLOOKUP, MATCH, and INDEX functions

 

 

 

 

 

Using data tables to project values

 

 

 

 

 

Creating automatic subtotals

 

 

 

 

 

Validating data

 

 

 

 

 

Using database functions

 

 

 

 

 

Using data forms

 

 

 

 

 

Creating, rearranging, and formatting PivotTables

 

 

 

 

 

Creating PivotCharts

 

 

 

 

 

Importing data from and exporting data to text files

 

 

 

 

 

Importing and exporting XML data

 

 

 

 

 

Using Microsoft Query and Web query

 

 

 

 

 

Using Goal Seek and Solver

 

 

 

 

 

Installing and using the Analysis ToolPak

 

 

 

 

 

Creating scenarios and views

 

 

 

 

 

Running and recording a macro

 

 

 

 

 

Editing VBA modules

 

 

 

 

 

Creating custom functions

 

 

 

 

 

Publishing a PivotTable as an interactive Web page

 

 

 

 

 

Creating Document Workspaces

 

 

 

 

 

Viewing and synchronizing lists with data on a SharePoint server