Microsoft Excel 2000 Tutorial Video

Details

This Microsoft Excel tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Microsoft Excel Video Training

Contents

All the topics covered by this Microsoft Excel Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

Introduction to excel tutorials
  Getting Started Demo
 The Interface Demo
 Menus Demo
 Toolbars Demo
 Formula Bar Demo
 Columns & Rows Demo
 Scroll Bars Demo
 Sheet Tabs Demo
 Status Bar Demo
 Interface Review Demo
 Workbooks & Worksheets Demo
 Open and Close Workbooks Demo
 Save Workbooks Demo
 Getting Help Demo

The Basics
  Select and Navigate Cells Demo
 Enter Data Demo
 Edit and Delete Data Demo
 Cut,Copy and Paste Demo
 Undo and Redo Demo
 Drag and Drop Demo
 Auto Fill Demo
 AutoCorrect Demo

Working With Worksheets
  Zoom Control Demo
 Views Demo
 Resize Rows and Columns Demo
 Insert and Delete Cells Demo
 Insert and Delete Rows and Columns Demo
 Rename Worksheets Demo
 Insert and Delete Worksheets Demo
 Move and Copy Worksheets Demo
 Hide and Unhide Demo


If you purchase the CD all the contents listed below are also included.

Formatting Cells
Text formats
Align and Text Wrap
Alignment Effects
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats
Format Painter
Autoformat
Conditional Formating
Styles

Basic Formulas
 Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard

Ready for Printing?
 Headers and footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts and Maps
 Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps

Advanced Formulas
 If Functions
And, Or
Nested If Functions

Using Excel as a Databse
 Create a database
Sort Data
Filter data
Advance filter
Data forms
Database Functions

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

Analysis
 Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros
 Customizing Toolbars
Create a Macro
Edit a Macro
Creat a Macro Button

Graphics and The Drawing Toolbar
 Insert a Picture
Move, Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects

Microsoft Excel Tutorial Video Information

Product Title: Microsoft Excel
Trainer: Angie Rawling
Other Training courses by this author
Movie Details: 157 Lessons- Video run time: 7 Hours
Price North America $99.95
Price for Europen Sales £71.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

18 In Stock

BUY THIS VIDEO

Benefits of this training method
  • Unique accelerated learning, master Microsoft Excel in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Associated Titles:

Microsoft Excel 2007 Tutorials | Microsoft Access 2007 Tutorials | Microsoft Publisher 2007 Tutorial Video | Microsoft Powerpoint 2007 Training Video | Microsoft Sharepoint Training CD| Beginners FileMaker 10 Tutorial

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.

Best Selling Titles - Groups:

Access Tutorials | Microsoft Word |Excel Tutorials | FileMaker Pro | Microsoft Outlook 2000 | Microsoft Project 2000 | Microsoft Visio 2002 | Online Microsoft Excel Training Courses