Research Catalog

Advanced spreadsheet design using Lotus macros

Filter by

Item details
Status	Vol/Date	Format	Access	Call Number	Item Location
Request for On-site Use Request Scan How do I pick up this item and when will it be ready?	book	Text	Request in advance	HF5548.4.L67 T48 1994 book	Off-site
Request for On-site Use Request Scan How do I pick up this item and when will it be ready?	computer disk (3 1/2 in.)	Text	Request in advance	HF5548.4.L67 T48 1994 computer disk (3 1/2 in.)	Off-site

Description

xiv, 316 pages : illustrations; 23 cm +

Alternative Title

Using Lotus macros

Subjects

Note

System Details (note)

Contents

Pt. I. Introduction to Spreadsheet Design - A Simple Budget Example. 1. Spreadsheets - A Problem-Solving Tool. 2. Qualities of Good Spreadsheet Design. 3. Problem Analysis and the Input-Processing-Output Model. 4. Worksheet Layout and Documentation. 5. Writing and Designing Basic Macro Commands and Functions. 6. Writing Simple Macro Menus. 7. Audit Controls for Spreadsheets -- Pt. II. Spreadsheet Template Design - A Master Budget Example. 8. Spreadsheet Template Design. 9. Macros for Data Entry in Templates. 10. Macro Menu Design. 11. Structured Macro Design. 12. Documenting, Testing, and Auditing the Master Budget Template -- Pt. III. Spreadsheet Database Applications. 13. Database Applications Using Spreadsheets. 14. Database Design for Spreadsheets. 15. Database Processing with Spreadsheets. 16. Data Entry Macros for Database. 17. Output Macros for Spreadsheet Database Applications. 18. Documenting, Testing, and Auditing Spreadsheet Database Applications.
App. A: Lotus Macro Commands -- App. B: Lotus Functions -- App. C: Macro Library Manager -- App. D: Design Guidelines and Forms -- App. E: Lotus for Windows: Macro Commands.

ISBN

0878358617

LCCN

92024214

OCLC

ocm26258162

Owning Institutions

Columbia University Libraries