|
Training
Materials for:
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint XP
Microsoft Access
Internet
Explorer
Outlook
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 97
Advanced Level Training Course
Courseware Training Manual
1. Templates and styles
- What are templates?
- Creating templates
- Using templates
- What are styles?
- Creating and using styles
2. Importing data
- Why import data?
- The text wizard
- Importing from a database
- Database terminology
- Using Microsoft query
3. 'What if' Utilities
- Excel "what if?" Type utilities
- Goal seek
- Graphical goal seeking
- Scenario manager
- Solver
- Solver terminology
- Solver - an example
4. Macros and custom controls
- What are macros?
- To record a macro
- Running macros
- Creating a button in a worksheet and assigning a macro to it
- Attaching macros to a button
- Drawing, editing and formatting buttons
5. Pivot tables
- What is a pivot table?
- A sample pivot table
- To create a pivot table
- Pivot Table toolbar
6. Customizing Excel
- Customizing Excel 97 - options
- Customizing toolbars
7. Security and proofing within Excel
- Auditing and security features within Excel 97
- The spell checker
- What are shared workbooks?
- Advanced workbook sharing options
- Data validation
- Workbook password protection
- Workbook protection
- Worksheet protection
- Cell protection
- Excel 97 auditing tools
- Auditing worksheets
- Cell comments
8. Data maps
- What are data maps?
- The data map control dialog box
- Placing data on a map
- Formatting a data map
9. Consolidation
- What is consolidation?
- Consolidating rows and columns
|
