Microsoft Excel 2000 gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You'll be able to easily analyze data with charts, Microsoft PivotTable views and graphs. And, use automatic formatting to create data-rich spreadsheets. Our dynamic video series will show you how to utilize all of the tools contained within the most popular spreadsheet program on the market!

Level One:

  • What is Microsoft Excel 2000
  • Navigation
  • Creating a workbook
  • Using spreadsheets and on-line help
  • Formatting values and ranges
  • Opening and modifying a workbook
  • Deleting cell contents and worksheets
  • Revising text and numbers
  • Sorting data
  • Printing workbooks
  • Printing screens and ranges
  • Using drawing tools, functions & charts
  • Inserting and deleting rows/columns
  • Using and creating templates


Level Two:

  • Auto and custom formatting
  • Creating and working with formulas
  • Formula order of operations
  • Copying formulas using relative and absolute reference
  • Using IF and nested IF functions
  • Working with dates
  • Importing data from other sources
  • Importing lists

 

Level Three:

  • Advanced charts
  • Hyperlinks and macros
  • Using filters and sorts
  • Data analysis
  • Conditional formatting and styles
  • Sharing workbooks and workgroups
  • Functions of sharing
  • Pivot tables

.........................................................................................................................


>>Meet the Expert
Shawn Oliver is a training specialist for the entire Microsoft Office family of products. He is an MCP, MCT and MOUS Certified Instructor. Shawn's easy-to-understand format and straight-forward, hands-on delivery make him one of the most effective technical application trainers in the industry.
 

 

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Microsoft EXCEL® - Microsoft Excel 2000 Training Course
Includes: 3 Interactive CD-ROMs or 3 Video Training Tapes!
Excel® CD-ROMs - Order Online
#83400CD
Excel® Videotapes - Order Online

#83400

Free Shipping (in U.S.) for Online Orders !
Problems Ordering Online? Email the Webmaster!

>>See the entire Office 2000 (MOUS) course !

Call Us @ 1.800.942.1660

© Copyright; All Rights Reseved 2000-2002 Specialized Solutions, Inc.