Free Tutorial Central Home | Getting Started with Excel 2007 | Next Lesson |

Getting Started with Microsoft® Excel 2007 Lesson 2: Building a Worksheet

In Lesson 2, you learn to delete and rename worksheets. Next, you learn how to build a worksheet by entering and editing text or numbers and how to quickly fill adjacent cells with text or numbers. Finally, you learn how to create formulas and use functions to perform worksheet calculations and then copy formulas into adjacent cells. Throughout the lesson, you also learn techniques for enhancing a worksheet’s appearance by formatting text and numbers.

Click the "Download" button to download this free lesson in PDF format.

Objectives

  1. Save a workbook
  2. Insert, delete and rename worksheets
  3. Enter, edit, and format cell contents
  4. Create formulas
  5. Use functions
  6. Apply Accounting and Percent Style formatting

Key Terms

Mini Toolbar

relative references

shortcut menu

What-if analysis

zooming

argument

Fill feature

fill handle

formula

function