|
Excel
2000: Advanced
Prerequisites: Excel 2000 -
Intermediate or
equivalent knowledge.
Lesson 1: Customizing the
work area
- Working with built-in toolbars
Using custom toolbars
Creating and using styles
Using templates
Lesson 2: Advanced
formula construction
Using the IF function
Using the VLOOKUP function
Using IS functions and the
Auditing features
Lesson 3: Using pivot
tables
Modifying pivot tables
Grouping and summarizing data
in a pivot table
Lesson 4: Working with
multiple worksheets
Linking cells in different
workbooks
Workbook versus links and
workspaces
Lesson 5: Consolidating
and analyzing data
- Consolidating data from more
than one worksheet
Using the Goal Seek and Solver
utilities
Using Scenario Manager to view
a worksheet with different input values
Lesson 6: Using
protection and display options
Protecting workbooks
Using custom views
Lesson 7: Introduction to
macros
Recording a macro
Viewing and editing VBA code
Lesson 8: Working with
interactive Excel Web documents
- Saving Excel worksheets as Web
documents
Spreadsheet Web Components
|
