|
Coding No.
|
SKILL
|
Chapters
|
Page(s)*
|
|
XL2000E.1
|
Importing and exporting data
|
|
|
|
XL2000E.1.1
|
Import data from text files (insert, drag
and drop)
|
8
|
E270-E273, E291-E293
|
|
XL2000E.1.2
|
Import from other applications
|
8
|
E283, E286
|
|
XL2000E.1.3
|
Import a table from an HTML file (insert,
drag and drop - including HTML
round tripping)
|
8
|
E283-E285
|
|
XL2000E.1.4
|
Export to other applications
|
8
|
E275, E276-E277
|
|
XL2000E.2
|
Using templates
|
|
|
|
XL2000E.2.1
|
Apply templates
|
2
|
E44
|
|
XL2000E.2.2
|
Edit templates
|
2
|
E51-E52
|
|
XL2000E.2.3
|
Create templates
|
2
|
E49
|
|
XL2000E.3
|
Using multiple workbooks
|
|
|
|
XL2000E.3.1
|
Using a workspace
|
2
|
E59-E60
|
|
XL2000E.3.2
|
Link workbooks
|
2
|
E62-E63
|
|
XL2000E.4
|
Formatting numbers
|
|
|
|
XL2000E.4.1
|
Apply number formats (accounting, currency,
number)
|
1
|
E4-E5
|
|
XL2000E.4.2
|
Create custom number formats
|
1
|
E5-E7
|
|
XL2000E.4.3
|
Use conditional formatting
|
1
|
E21-E22
|
|
XL2000E.5
|
Printing workbooks
|
|
|
|
XL2000E.5.1
|
Print and preview multiple worksheets
|
7
|
E258
|
|
XL2000E.5.2
|
Use the Report Manager
|
7
|
E259-E260
|
|
XL2000E.6
|
Working with named ranges
|
|
|
|
XL2000E.6.1
|
Add and delete a named range
|
3
|
E97-E99
|
|
XL2000E.6.2
|
Use a named range in a formula
|
3
|
E99
|
|
XL2000E.6.3
|
Use Lookup Functions (Hlookup or Vlookup)
|
3
|
E99-E100
|
|
XL2000E.7
|
Working with toolbars
|
|
|
|
XL2000E.7.1
|
Hide and display toolbars
|
6
|
E223
|
|
XL2000E.7.2
|
Customize a toolbar
|
6
|
E223-E225
|
|
XL2000E.7.3
|
Assign a macro to a command button
|
6
|
E214-E215
|
|
XL2000E.8
|
Using macros
|
|
|
|
XL2000E.8.1
|
Record macros
|
6
|
E210-E211
|
|
XL2000E.8.2
|
Run macros
|
6
|
E212-E213
|
|
XL2000E.8.3
|
Edit macros
|
6
|
E215-E216
|
|
XL2000.9
|
Auditing a worksheet
|
|
|
|
XL2000E.9.1
|
Work with the Auditing Toolbar
|
6
|
E228-E229
|
|
XL2000E.9.2
|
Trace errors (find and fix errors)
|
6
|
E229
|
|
XL2000E.9.3
|
Trace precedents (find cells referred to in
a specific formula)
|
6
|
E229
|
|
XL2000E.9.4
|
Trace dependents (find formulas that refer
to a specific cell)
|
6
|
E229
|
|
XL2000E.10
|
Displaying and formatting data
|
|
|
|
XL2000E.10.1
|
Apply conditional formats
|
1
|
E22
|
|
XL2000E.10.2
|
Perform single and multi-level sorts
|
4
|
E127-E128
|
|
XL2000E.10.3
|
Use grouping and outlines
|
4
|
E135-E136
|
|
XL2000E.10.4
|
Use data forms
|
4
|
E119
|
|
XL2000E.10.5
|
Use subtotaling
|
4
|
E139-E140
|
|
XL2000E.10.6
|
Apply data filters
|
4
|
E143-E145
|
|
XL2000E.10.7
|
Extract data
|
4
|
E147-E148, E149-E150
|
|
XL2000E.10.8
|
Query databases
|
8
|
E288-E289
|
|
XL2000E.10.9
|
Use data validation
|
4
|
E121-E124
|
|
XL2000E.11
|
Using analysis tools
|
|
|
|
XL2000E.11.1
|
Use PivotTable autoformat
|
5
|
E170
|
|
XL2000E.11.2
|
Use Goal Seek
|
5
|
E193
|
|
XL2000E.11.3
|
Create pivot chart reports
|
5
|
E181-E183
|
|
XL2000E.11.4
|
Work with Scenarios
|
5
|
E199-E200
|
|
XL2000E.11.5
|
Use Solver
|
5
|
E195-E196
|
|
XL2000E.11.6
|
Use data analysis and PivotTables
|
4, 5
|
E161-E165, E175-E177
|
|
XL2000E.11.7
|
Create interactive PivotTables for the Web
|
5
|
E189
|
|
XL2000E.11.8
|
Add fields to a PivotTable using the Web browser
|
5
|
E189
|
|
XL2000E.12
|
Collaborating with workgroups
|
|
|
|
XL2000E.12.1
|
Create, edit, and remove a comment
|
7
|
E253-E254
|
|
XL2000E.12.2
|
Apply and remove worksheet and workbook protection
|
7
|
E240, E242-E244
|
|
XL2000E.12.3
|
Change workbook properties
|
7
|
E238-E240
|
|
XL2000E.12.4
|
Apply and remove file passwords
|
7
|
E241-E242
|
|
XL2000E.12.5
|
Track changes (highlight, accept, and reject)
|
7
|
E248-E249
|
|
XL2000E.12.6
|
Create a shared workbook
|
2, 7
|
E67-E68, E238
|
|
XL2000E.12.7
|
Merge workbooks
|
7
|
E254
|
