Faster Smarter Microsoft Office System -- 2003 Edition
-
Excel is a full-featured spreadsheet program that you can use to do simple or complex numeric operations.
-
A workbook is a collection of worksheets in Excel. A worksheet is the page on which you perform mathematical operations. A cell is the intersection of a column and row, and stores one data value.
-
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 cells quickly.
-
Tablet PC support in Excel 2003 enables you to edit, annotate, and sketch worksheet changes on the fly.
-
A range is a selected group of cells in a worksheet. You can name ranges that you work with regularly to find and reference them more easily.
-
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 members near and far. The feature uses SharePoint Team Services to create a shared Web site that houses important collaborative documents.
-
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.