Importing Data
- Importing Data From External Sources
- Importing Text Files
- Using Microsoft Query
- Querying Data From the Web
- Refreshing Data
Templates and Styles
- Working with Templates
- Working with Styles
Analysing Data
- What-If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
- Using Pivot Tables
|
Macros and Custom Controls
- Working with Macros
- Running Macros
- Adding Custom Controls
Security and Proofing
- Security Features
- Protecting Excel Files
- Worksheet Protection
- Working with Digital Signatures
- Checking Spelling
- Using Data Validation
- Using Text to Speech
- Documentation
| Customising Excel 2003
- Configuring Excel 2003 Options
- Customising the Excel Environment
- Working with Workspaces
Collaboration and Consolidation
- Sharing Workbooks
- Sending Workbooks
- Consolidation
|
