Perspection, Inc. Staff

Microsoft Press visual paperback copy excel at a glance

Heavy Paperback (2 to 4 lbs)

Computer Science

Targeted to beginning to intermediate users, this "At a Glance" book provides a low-priced visual reference for users who want to turn to software books to solve specific problems and who want just the information they need when they need it. Straightforward, concise writing and the task-oriented format will help readers to find the information quickly. COVER TITLE

Microsoft Excel 97 at a Glance

8abc09f3-a2c8-4bd9-ba75-89ae44ebd79c-0

Steven Roman

Developing Macros to Automate and Customize Excel

A guide to the fundamentals of streamlining the Microsoft spreadsheet software using Visual Basic for Applications. Roman says he hates books full of humorous anecdotes, so if you want to hear his favorite jokes, come over some night and bring the beer. The book, on the other hand, should get users to the level at which they do not depend on any resource but the help file and maybe a good reference on Excel. He does not include a bibliography. Annotation copyrighted by Book News, Inc., Portland, OR

Writing Excel Macros

8c88f44c-1d80-4205-abdf-c61c09571eb3-1

John Walkenbach

Everything you need to know about * Mastering operators, error values, naming techniques, and absolute versus relative references * Debugging formulas and using the auditing tools * Importing and exporting XML files and mapping the data to specific cells * Using Excel 2003's rights management feature * Working magic with array formulas * Developing custom formulas to produce the results you need Here's the formula for Excel excellence Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel's capacity. CD-ROM Includes * Trial version of the author's award-winning Power Utility Pak 5 * More than 90 sample workbooks illustrating key formula concepts

Zoe

@zoe23404

Books Listed

Following

Followers

Perspection, Inc. Staff

Microsoft Excel 97 at a Glance

Steven Roman

Writing Excel Macros

John Walkenbach

Excel 2003 Formulas

Get The App

Browse by categories

Perspection, Inc. Staff

Microsoft Excel 97 at a Glance

Steven Roman

Writing Excel Macros

John Walkenbach

Excel 2003 Formulas

Get The App