Running Excel 2000

Mark Dodge, Craig Stinson

994 pages, parution le 26/03/2002

Ajouter à une liste

Indisponible

Résumé

Running Microsoft Excel 2000 is packed with everything from quick, clear instructions for new users to advanced answers for experienced users. Complete in one volume, the book takes you through the most-used tasks and functions of Microsoft's popular spreadsheet program. In short, this is the authoritative handbook you'll keep by your computer and use every day.

Get new information on topics ranging from creating and managing worksheets and incorporating external data, to using pivot tables and working with VBA-plus much more:

Comprehensive

Learn to create Web pages with Excel 2000
Discover how to collaborate with others almost anywhere using Microsoft Excel, workgroups, and the Internet
Gain Insight into using Microsoft Excel 2000 as a component within Microsoft Office 2000

Contains easy Access to Information

"Chapter at a Glance" for quick reference
Master table of contents
Extensive cross-referenced index
Two-color interior for easier navigation

Everything is Clear

Step-by-step instructions
Hundreds of screen illustrations
Real-world examples
Tips and advice from the experts

Contents

Part I: Getting Started with Microsoft Excel 2000 1; Chapter 1: Getting Your Bearings 3
Chapter 2: Getting Help 23
Chapter 3: Toolbars and Menus 37
Chapter 4: Managing Files 61
Part II: Worksheets 91: Chapter 5: Worksheet Basics 93
Chapter 6: Building Formulas 115
Chapter 7: Formatting a Worksheet 155
Chapter 8: Editing a Worksheet 233
Chapter 9: Worksheets and Windows 299
Chapter 10: Graphics 345
Chapter 11: Printing and Presenting 389
Part III: Analyzing Data 409: Chapter 12: Common Worksheet Functions 411
Chapter 13: Dates and Times 459
Chapter 14: Financial Analysis 479
Chapter 15: Statistical Analysis 501
Chapter 16: What-If Analysis 535
Part IV: Interfacing with the Rest of the World 571: Chapter 17: Integrating Applications with OLE 573
Chapter 18: Sharing Files with Others 583
Chapter 19: Hyperlinks and the Internet 603
Chapter 20: Creating Web Pages with Excel 629
Part V: Charts 649: Chapter 21: Basic Charting Techniques 651
Chapter 22: Changing the Appearance of Your Charts 667
Chapter 23: Working with Chart Data 711
Chapter 24: Mapping Geographic Data 723
Part VI: Database and List Management 745: Chapter 25: Managing Information in Lists 747
Chapter 26: Working with External Data 787
Chapter 27: Using PivotTables 835
Part VII: Macros and Visual Basic 877: Chapter 28: Creating Macros 879
Chapter 29: Custom Functions 901
Chapter 30: A Sample Visual Basic Application 915
Index 945

L'auteur - Craig Stinson

Craig Stinson has been writing about computers since 1981. He is a columnist for PC Magazine the best-selling author of several editions of Running Microsoft Windows, and co-author of Running Microsoft Windows NT and Running Microsoft Excel.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Mark Dodge, Craig Stinson
Parution	26/03/2002
Nb. de pages	994
Format	19 x 23,5
Couverture	Broché
Poids	1545g
Intérieur	2 couleurs
EAN13	9781572319356
ISBN13	978-1-57231-935-6