 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn various advanced techniques for analysing and manipulating data and to use the list-management capabilities in Excel 2000.
Students will learn how to add graphics to a worksheet or chart, perform advanced filters and queries on data, create advanced formulas, link files, consolidate data, and record macros.
Prerequisites:
Excel 2000 Intermediate, or equivalent knowledge.
Unit 1 : Using graphic objects
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts
Unit 2 : Advanced techniques for filtering data
Multiple-condition criteria
Managing a filtered list
Unit 3 : Querying data
Database functions
External databases and queries
Running a Web Query on the Internet
Unit 4 : Advanced formula construction
The VLOOKUP function
Using IS functions and the Auditing features
Unit 5 : Working with multiple worksheets
Working with workbooks
Linking cells in different workbooks
Workbooks versus links and workspaces
Unit 6 : Consolidating and analysing 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
Unit 7 : Protect and display options
Using comments
Protecting workbooks
Using custom views
Report Manager
Unit 8 : Introduction to macros
Running a macro
Recording a macro
Viewing and editing VBA code
Unit 9 : Working with interactive Excel Web documents
Saving Excel worksheets as Web documents
Spreadsheet Web Components