Microsoft Excel Tutorials
Each of the Excel tutorials is designed as two Modules. In the first Module, you'll learn how to create a spreadsheet, enter data and work with formulas. In the second Module you'll learn how to format, print, and create and print graphs from the spreadsheet. The individual areas, covered in each Module, are furnished below. All of the tutorials follow the same theme - creating a personal budget spreadsheet. This is purposeful. It was felt that, as a person progressed to newer versions of Excel, having the same tutorial theme would make them more comfortable with learning the material. Each succeeding tutorial is enhanced to incorporate new features in Excel and respond to added features requested by users.
Module 1Getting Started with Excel (Menu bars, buttons, toolbars, moving
around Excel)
Creating Worksheets (Entering data, numbers and dates, Saving)
Manipulating Worksheet Data (Copying, Cutting, Pasting data)
Working with Basic Formulas and Functions (Formulas, Functions, Auto Calculate,
Absolute referencing, and Wizards)
Module 2
Printing Worksheets
Formatting Worksheets (Inserting, Deleting, Widths of rows and columns, Using
number formats, Aligning data)
Enhancing Worksheets (Changing Text Fonts, Borders, Shading, Gridlines)
Using Styles and AutoFormats
Finding and Replacing Data
Creating Graphs
Tutorials
Excel 97
Introductory Tutorial
Excel 97 Income Statement Tutorial
(Click-on the above link to download a 168 KB - 12 Page Word Document)
Excel
97 Balance Sheet Tutorial
(Click-on the above link to download a 172 KB - 13 Page Word Document)
Excel 2000 Introductory Tutorial
(Click-on the above link to download a 395 KB - 32 Page Word Document)
Excel XP/2002
Introductory Tutorial
(Click-on the above link to download a 517 KB - 34 Page Word Document)
Excel
2003
Introductory Tutorial
(Click-on the above link to download a 1.03 MB - 38 Page Word Document)
Spreadsheets Created by Tutorials
The individual spreadsheets, created by each tutorial, are furnished below if you would like to download them.
Excel 97 spreadsheet
(Click-on the above link to download a 38 KB database file)
Excel 97
Income Statement spreadsheet
(Click-on the above link to download a 17 KB database file)
Excel 97
Balance Sheet spreadsheet
(Click-on the above link to download a 18 KB database file)
Excel 2000
spreadsheet
(Click-on the above link to download a
17 KB database file)
Excel XP/2002
spreadsheet
(Click-on the above link to download a
19 KB database file)
Excel 2003
spreadsheet
(Click-on the above link to download a
19 KB database file)
If you have any questions or comments, please don't hesitate to contact murray.t@lynchburg.edu
Return to Office Tutorials Homepage
Resources for Excel Spreadsheets
Introductory:
Microsoft Press Quick Course in Excel 97
Microsoft Press Quick Course in Excel 2000
Microsoft Press Excel Version 2002 Plain and Simple
Microsoft Press Excel Version 2003 Step by Step
Advanced
Microsoft Press Running Microsoft Excel 97
Microsoft Press Running Microsoft Excel 2000
Microsoft Press
Microsoft Excel Version 2002 Inside Out
Microsoft Press
Microsoft Excel Version 2003 Inside Out