• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Preface > Organization of This Book

Organization of This Book

Excel 2000 in a Nutshell is structured in four parts:

Part I

Excel 2000 Overview covers the basic features and functionality of Excel.

Chapter 1 provides a quick reference to the basics of Excel. The chapter is designed around a Task List that provides a function list of the capabilities of Excel.

Chapter 2 provides an in-depth look at the Excel environment and how to customize menus and toolbars to meet your own needs.

Part II

Part II provides an in-depth look at each Excel menu. The chapters are organized by menu commands. The chapters not only tell you what each command does, but they provide a reason for why you might want to use them.

Chapter 3 describes the menu commands available for creating, saving, printing, and sending workbooks.

Chapter 4 describes the menu commands available for moving, locating, and modifying the contents of your worksheet.

Chapter 5 describes the menu commands available for changing the way your worksheet looks on the screen and when it prints.

Chapter 6 describes the menu commands available for adding things to you worksheet such as functions, charts, and objects. This menu also provides commands for adding additional cells to the worksheet.

Chapter 7 describes the menu commands available for formatting the contents of the worksheet.

Chapter 8 describes the menu commands available for checking spelling, correcting errors, merging workbooks, creating macros, and customizing your environment.

Chapter 9 describes the menu commands available for analyzing data within your worksheet.

Chapter 10 describes the menu commands available for modifying a selected chart.

Part III

This part goes beyond the typical list of Excel functions by providing detailed descriptions of the functions available within Excel, along with examples of how to use them. The chapters are organized alphabetically by function, and cover not only the functions that come installed with Excel, but also the functions that are added when loading the Analysis ToolPak add-in.

Chapter 11 provides a stepping stone for the remaining function chapters by describing how functions are used to create formulas.

Chapter 12 describes the functions provided for working with financial data.

Chapter 13 describes the functions provided for creating and manipulating dates and times.

Chapter 14 describes the functions provided for performing mathematical and trigonometrical functions.

Chapter 15 describes the functions provided for summarizing data and performing basic statistical tasks.

Chapter 16 describes the functions available for looking up and referencing specific values within your workbook.

Chapter 17 describes the functions provided for working with database tables (lists).

Chapter 18 describes the functions available for converting and manipulating text values within your worksheet.

Chapter 19 describes the six different functions that allow you to return a logical value based upon the results of a condition.

Chapter 20 describes the functions provided to gather specific information about your worksheet and the computer system you are working on.

Part IV

This section includes quick-reference lists.

Appendix A is a comprehensive reference to Excel's keyboard shortcuts.

Appendix B is a complete list of all the tips included in the book.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint