Training Program Details
What can be learned at this seminar:
IMPORTING DATA
Importing Data from External Sources
Importing Text Files
Using Microsoft Query
Querying Date from the Web
Refreshing Data
TEMPLATES AND STYLES
Working with Templates
Working with Styles ANALYZING DATA
o What-If Analysis
o Goal Seek
o Data Tables
o Scenario Manager
o Solver
MACROS AND CUSTOM CONTROLS
o Working with and Running Macros
o Adding Custom Controls
SECURITY AND PROOFING
o Security Features
o Protecting Excel Files
o Working with Digital Signatures
o Using Data Validation
o Using Text to Speech
CUSTOMIZING EXCEL
o Configuring Excel Options
o Customizing the Excel Environment
o Working with Workspaces
COLLABORATION AND CONSOLIDATION
o Sharing Workbooks
o Sending Workbooks
o Consolidation
