Excel 2000 In Easy Steps (In Easy Steps Series) - Softcover

Copestake, Stephen

Softcover

ISBN 10: 1840780355 ISBN 13: 9781840780352

Publisher: Computer Step, 1999

Synopsis

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.

About this title

Review

Whilst the brand new version of Microsoft's Excel isn't radically different from its predecessors, there are enough new features and tweaks to make it a worthwhile upgrade for serious users.

The ever reliable In Easy Steps series are quick off the mark with this comprehensive quick start guide for those not familiar with the program.

As we have come to expect from this superb series, the layout is clear, concise and very easy to follow with a whole host of step by step examples and mini- tutorials.

Starting with the basics of cell creation and applying basic formulae, the book goes on to detail more complex functions such as error tracking and the use of the powerful pivot tables.

There's also some interesting information for integrating your spreadsheets with Intranet and Internet sites too, allowing the user to fully realise the potential of the program's web integration options.

Businesses tend to rely on Excel a great deal these days so any book that makes the learning process a bit easier for wary and less computer literate employees is always welcome. Another excellent addition to this great series. --Steve Russell

From the Publisher

Stephen Copestake is an established author and has written over fifteen in easy steps books, including Excel in easy steps and Office 2000 in easy steps. This guide is suitable for self-teaching as well as classroom based training.

Edition details

• Publisher: Computer Step
• Publication date: 1999
• ISBN 10: 1840780355
• ISBN 13: 9781840780352
• Binding: Paperback
• Language: English
• Number of pages: 192