Excel 97 for Windows Made Simple

ISBN-13: 9780750638029 / Angielski / Miękka / 1997 / 158 str.

Stephen Morris

Opis

A guide to the basics of Microsoft's Excel spreadsheet software package. Presented in the style of other Made Simple titles, the book aims to be easy to follow, free of unnecessary jargon and has numerous practical examples.

Spis treści

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

O autorze

Stephen Morris