Chapter 7: Creating and Saving a Spreadsheet

Overview

10-Second Summary

• Create a basic spreadsheet

• Enter data

• Name ranges and navigate the worksheet

• Work with functions and formulas

• Share worksheets

• Use XML in Excel 2003

Microsoft Office Excel 2003 makes it easy ”even for those of us who weren t math majors ”to do sophisticated things with numbers . Want to create an amortization table for that new home you re thinking about? Need to create a professional-looking balance sheet to give potential investors a good sense of what they re putting their money into? Want to download data lists from the Web and include them in your reports to stockholders ?

Whatever your intent, if your project has something to do with numbers, Excel can help you create it. This chapter explains how to create a worksheet, and shows you how to enter data, work with formulas, share data via the Web, and create and map XML files.