Excel 97 Secrets

by Pat Burns and John Nicholson

Published 3 June 1997
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 seeUse enhanced PivotTables (they're not only more powerful now, but also they're easier to use)Enjoy near-WYSIWYG editingRun queries in the backgroundBuild formulas using more natural labels rather than abstract cell addressesShare workbooks with your workgroup--and cobble together budgets and proposals more easily than ever beforeIncrease 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.


Excel for Windows '95 Secrets

by Pat Burns

Published 10 June 1996
Get expert advice for maximizing the power of Excel for Windows 95 in this hot Secrets title! Let an Excel guru uncover what Microsoft didn't or won't tell you about its spreadsheet program. You'll learn how to supercharge the powerful database and report generating functions, create custom utilities, and master the popular Visual Basic for Applications.