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 1

Getting 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
(Click-on the above link to download a 312 KB - 28 Page Word Document)

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