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.
If you want to learn all the in's and out's 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 user in no time.
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
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters 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
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
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
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
Complete CD Contents and FREE Video Tutorials 
UK & Europe
US & Canada