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 5
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