Using Excel in a Workgroup

Table of Contents

This Book

Special Edition Using Microsoft® Office 2000

Search

About the Authors

Special Thanks To

Acknowledgments

Tell Us What You Think!

Introduction

Pt. I. Common Tasks

Pt. II. Office and the Web

Pt. III. Using Word

Pt. IV. Using Excel

Ch. 19. Excel Essentials

Ch. 20. Advanced Worksheet Formatting

Ch. 21. Using Formulas and Functions

Ch. 22. Creating and Editing Charts

Ch. 23. Working with Lists and Databases

Ch. 24. Using Excel in a Workgroup

Protecting a Worksheet

Sharing a Workbook

Storing Multiple Scenarios in a Single Workbook

Consolidating Data from Multiple Users into a Single Workbook

Creating Custom Views of Worksheet Data

Troubleshooting

Secrets of the Office Masters: Managing Scenarios

Ch. 25. Using PivotTables and PivotCharts

Ch. 26. Error-Proof Data-Entry Techniques

Pt. V. Using Outlook

Pt. VI. Using PowerPoint

Pt. VII. Using Access

Pt. VIII. Using Publisher

Pt. IX. Using FrontPage and PhotoDraw

Pt. X. Automating Office with Macros and VBA

Pt. XI. Appendixes

Index

Chapter 24. Using Excel in a Workgroup

In this chapter

Protecting a Worksheet
Sharing a Workbook
Storing Multiple Scenarios in a Single Workbook
Consolidating Data from Multiple Users into a Single Workbook
Creating Custom Views of Worksheet Data
Troubleshooting
Secrets of the Office Masters: Managing Scenarios

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Part IV: Using Excel > Using Excel in a Workgroup

Chapter 24. Using Excel in a Workgroup