Excel 97 Secrets® - Softcover

Burns, Partick; Barrows, Alison

Softcover

ISBN 10: 0764530445 ISBN 13: 9780764530449

Publisher: John Wiley & Sons, 1997

Synopsis

With Excel firmly established as the most popular and powerful spreadsheet program around, you might expect Microsoft to slack off a bit. Excel 97 Secrets, however, proves that the folks up in Redmond have not been idle. In this in–depth guide to Excel 97′s most advanced features—including many not covered in the official documentation—Excel know–it–alls Patrick J. Burns and Alison Barrows reveal tips and techniques to boost you right to the top of the learning curve.

With Excel 97 Secrets, you get up to speed quickly no matter which earlier version you′ve been using. Burns and Barrows orient you and provide clear explanations and practical examples of how to

• Take advantage of 16 levels of undo (if only life were so easy…)
• Publish worksheets and workbooks on the World Wide Web, for everyone on the Internet to see or for only your workgroup or organization to see
• Use enhanced PivotTables (they′re not only more powerful now, but also they′re easier to use)
• Enjoy near–WYSIWYG editing
• Run queries in the background
• Build formulas using more natural labels rather than abstract cell addresses
• Share workbooks with your workgroup—and cobble together budgets and proposals more easily than ever before
• Increase productivity by automating tasks with Visual Basic for Applications

Plus, Excel 97 Secrets comes complete with a CD–ROM packed with outstanding shareware, freeware, demos, and VBA programming utilities.

About this title

Synopsis

An intermediate/advanced-level guide to using the Excel 97 spreadsheet package in connection with other software applications, including the Internet/intranets, designing templates and using graphics. The enclosed CD-ROM works through the examples presented in the book and demonstrates new utilities and worksheet functions for more advanced users.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 1997
• Language: English
• ISBN 10: 0764530445
• ISBN 13: 9780764530449
• Binding: Paperback
• Number of pages: 792