CIT Skills Assessement (Computer Skills)
This evaluation measures your current knowledge of the chosen topic and helps determine if this course is appropriate for you current skill level. Please check the box which best describes your skill. "Objectivity Increases Accuracy"
 
Company
    Telphone  
First Name
Last Name
 
Email
Microsoft - Excel 2003 Advanced - Specialization
Can Do
Need Help
Cannot Do
1.
  Importing and exporting XML data
2.
  Using the IF, SUMIF, and ROUND functions
3.
  Using the PMT function
4.
  Using the VLOOKUP, MATCH, and INDEX functions
5.
  Using data tables to project values
6.
  Creating automatic subtotals
7.
  Validating data
8.
  Using database functions
9.
  Using data forms
10.
  Creating, rearranging, and formatting PivotTables
11.
  Defining and applying names
12.
  Importing data from and exporting data to text files
13.
  Viewing and synchronizing lists with data on a SharePoint server
14.
  Using Microsoft Query and Web query
15.
  Using Goal Seek and Solver
16.
  Installing and using the Analysis ToolPak
17.
  Creating scenarios and views
18.
  Running and recording a macro
19.
  Editing VBA modules
20.
  Creating custom functions
21.
  Publishing a PivotTable as an interactive Web page
22.
  Creating Document Workspaces
23.
  Creating PivotCharts