Excel 2000 in a Nutshell: A Power User's Quick Reference - Softcover

Simon, Jinjer

Softcover

ISBN 10: 1565927141 ISBN 13: 9781565927148

Publisher: O'Reilly Media, 2000

Synopsis

By virtue of the estimated 20-million-strong installed base of Microsoft Office users, Excel has become the de facto standard for spreadsheet applications. A powerful application needs powerful documentation, andExcel 2000 in a Nutshell, a detailed reference to every one of Excel's menu options and functions, is the key to unlocking Excel's many capabilities. The book's feature-based format means users can find what they're looking for quickly without having to spend extra time searching the index.Written for intermediate and advanced users, this book is divided into three main sections. The first section introduces Excel basics, such as creating and formatting worksheets and formulas, and surveys the new features of Excel 2000. It also includes a chapter on the anatomy of Excel that dissects everything from cells to toolbars.The second section details each Excel Menu option, from the Chart Menu to the File Menu to the Tools Menu. This section is the place to find handy tips for accessing the full power of Excel 2000's many options.The third section deals with Excel Functions, organized in an easy and accessible grouping by categories such as Financial, Date and Time, Statistical, and Database Functions. Topics in this section include:

• How to use the NetWorkedDays function, which calculates workdays, to determine accrued vacation time
• Performing financial calculations to determine depreciation of an asset
• The many functions included in the Analysis ToolPak that comes with Excel 2000

Excel 2000 in a Nutshell is a one-stop reference to Excel for both professional and home users. In typical Nutshell fashion, information is organized for quick and easy access, providing readers with everything they need to know about the premier spreadsheet application.

About this title

About the Author

Jinjer Simon has been actively involved in the computer industry as a web site developer, end user trainer, and developer of online documentation for the past 15 years. She has written numerous books, including Visual Basic Scripting SuperBible from Waite Group Press, and Windows CE for Dummies from IDG Press. Jinjer lives in a suburb of Dallas, Texas, with her husband and two children. In her spare time she likes to play golf and scuba dive.

Review

'The great advantage of this book is that it has all the same information of bulky manuals, but in succinct, portable form - and with brilliant explanations and examples. The owner of a book like this has greater acces to some of the more obscure features and functions, and can quickly become an expert user of this comprehensive program. (9/10) PC Plus, May 2001

Edition details

• Publisher: O'Reilly Media
• Publication date: 2000
• ISBN 10: 1565927141
• ISBN 13: 9781565927148
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 606