Microsoft Excel 2000 Tutorial Video

Self Study, Tutorial Video on CD - DVD. Tutor Angie Rawling guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users

These Microsoft Excel tutorials are ideal for the beginner to intermedate user. Expert Lorie Flenner explains how to take advanage of the comprehensive range of tools that Excel offers to build not only simple spreadsheets, but to also add functionallity and life to your data, using step by step training this tutorial highlights in great detail how to create charts and graphs, pivot tables, adding graphics and so much more. If you need to learn Excel and would like the lessons delivered using clear-cut, plain English explanations, then look no further. Related products : Excel 2007 Tutorials . Watch our free Microsoft Excel Tutorial Videos by clicking the blue lesson links below.

try for free

Microsoft Excel Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction The Basics Working With Worksheets
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$149.95
Formatting Cells
  • Text Formats
  • Align and Text Wrap
  • Alignment Effects
  • Format Painter
  • Borders and Shading
  • Numbers Formats
  • Date and Time Formats
  • Custom Formats
  • 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
  • Create 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
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356