PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Final Cut Pro 7 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

Microsoft Excel 2000 Tutorial
 Professionally created, self-study video training.

About this Tutorialshow details
If you want to learn all the useful tools and features of this powerful business application then you might like to take a look at this beginners Microsoft Excel tutorial. It not only describes all the essential concepts and techniques in an easy to follow manner, expert author Angie Rawling also divulges numerous useful tips, tricks and techniques that will transform you into a confident MS Excel user in no time. You can evaluate this visual training method right now, click any blue linked lesson below for FREE MS Excel video training movies...
Learn this Software - See below for FREE TUTORIALS
LATER VERSIONS AVAILABLE
View the more recent
Microsoft Excel 2007 Tutorial

Or, see our complete range of
Microsoft Excel Tutorials


Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders


Microsoft Excel Tutorial - 2000 - Info

CLICK HERE TO BUY THIS CD
Tutor: Angie Rawling/NMG
Duration: 7 hrs / 157 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33101
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers use simplistic terms and minimal jargon.
  Step-by-step video training from your own desktop. Delivered via CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Microsoft Excel Automation | Microsoft Excel 2002 | Microsoft Excel 2003 | MySQL | FileMaker Pro 7 | Microsoft Access 2002 | Microsoft Excel 2003 for Statistics | Complete range of Microsoft Office 2007 Tutorials | Complete Range of Advanced Excel Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Intro
Microsoft Excel Tutorial Overview
The Interface Described
Menus Explored
Toolbars Explored
The Formula Bar
Columns and Rows
Scroll Bars Explained
Sheet Tabs
Status Bar
The Interface Review
Workbooks and Worksheets Explained
Open and Close Workbooks
Saving Workbooks
Gaining Help in 2000

The Fundamentals
How to Select and Navigate Cells
Entering Data
Editing and Deleting Data
Cut, Copy and Paste
Undo and Redo
Dragging and Dropping
Auto Fill Explained
AutoCorrect (step by step)

Using Worksheets
Zoom Control Explained
Views
Resizing Rows and Columns
Inserting Cells
Deleting Cells
Inserting and Deleting Rows and Columns
Renaming Worksheets
Inserting and Deleting Worksheets
Moving and Copying Worksheets
How to Hide and Unhide

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Formatting Cells
Chapter Overview - Text Formats
Aligning and Wrapping text
Alignment Effects
Borders and Shading Explained
Formats Explained:
• Number
• Date and Time
• Custom
Format Painter
Autoformat
Conditional Formatting
Styles

Basic Formulas
Formula Structure Explained
Operators in Excel
Creating Formulas in Excel 2000
Autofill Formulas
Autosum
Relative and Absolute Reference
Using the Function Wizard

Ready for Printing?
Headers and Footers
Using Print Preview
Scaling the Print Area
Setting the Print Area
Creating Margins
Final Printing

Charts and Maps
Creating a Chart in Excel 2000
Chart Wizard and Options
The Legend
The Series
Using the Chart Toolbar
3D Charts
The Creation of Maps
Customising Maps
How to Label Maps

Advanced Formulas
If Functions
And, Or
Nested If Functions

Using Excel as a Database
The Creation of a database
Sort & Filter Data
Advance filter
Data forms
Database Functions

Linking & Protecting
Formula Links
Range names
Paste Special
Protecting Cells
Protect Worksheets and Workbooks
Passwords in Excel

Analysis
Goal Seek and Solver Explained
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros
Chapter Overview
How to Customise Toolbars
Creating a Macro in Excel 2000
Editing a Macro
Creating a Macro Button

Graphics and The Drawing Toolbar
Inserting a Picture
Move, Resize & Crop
The Creation of Shapes and Lines
Arranging and Grouping
Fills and Line Colour
Arrows in Excel
AutoShapes
Flip and Rotate
Text boxes Explained
WordArt
Shadow and 3D Effects

CLICK HERE TO BUY THIS CD


  UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841

  US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649