Microsoft Excel 97 Tutorial
Updated: April 13, 2004
Learn How To...
| • | Simplify data research and organization by using worksheets and charts. |
| • | Collect, analyze, and format data in an Excel 97 workbook. |
| • | Use powerful formulas and functions to calculate grades, create budgets, and more, while using built-in tools to correct errors and ensure accuracy. |
| • | Create dynamic charts and graphs from worksheet data by using the quick and easy graphing capabilities of Excel 97. |
| • | Enhance presentations by inserting or linking charts and graphs to Microsoft Word 97 documents. |
Download the Tutorial
Table of Contents (162 KB Microsoft Word file)
Starting Excel 97 as a Beginner (458 KB Microsoft Word file)
This 10-page chapter contains information about the basics of Excel 97, from opening and navigating workbooks to saving Excel worksheets, using the Office Assistant to answer questions, and more.
Gathering the Data (371 KB Microsoft Word file)
This eight-page chapter contains the information you need to create workbooks, informational charts, grade books, graphics, and simple task charts. Learn to manage data easily by using the Cut, Paste, and Copy commands.
Formatting the Data (407 KB Microsoft Word file)
Use the powerful formatting features of Excel 97 to customize data in your worksheets, such as grade reports or research information. Learn how to use the Formatting toolbar, AutoSum button, and more.
Working with Numbers, Formulas, and Functions (511 KB Microsoft Word file)
Learn how to use formulas and functions to calculate grades and create budgets for school functions. Track and organize data, create tables to help your students learn about budgeting and interest payments, or apply formulas to test grades to analyze scores.
Using Proofing Tools (332 KB Microsoft Word file)
Ensure the accuracy of your data by using the built-in proofing tools of Excel 97. The information in this four-page chapter demonstrates how to use the spelling checker, proofing formulas, and AutoCorrect feature.
Emphasizing Your Point with Charts (668 KB Microsoft Word file)
Use the information in this 14-page chapter to quickly create charts and graphs to illustrate presentations. Learn how to create charts with worksheet data, modify standard graphs to suit your needs, create and insert art, and more.
Putting It All Together (325 KB Microsoft Word file)
Update grades or other data with ease by using worksheets or charts, and insert these charts into Microsoft Word documents. This four-page chapter provides information about how to insert and link Excel 97 charts and graphs.
