by
Dr. Katherine T. Smith
Dr. L. Murphy Smith
Dr. Lawrence C. Smith, Jr.
Contents
| 1 Computer Basics | Components of the computer. Operating systems software. Windows Operating system. Loading your Excel spreadsheet program. Basic commands. Saving a file. Closing files. Retrieving files. Exiting. |
| 2 Making a Worksheet | Worksheet layout. An illustration. Editing. Moving cell contents. Inserting rows and columns. Deleting and shifting cells. Centering. Changing column or row width. Copy and paste. Printing. |
| 3 Formulas, Functions, and Formatting | Automatic sums. Formulas. Writing formulas. Copying formulas. Functions. Date and other functions. Numeric formatting. Percentage symbol. Currency style. Commas. Customized formatting. |
| 4 Charts | Column chart. Stacked-column chart. Line Chart. Pie chart. |
| 5 Worksheet Manipulation | Range names. Freeze panes. Split screen. Importing data. |
| 6 Database Tools | Data form. Data sort. Sorting a single column or row. Sorting multiple columns or rows. Autofill. Autofilter. |
| 7 Macro Commands | Creating a macro. Running a macro. |
| 8 Guidelines for Worksheet Design | Requirements outline. File ID. Data input and output. Input alignment. Manual recalculation. Backup files. Testing. |
| 9 Step-by-Step Excel Example | Creating an Excel worksheet. Editing a cell. Centering. Inserting formulas. Manipulating data. Numeric formatting. Column expansion. Printing. Creating an Excel pie chart. |
| Spreadsheet Assignments | 69 total exercises. Suggested Assignment Schedule. |
| Solutions to Selected Assignments | Solutions |
| Index | Alphabetical List |
Back to Starting Page
Prentice-Hall
Microsoft Corporation
Web Search Engines
Quotations on Ethics (cool quotes & movie clips)
The Bottom Line is Betrayal
Contact
the Webmaster with comments or suggestions for improving this page.
This
page is always under construction.