Excel 2000 in a Nutshell: A Power User's Quick Reference
Jinjer L. Simon · CERN Document Server (European Organization for Nuclear Research) · 2000
From the Publisher: Excel 2000 in a offers a feature-based reference that provides detailed information about each menu option and function. This book is organized around the program's features, making information easier for the end-user to locate quickly. By virtue of the estimated 20 million-strong install base of Microsoft Office users, Excel has become the de facto standard for spreadsheet applications. Excel 2000 in a is written with intermediate to advanced Excel 2000 power users in mind. It assumes a certain level of experience and is organized in the typical a Nutshell reference style where users can quickly and easily find what they need to know about a particular feature without having to spend extra time searching the index. This book is divided into three main sections. The first part of the book introduces Excel basics such as creating and formatting worksheets and formulas as well as information on the new features particular to Excel 2000. There is also a chapter on the anatomy of Excel, which breaks down everything from a cell to the toolbar. The second part of the book details every Excel Menu option, from the Chart Menu to the File Menu to the Tools Menu. In this section you'll find handy tips to help you better power-use the many options available in Excel 2000. The third part of the book is the Functions section. It provides an easy and accessible grouping of available Excel Functions by category, including Financial, Date and Time, Statistical, and Database Functions. Some of the topics covered 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; and information on the many functions included in the Analysis ToolPak that comes with Excel 2000. Excel 2000 in a is a one-stop reference for the professional and consumer Excel user. In typical fashion, information is organized for quick and easy access, providing readers with everything they need to know about the premier spreadsheet application.