Search

Evaluates Microsoft Office 2000 to determine whether businesses should consider upgrading from earlier versions of Microsoft Corp.'s productivity suite. Programs included in the suite including Microsoft Word, Excel, Access, Frontpage, Powerpoint, Publisher, Photodraw and Programming Tools; Features; Enhancements; Recommendations. INSETS: Passing Judgment;Compatibility Conundrum;Fight or Switch?;Teamwork Tools

Evaluates Borland Office 2.0, Lotus SmartSuite 2.1 and Microsoft Office 4 Professional. Cost; Integration; Economical use of resources; Ease-of-usage and ease-of-learning; Customizability and automation; Information-sharing among users; Ease of installation. INSETS: Application rundown: Borland Office 2.0.;Application rundown: Microsoft Office 4.;Buying in bulk: Software isn't the issue, by Bronwyn Fryer..

Discusses `PC World' magazine's evaluation of electronic spreadsheets for Windows. Lotus 1-2-3 4.01; Microsoft Excel 5.0; Quattro Pro 5.0; Similarity of features between competing spreadsheets; Usability; Analysis options; Formatting; Data access and manipulation; Customization; Comparison of performance. INSETS: Best buys.;DOS spreadsheets: Not dead yet..

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)..

Evaluates Quattro Pro for Windows and Quattro Pro for DOS from Borland International Inc. Use of `Infoworld' magazine's task-oriented scoring criteria; Features; Performance; Documentation; Support; Value. INSETS: Quattro Pro for Windows.;Quattro Pro for DOS..

Evaluates Lotus Development Corp.'s spreadsheet software 1-2-3, Release 4 for Windows. Benchmarks; Criteria. INSET: InfoWorld buyers assurance seals..

Features Lotus Development Corp.'s Lotus SmartSuite 2.1. Applications included; Ami Pro 3.01; 1-2-3 release 4.0 for Windows; Approach 2.1 for Windows; Freelance Graphics 2.01; Organizer 1.1.

Lists tips for enhancing the performance of 1-2-3 for Windows. Virtual disk; Permanent swap file; Hard disk clean-up; Closing up applications; High-priority printing; Operating systems and environments; Memory; Graphics accelerator; Math coprocessor; Video drivers.

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 information on computer spreadsheet programs. How to prevent Microsoft's Excel program from confusing fractions with dates; How to express fractions in terms other than the most reduced; How to produce a chart unlinked from its data range.

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..

Discusses an add-in for Microsoft Excel 97 called Extended Date Functions that deals with the year 2000 problem. The date problem that exists with Excel; Explanation of the functions that were developed to deal with the problem; Where users can get a free copy from PC World Online.

Gives advice on computer spreadsheets. Text imports; Hyperlink deactivation in Microsoft Excel 2000; Useful circular references in Lotus 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.

Discusses how to duplicate values in a Microsoft Excel list. Sharing shortcuts for the spreadsheet software; How to share AutoCorrect entries with colleagues. INSET: Copy Page Setup.

Presents steps to be taken in order to display the auto filter criteria in Excel programs. How Excel software does not always identify criteria being used in a specific program; How to rank data in Excel software.

Discusses several counting techniques for Microsoft Excel, Microsoft Corp.'s spreadsheet program. Conditional counting; Enumerating with data; Counting with arrays; Pivot tables.

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.

Discusses how to calculate the difference between two dates in Microsoft Excel. Excel's Datedif function being identical to Lotus 1-2-3's Datedif function. INSET: Use dummy arguments in Excel.

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.

Discusses a variety of solutions for readers of `PC World' magazine that are using Microsoft Excel. INSET: Join text from multiple cells.

Presents information on using spreadsheets. How to create charts directly in a worksheet range using formulas; A better way to see the actual formulas rather than their resulting values in Excel; How to hide sensitive cells; Other information.

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.

Offers tips on using spreadsheet software. Creating Gantt charts in Excel; Counting words in a cell; Shrinking 1-2-3 release 97's InfoBox.

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.

Features Lotus Development Corp.'s SmartSuite 3.0. Integration of Lotus' collection of desktop applications; Pricing; Contact information.

Reports on the desktop publishing program PerForm Pro Plus from Delrina Technology. Comparison with typical form packages; Design features and tools; Information storage; Fax capability; Database file formats; Object libraries; Applications; Additional modules. INSET: PerForm Pro Plus (features and contact information)..

Discusses the features of the new Wyse Decision 386/40 high-performance PC. Speed advantages 40-MHz 386 systems have over 486SX systems; Wyse Decision built around the AMD chip; Motherboard features; Making a bus switch to improve performance; Expansion capabilities; Prices of three configurations of the Decision 386/40.

Looks at the features of Tandy's new 2500 SX/25PC desktop system. Price; Bundled software; Memory; Expansion possibilities; Video support; Audio capabilities; Support.

Reviews Doceo Publishing Incorporated's Video Compression Sampler version 3.0 and Lifeboat Publishing's Dan Bricklin's demo-it version 2.0. Products features; Cost of products.

Reviews the computer software Lucid 3-D for Windows from Lucid Corp.

Evaluates the performance of Microsoft Corp.'s Excel 5.0. Menus, three-dimensional file format and macro language; Similarity between Excel 5 and Word for Windows 6.0; Excel 5.0's automation of tedious tasks; PivotTable feature; Visual Basic for Applications; Other enhancements; Downsides.

Evaluates Sheridan Software Systems Inc.'s VBAssist 3.0 programming tool. Features; Price.

Rates Symantec Corp.'s Norton Commander 4.0 software. Performance of common file operations using function keys or pull-down menus; Ability to be customized; Addition of block commands; Price; Contact information.

Reviews Microsoft's Office XP suite software. Discussion of whether to upgrade an office suite with Office XP; Comparison of the versions and the applications, which includes Word 2002 with voice recognition technology; Features, including Disaster Recovery, smart tags, and product activation wizard; Price. INSET: How Office's Rivals Stack Up, ' by Harry McCracken.