Here are 9 well written and illustrated Microsoft Excel 2000 Tutorials from
jdstiles.com. Most of these can also be used for learning Excel XP and Excel 2003 applications.
Microsoft Excel Tutorials:
jdstiles.com/mso2k/excel/
Spreadsheet Basics:
jdstiles.com/mso2k/excel/basics.html
. Screen elements
. Adding and renaming worksheets
. The standard toolbar – opening, closing, saving, and more.
Customizing Excel:
jdstiles.com/mso2k/excel/customize.html
. Menus
. Customize toolbars
. Recording a macro
. Running a macro
Modifying A Worksheet:
jdstiles.com/mso2k/excel/modify.html
. Moving through cells
. Adding worksheets, rows, and columns
. Resizing rows and columns
. Selecting cells
. Moving and copying cells
. Freeze panes
Formatting Cells:
jdstiles.com/mso2k/excel/format.html
. Formatting toolbar
. Format Cells dialog box
. Dates and times
. Styles
. Style dialog box
. Create a new style
. Format Painter
. AutoFormat
Formulas and Functions:
jdstiles.com/mso2k/excel/functions.html
. Formulas
. Linking worksheets
. Relative, absolute, and mixed referencing
. Basic functions
. Function Wizard
. Autosum
Sorting and Filling:
jdstiles.com/mso2k/excel/sorting.html
. Basic ascending and descending sorts
. Complex sorts
. Autofill
. Alternating text and numbers with Autofill
. Autofilling functions
Graphics:
jdstiles.com/mso2k/excel/graphics.html
. Adding clip art
. Add an image from a file
. Editing a graphic
. AutoShapes
Charts:
jdstiles.com/mso2k/excel/charts.html
. Chart Wizard
. Resizing a chart
. Moving a chart
. Chart formatting toolbar
. Copy a chart to Microsoft Word
Page Properties and Printing:
jdstiles.com/mso2k/excel/page.html
. Page breaks
. Page orientation
. Margins
. Headers, footers, and page numbers
. Print Preview
. Print
Keyboard Shortcuts:
jdstiles.com/mso2k/excel/shortcuts.htmlPopularity: 20% [?]
Related Posts:15 Microsoft Excel Lessons with ExercisesMicrosoft Excel Workshop Training HandoutsFree Microsoft Excel Video TrainingSofware Help Guides for Word, Excel, and PowerPointFree Microsoft Excel Ebook