Excel 2000 illustrated in easy steps

Excel 2000 in easy steps is a concise guide to the 2000 version of Microsoft's Excel spreadsheet package. Written by Stephen Copestake, author of Excel in easy steps, this book follows the familiar in easy steps format with step-by-step instructions and clear screen shot annotations.

It begins with an introduction to the Excel 2000 screen and explains how to work with the toolbars, perform automatic customisation, key in data, move around in worksheets, switch between worksheets, use the HELP system and Office Assistant and also covers basic spreadsheet terminology. The next chapter covers worksheet basics including planning layout, data types, modifying existing data, AutoComplete, AutoFill, AutoCorrect, number formats, data validation, inserting a formula, What-If tests, amending row and column sizes, and inserting cells, rows and columns.

Chapter 3 looks at copy and move techniques. The reader is taught how to copy and move cells, Collect and Paste, perform external copy/move operations, enter data automatically, move worksheets and copy data from Internet Explorer. Then the book looks at Workbook management from creating and saving new workbooks to saving workbooks as templates or to the Web. It covers interactive and non-interactive saving in addition to other save operations, opening workbooks, reopening HTML files, using workspaces and closing workbooks.
Chapter 5 teaches the reader how to define cell references. The reader learns how to apply relative and absolute references, use R1C1 referencing, name cells and also delete existing names, substitute names into formulae and paste names into formulae via the Formula Bar. The following chapter covers functions. Here the reader is taught how to insert functions into formulae, and the SUM, LOOKUP, IF and HYPERLINK function are all looked at in some detail.
Next, the book looks at common error messages which arise when Excel 2000 is unable to evaluate a formula. It is explained how to use the auditing tools and Error Tracer, and also work with comments in cells. Then, workbook security is covered with instruction on allocating passwords to workbooks, opening protected workbooks, protecting workbook structure and protecting cells.
Further areas covered are: data analysis, including Goal Seek, one-variable and two-variable tables, What-If scenarios and PivotTables; creating lists and databases in Excel 2000 worksheets; working with multiple worksheets and workbooks; formatting worksheets; printing worksheets; creating and inserting charts and graphics; and finally, using macros.
Covering all the essential features of Excel 2000, and written in concise language, this book is ideal for users with no previous experience of spreadsheets. With handy tips, and step-by-step instructions, this book is equally suitable for users updating from a previous version of this, or another, spreadsheet package, and with an extensive index it is also suitable for current users who require an easy to follow reference guide.