Chapter 11. Sharing a Worksheet with Excel

What You’ll Do

Lock and Unlock Worksheet Cells

Protect Worksheets and Workbooks

Share Workbooks

Create and Read a Cell Comment

Edit and Delete a Cell Comment

Track Changes

Compare and Merge Workbooks

Ask “What If” with Goal Seek

Create Scenarios

Export Data

Analyze Data Using PivotTable

Consolidate Data

Link Data

Get Query Data from a Database

Get Query Data from the Web

Get Data from a FileMaker Pro Database

Get Text Data

Introduction

Creating successful documents is not always a solitary venture; you may need to share a document with others or get data from other programs before a project is complete. In Microsoft Excel, you have several methods that you can use to create a joint effort. ...

Get Office 2008 for the Mac on Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.