|
Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet
Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
 Expression
Web
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 5 Courseware
Advanced Level Training Course
Courseware Training Manual
1. Templates and styles
- What are templates?
- Creating templates
- What are styles?
- Creating and using styles
2. Importing data
- Why import data?
- The text wizard
- From text to spreadsheet
- Importing from a database
- Microsoft query
- Database terminology
- Starting Microsoft query
- Adding fields to query
- Completing the query
3. 'What if' Utilities
- Excel 'what if?' type utilities
- Goal seek
- Graphic goal seeking
- Scenario manager
- Solver
- Before solver
- After solver
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
- Rearranging a pivot table
- Pivot and query toolbar
6. Customizing Excel
- Customizing Excel options
- Customizing toolbars
- Hiding other screen elements
7. Security and proofing within Excel
- Auditing and security features within Excel
- Spelling checker
- Workbook password protection
- Workbook protection
- Worksheet protection
- Cell protection
- Object protection
- Excel auditing tools
- Auditing worksheets
- Using tracers
- Cell notes and documentation
- The info window
8) Miscellaneous advanced features
- Grouping and ungrouping worksheets
- Fractions
- What is consolidation?
- Consolidating rows and columns
Microsoft Office 2007 Courseware materials
|
