Excel 2000 in a Nutshell

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, and Excel 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.

Preface
Microsoft Office 2000 Service Releases

Part 1. Excel 2000 Overview

Chapter 1. Excel Basics
Installing Excel 2000
Opening Excel
Excel Menus and Shortcuts

Chapter 2. Excel Anatomy
The Excel Window
The External Side of Excel
Using Styles
Customizing in Excel

Part 2. Menu Reference

Chapter 3. File
Microsoft Excel Files

Chapter 4. Edit
Windows Clipboard Versus Office Clipboard

Chapter 5. View

Chapter 6. Insert

Chapter 7. Format

Chapter 8. Tools

Chapter 9. Data

Chapter 10. Chart

Part 3. Function Reference

Chapter 11. Working with Functions
Function or Formula?
Function Categories
Function Arguments
Inserting a Function

Chapter 12. Financial Functions
Understanding the Financial Jargon
The Financial Functions

Chapter 13. Date and Time Functions
How Excel Stores Dates and Times

Chapter 14. Mathematics and Trigonometry Functions
Understanding Math Lingo

Chapter 15. Statistical Functions
Common Statistical Terminology
The Statistical Functions

Chapter 16. Lookup and Reference Functions
The Lookup and Reference Functions

Chapter 17. Database Functions
The Database Functions

Chapter 18. Text Functions
The Text Functions

Chapter 19. Logical Functions
The Logical Functions

Chapter 20. Information Functions
The Information Functions

Part 4. Appendices

Appendix A. Keyboard Shortcuts

Appendix B. Tip Reference

Index