Sams Teach Yourself Microsoft Office 2003 in 24 Hours

By Greg Perry

• Table of Contents
  • Copyright
  • About the Author
  • Acknowledgments
  • We Want to Hear from You!
  • Introduction
  • Who Should Read This Book?
  • What This Book Does for You
  • Can This Book Really Teach Office 2003 in 24 Hours?
  • Conventions Used in This Book
  • Part I. Working with Office 2003
  • Hour 1. Getting Acquainted with Office 2003
  • Part II. Processing with Word 2003
  • Hour 2. Welcome to Word 2003
  • Hour 3. Formatting with Word 2003
  • Hour 4. Managing Documents and Customizing Word 2003
  • Hour 5. Advanced Word 2003
  • Part III. Computing with Excel 2003
  • Hour 6. Understanding Excel 2003 Workbooks
    • Starting Excel
    • Understanding Worksheets and Workbooks
    • Entering Worksheet Data
    • Navigating in Excel
    • To Do: Create Your First Worksheet
    • To Do: Format the Worksheet
    • Summary
    • Q&A
  • Hour 7. Restructuring and Editing Excel 2003 Worksheets
  • Hour 8. Using Excel 2003
  • Hour 9. Formatting Worksheets to Look Great
  • Hour 10. Charting with Excel 2003
  • Part IV. Presenting with Flair
  • Hour 11. PowerPoint 2003 Presentations
  • Hour 12. Editing and Arranging Your Presentations
  • Hour 13. PowerPoint 2003 Advanced Features
  • Hour 14. Animating Your Presentations
  • Part V. Organizing with Outlook 2003
  • Hour 15. Communicating with Outlook 2003
  • Hour 16. Planning and Scheduling with Outlook 2003
  • Part VI. Tracking with Access 2003
  • Hour 17. Access 2003 Basics
  • Hour 18. Entering and Displaying Access 2003 Data
  • Hour 19. Retrieving Your Data
  • Hour 20. Reporting with Access 2003
  • Part VII. Combining Office 2003 and the Internet
  • Hour 21. Office 2003 and the Internet
  • Hour 22. Creating Web Content with Word, Excel, Access, and PowerPoint
  • Part VIII. Publishing Eye-Catching Documents
  • Hour 23. Publishing with Flair Using Publisher 2003
  • Hour 24. Adding Art to Your Publications
  • Part IX. Appendixes
  • Appendix B. Business Contact Manager and Office Extras
  • Part X. Bonus Hours
  • Hour 25. Using FrontPage 2003 for Web Page Design and Creation
  • Hour 26. Managing Your Web with FrontPage

To Do: Create Your First Worksheet

The next hour's lesson presents the details of creating, editing, and understanding specific areas of an Excel worksheet. For practice, however, work through the following steps to try Excel now. To do so, you will create a simple test-tracking worksheet for a professor. By working with a hands-on example now, you'll have a better feel for the overall Excel concept as you work the rest of this section of the book.

Follow these steps to create your first worksheet:

1. Select File, New and select Blank Workbook from the New Worksheet task pane to create a new workbook.
2. Click on cell C4 to move the cell pointer there and make it the active cell. The cell name, C4, appears in the formula bar.
3. Type Student Gradebook . The text is wider than the cell, but Excel extends the text label over into the right cell (D4).
4. Click on cell B6 and type Name .
5. Press Tab to move the cell pointer to C6. (You can also click in C6 or press the right-arrow key to move the cell pointer to C6.)
6. Enter the labels Test 1, Test 2, Test 3 , and Average in cells C6 through F6.
7. Move to B8 and enter these values across row 8: Mary Bee, 77, 89 , and 86 . (The 86 ends up in cell E8.)
8. Enter these values underneath the previous ones to add the second row of data for your worksheet: Paul North, 89, 87 , and 94 .
9. Enter the following data for the next row: Terry Smith, 93, 100 , and 95 . Notice that cell B10 is not wide enough to hold Terry Smith's entire name. As soon as you enter data in C10, the right portion of Terry Smith's name is truncated. You will fix this problem in a moment.
10. Enter the following for the row 11: Sue Willis, 64, 79 , and 83 .
11. Type Class Average: in cell D13. (The label will flow into E13.) Your worksheet should resemble the one in Figure 6.6.
    

    Figure 6.6 You are on your way to creating your first Excel worksheet!

Share This