158 Pages
by
Routledge
158 Pages
by
Routledge
If you:
* need to process information quickly and accurately
* want to produce professional looking reports and presentations
* want to produce spreadsheets, charts and graphs
* need a self-teaching approach
then Excel 97 for Windows Made Simple is for you!
By a combination of tutorial approach, with tasks to do and easy steps, the MADE SIMPLE series of Computer Books from British publisher Butterworth-Heinemann, using British authors and designed for a European audience, stands above all others.
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
Biography
Stephen Morris