Desktop Applications

Microsoft Excel XP Advanced

Course Code : EXCLXPADV

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

Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books