Publisher: O'Reilly Media Released: August 2000 Pages: 608
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. |
-
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
-
Menu Reference -
Chapter 3 File - Microsoft Excel Files
-
Chapter 4 Edit - Windows Clipboard Versus Office Clipboard
-
Chapter 5 View -
Chapter 6 Insert - Insert → Cells
- Insert → Rows
- Insert → Columns
- Insert → Worksheet
- Insert → Chart
- Insert → Page Break
- Insert → Function
- Insert → Name
- Insert → Comment
- Insert → Picture
- Insert → Object
- Insert → Hyperlink
- Some Hyperlink Tips
-
Chapter 7 Format -
Chapter 8 Tools -
Chapter 9 Data -
Chapter 10 Chart - Column Charts
-
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
-
Appendices -
Appendix Keyboard Shortcuts -
Appendix Tip Reference -
Colophon |
- Title:
- Excel 2000 in a Nutshell
- By:
- Jinjer Simon
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Safari Books Online
- Print:
- August 2000
- Pages:
- 608
- Print ISBN:
- 978-1-56592-714-8
- | ISBN 10:
- 1-56592-714-1
|
-
Jinjer Simon 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. View Jinjer Simon's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Excel 2000 in a Nutshell is a Northern Gannet (Sula bassanus). The Northern Gannet is the largest seabird breeding in North American waters. It feeds primarily on surface-dwelling fish such as herring and makerel, which are taken from diving from heights up to 43 meters and plummeting into the water with great speed and force. The bird enters the water head first and swallows its prey whole. The bird's skull is incredibly strong, and a system of air sacs also helps to absorb the shock of these plunges. Northern Gannets take their winters at sea, from southern Virginia to Florida, and return north the remainder of the year. The Northern Gannet's nests are found on steep cliffs on Canada's and the United States' east coast. The nests are made of vegetation, seaweed, feathers, and earth, and may be cemented together with guano. The Northern Gannet produces a single egg, which incubates for 44 days. After 90 days, the chick is ready to leave the nest and search for its own food. Maureen Dempsey was the production editor, and Clairemarie Fisher O'Leary was the copyeditor, for Excel 2000 in a Nutshell. Sarah Jane Shangraw provided quality control. Brenda Miller wrote the index. Hanna Dyer designed the cover of this book, based on a series design by Edie Freedman. The cover image is an original illustration created by Lorrie LeJeune. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. Alicia Cech and David Futato designed the interior layout based on a series design by Nancy Priest. Mike Sierra implemented the design in FrameMaker 5.5. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were produced by Robert Romano and Rhon Porter using Macromedia FreeHand 8 and Adobe Photoshop 5. This colophon was written by Maureen Dempsey. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Rich Bowen
February 2007
By Joan Stigliani
October 1995
By J.D. Biersdorfer
October 2009
|
Customer Reviews
|
|
|