Free Microsoft Office Training and Tutorial Resources




    



January 13, 2006

Excel 2000 Training Tutorials

Here are many well-written training tutorials that will help you learn how ot use Excel to its fullest extent. Each of these tutorial topics contains several pages of screen shots to help you understand and apply the techiques and application features being demonstrated. Most of these tutorials also apply to Excel XP and Excel 2003.

Excel 2000 Training Tutorials


A Sample Application

Formatting
Using Formulas
More on Formulas
Filtering and Sorting
Pivot Tables

Excel Basics

Start Excel
Creating a File in Excel
Saving a File
Open a Workbook
Finding a Work Book
Switching between WorkBooks
Email a Workbook
Edit or Delete Data
Move or Copy Data
Finding Data
Spelling Check in Excel
Inserting Rows or Columns
Deleting Rows or Columns
Hiding Columns
Naming Cells
Undo
Zooming In or Out
Splitting Worksheets
Entering a Formula
Entering Functions
Adding Numbers
Copying a Formula
Inserting a Worksheet
Switching between Worksheets
Renaming a Worksheet
Moving a Worksheet

Formatting

Changing Column Width or Row Height
Font Face and Size
Bold Italic or Underline
Colors
Cell Alignment
More on Cell Formatting
Number Formats
Data Formats
Adding Borders
Copy Formatting
Clear Formatting
Autoformat in Excel

Printing

Print Preview
Print
Page Orientation
More Print Options
Changing Margins
Page Breaks
Specifying Number of Pages
Add Page Labels
Adding a Header or Footer

Lists and Macros

Creating a List
Filtering Data in a list
Sorting Data in a list
Adding Subtotals to a List
Macros

Charts

Creating a Chart Part I
Creating a Chart Part II
Changing Chart Type
Moving Resizing or Deleting A chart
Adding Data to a Chart
Printing a Chart

Popularity: 1% [?]




Related Posts:
  • 12 Free Office 2000 Training Manuals
  • 11 Microsoft Office eBooks
  • 10 Excel Tutorials and How-Tos
  • Tutorials for Microsoft Office 2000 and XP Applications
  • 2 Beginning Excel Tutorials

  • No Comments »

    No comments yet.

    RSS feed for comments on this post.

    Leave a comment

    You must be logged in to post a comment.