Search

Evaluates three Windows spreadsheet products. Borland's Quattro Pro for Windows 5.0; Lotus 1-2-3 Release 4.01 for Windows; Microsoft Excel 5.0 for Windows; Prices; Criteria for performance; Installation and configuration; Basic operations; Data manipulation and reporting; Macro programmability; Network access; Documentation; Support. INSETS: How we test Windows spreadsheets.;Executive summary (performance of four spreadsheets)..

Presents advice for computer spreadsheets. Information on chart layouts on Microsoft Excel; How to use formulas to restrict cursor movement to unprotected cells on a worksheet.

Offers advice on using spreadsheets in Microsoft Excel. How to display multiple charts on a single chart sheet; Information on displaying a name for a worksheet; Explanation of conditional formatting features, including colors; Elimination of extra worksheets from a workbook.

Offers tips and ideas for using spreadsheet software. How to round a dollar amount to the nearest 25 cents in Microsoft Excel; How to change the format of cell comments; How to use Excel's AutoSave feature. INSET: Zap Input Cells, Keep Formulas.

Focuses issues concerning spreadsheets. Saving spreadsheets into HTML format for use on the World Wide Web; Displaying thousands without the use of zeros; Using subtotals in Microsoft Excel. INSET: Adjust Subtotal Formatting.

Offers advice on ways to perform math operations in computer spreadsheets without formulas. Steps taken in Excel; Ways to look up figures in spreadsheets.

Offers tips on the use of the Microsoft Excel software program to create spreadsheets. Options for protecting data in Excel 97 and 2000; Use of the AutoFiltering function. INSET: Activate cells used in formulas..

Explains how to use the Microsoft Excel program to make spreadsheets more interesting to look at. AutoShapes; Details of how to check for repeating values in a range; Use of the Data Validation feature. INSET: Print selected rows in 1-2-3..

Provides directions on how to create a time sheet in Microsoft Excel. Description of how the time sheet program works; Cumbersome nature of the program; Guidelines for adding and subtracting times in a spreadsheet.

Offers advice regarding the creation of computer spreadsheets. Formulae to use in Excel to create thermometer-style graphs; Calculating what day a particular date will fall on; Creating Automatic list numbering in Excel.

Offers spreadsheet tips for personal computer users. Identification and correction of potential date problems in Excel; Combination of text and values in a single cell; Creation of conditional averages. INSET: Create a Linked Picture.

Presents tips on using spreadsheets. Storing custom formats for Microsoft Excel templates; Navigating sheets in Excel; Limitations to the @Vlookup function in Lotus 1-2-3; Comparing ranges in Excel by using an array formula.

Presents tips for using spreadsheets. A formula which returns the contents of the last filled cell in a Microsoft Excel column; The @if function in Lotus 1-2-3; Converting imported values to actual values; The Laroux virus in Microsoft Excel.

Offers tips for using the Microsoft Excel spreadsheet program. How to sort cells in a range by color; How to center across a selection in Excel 97; How to move among dialog box controls without using the mouse; How to merge cells in Excel 97.

Offers advice for using spreadsheet software programs. How to put a spreadsheet on a company Web page; How to stop Excel files form opening automatically; Formula for counting words.

Offers advice for using spreadsheet programs. Getting a chart range to expand automatically; Simplifying subscript and superscript formatting.

Offers advice for spreadsheet programs. Protecting formulas and data in Excel by hiding them; Accessing useful spreadsheet frequently asked questions on the Internet; Moving sheets in 1-2-3 Lotus 97.

Provides information about using computer spreadsheet programs. How to get Microsoft Excel to return a blank value instead of zero; Formatting dates for the 21st century; Removing empty rows.

Offers tips for working in Excel spreadsheet computer programs. Dropping zeros form averages; Changing values without using formulas; Whether Excel has a bug.

Presents advice and answers related to computer spreadsheets. Updating links on Excel; Moving sheets in Lotus 1-2-3 97; Using Windows Character Map program.

Answers questions concerning spreadsheets on how to delete empty rows in one step, restore Excel 97 menus and bypass 1-2-3's splash screen.