Excel 97 for Windows Made Simple

The main principles: Introducing Excel 97; Screen components; The worksheet grid; Moving around the sheet; Getting help; Leaving Excel 97; Summary. Creating a worksheet; Entering data; Text and number formats; Simple editing; Summary. File operations: Saving the worksheet; The Worksheet window; Closing a file; Loading a worksheet; Summary. Formulae: Entering a formula; Calculation options; Operators; Using brackets; Ranges; Names; Summary. Functions: The SUM function; Other functions; the Formula Palette; The IF function; Summary. Formula operations: Copying formulae; Relative and absolute references; Moving cells and ranges; Summary. Number formats: Applying number formates; Decimal places; Stored and displayed values; The Currency format; Scientific format; Summary. Other formats: Dates and times; Custom formats; Summary. Formatting a worksheet: Column width and row height; Alignment; Inserting rows and columns; Deleting rows and columns; Fixing titles; Protecting data; Summary. Cosmetics: Changing fonts; Borders; patterns and colours; Hiding rows and columns; Copying formats; Format styles; Summary. Workbooks: Multiple worksheets; Starting a new sheet; Multiple windows; Worksheet groups; Changing sheets; Formulae across worksheets; Summary. Charts and graphics: Chart Wizard; Editing the chart; Changing chart data; Chart sheets; Graphic objects; Text boxes; Summary. Printing: Printer set-up; Page set-up; Margins; Headers and footers; Sheet settings; Preview; Print options; Summary. Advanced features: Sorting data; Find and replace; Toolbars; Comments; Adding pictures; Macros; Editing a macro; Adding buttons; Summary. Index