When you re ready to save the spreadsheet, simply press Ctrl+S to display the Save As dialog box. To save the worksheet, simply navigate to the folder in which you want to save the file, enter a file
Excel is a
A workbook is a collection of worksheets in Excel. A worksheet is the page on which you perform mathematical operations. A
You add data to the worksheet ”including number, text, date, and time values ”by clicking a cell and typing the information.
You can use Excel s AutoFill feature to fill data
Tablet PC support in Excel 2003 enables you to edit, annotate, and sketch worksheet changes on the fly.
A range is a selected
Excel includes a number of preset functions you can include in formulas to execute common operations. Excel provides a number of features to help you find the right function and ensure that your formulas are correct.
Excel includes the Shared Workspace task pane to enable you to work collaboratively on projects with team
XML support in Excel enables you to create, import, work with, and export XML data files and spreadsheets. You use a visual mapping tool to simply drag- and-drop XML tags to data items on the worksheet.
Excel allows you to save your worksheets in a number of different file formats, including Web pages, XML Spreadsheets, text files, and files supported by other popular spreadsheet and database programs.
Learn editing techniques for data, text, and formulas
Copy, move, and paste
Change data formats
Choose text font, style, and
Add borders and shading
Entering and saving worksheet data is only a fraction of what you can do with Microsoft Office Excel 2003. Next steps involve making sure your worksheet is as accurate as it can be and making it look professional by choosing fonts, colors, pictures, and more. When you ve got the worksheet the way you want it, you can preview it to make sure the page breaks occur in the right places, and choose your favorite options before you print.
Microsoft Online includes a gallery of common worksheet templates you can use to build worksheets you are creating. If you want to apply formats to an existing worksheet section, you can use AutoFormat, available in the Format menu. See the section, Fast Formatting, later in this chapter for details.