Microsoft Excel 2000 advanced courseware training materials, resources & training manuals for tutor-led Excel 2000 IT courses (foundation level)

Computer Training Materials

Customisable Courseware
No Annual Renewal Fees
Unlimited Number of Users
Unlimited Reprinting Rights
PLUS Intranet Versions

Region |
UK/Ireland | USA/Canada Australia/International

Training Courses

Microsoft Office 2010
Word 2010 Foundation
Word 2010 Intermediate
Word 2010 Advanced
Word 2010 Basics
Word 2010 Expert
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
Excel 2010 Expert
Excel 2010 Basics
PowerPoint 2010 Foundation
PowerPoint 2010 Intermediate
PowerPoint 2010 Advanced
PowerPoint 2010 Basics
PowerPoint 2010 Expert
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
Access 2010 Basics
Access 2010 Expert
Outlook 2010 Basics

Microsoft Office 2007
Word 2007 Foundation
Word 2007 Intermediate
Word 2007 Advanced
Word 2007 Basics
Word 2007 Expert
Excel 2007 Foundation
Excel 2007 Intermediate
Excel 2007 Advanced
Excel 2007 Basics
Excel 2007 Expert
PowerPoint 2007 Foundation
PowerPoint 2007 Intermediate
PowerPoint 2007 Advanced
PowerPoint 2007 Basics
PowerPoint 2007 Expert
Access 2007 Foundation
Access 2007 Intermediate
Access 2007 Advanced
Access 2007 Basics
Access 2007 Expert
Outlook 2007 Basics

Microsoft Office 2003
Word 2003 Foundation
Word 2003 Intermediate
Word 2003 Advanced
Word 2003 Basics
Word 2003 Expert
Excel 2003 Foundation
Excel 2003 Intermediate
Excel 2003 Advanced
Excel 2003 Basics
Excel 2003 Expert
PowerPoint 2003 Foundation
PowerPoint 2003 Intermediate
PowerPoint 2003 Advanced
PowerPoint 2003 Basics
PowerPoint 2003 Expert
Access 2003 Foundation
Access 2003 Intermediate
Access 2003 Advanced
Access 2003 Basics
Access 2003 Expert
Outlook 2003 Basics

ECDL / ICDL COURSEWARE
UK/ BCS ECDL
International ECDL/ ICDL

ICT/WINDOWS COURSEWARE
PC Basics
Internet Explorer 8
Windows XP Basics
Windows Vista Basics
Windows 7 Basics

Site Map

SEO Training Courses

Microsoft Excel 2000 Courseware Training Materials
Advanced Level 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. CUSTOMIZING EXCEL

CUSTOMIZING EXCEL 2000 - OPTIONS
CUSTOMIZING TOOLBARS

6. SECURITY AND PROOFING WITHIN EXCEL

AUDITING AND SECURITY FEATURES WITHIN EXCEL 2000
THE SPELL CHECKER
WHAT ARE SHARED WORKBOOKS?
ADVANCED WORKBOOK SHARING OPTIONS
DATA VALIDATION
WORKBOOK PASSWORD PROTECTION
WORKBOOK PROTECTION
WORKSHEET PROTECTION
CELL PROTECTION
EXCEL 2000 AUDITING TOOLS
AUDITING WORKSHEETS
CELL COMMENTS

7. DATA MAPS

WHAT ARE DATA MAPS?
THE DATA MAP CONTROL DIALOG BOX
PLACING DATA ON A MAP
FORMATTING A DATA MAP

8. CONSOLIDATION

WHAT IS CONSOLIDATION?
CONSOLIDATING ROWS AND COLUMNS

   Computer Training Courseware for IT Teaching Professionals
   Quality courseware materials and resources for tutor-led computer training :
   For schools, colleges, IT trainers, corporate training departments, & computer training companies.

Microsoft Excel 2000 Courseware Training MaterialsAdvanced Level Course