IMPORTING DATA IN MICROSOFT EXCEL XP
- Importing Data From External Sources
- Importing Text Files
- Using Microsoft Query
- Querying Data From The Web
- Refreshing Data
TEMPLATES AND STYLES IN MICROSOFT EXCEL XP
- Working With Templates
- Working With Styles
ANALYZING DATA IN MICROSOFT EXCEL XP
- What-If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
MACROS AND CUSTOM CONTROLS IN MICROSOFT EXCEL XP
- Working With Macros
- Running Macros
- Adding Custom Controls
SECURITY AND PROOFING IN MICROSOFT EXCEL XP
- Security Features
- Protecting Excel Files
- Worksheet Protection
- Working With Digital Signatures
- Checking Spelling
- Using Data Validation
- Using Text To Speech
- Documentation
CUSTOMIZING EXCEL 2002 IN MICROSOFT EXCEL XP
- Configuring Excel 2002 Options
- Customizing The Excel Environment
- Working With Workspaces
COLLABORATION AND CONSOLIDATION IN MICROSOFT EXCEL XP
- Sharing Workbooks
- Sending Workbooks
- Consolidation