Microsoft Office Tutorials and References
In Depth Information
Section 15: Using Excel in a group environment
group environment 15
Using Excel in a
In this section:
E ven though single individuals might be in charge of managing a
comSharing workbooks in Excel
pany’s financial data and related information, there is usually a group
of folks who either enter data into workbooks or have input into future
revenue or growth projections. You and your colleagues can add
comments to workbooks to describe their contents and to offer insights into
how certain values are derived. If you and your colleagues need to open
or edit a workbook at the same time but from different computers, you
can turn on workbook sharing so that more than one person can have the
workbook open at a time. You can view any changes that your colleagues
make and then accept or reject those changes to produce a final version of
a workbook.
Commenting in cells
Tracking changes in workbooks
Accepting or rejecting changes
Saving worksheets to the web
Dynamically updating worksheets
published to the web
Retrieving web data from Excel
Modifying web queries
Microsoft Excel 2013 also takes full advantage of XML (the Extensible
Markup Language). XML is a content markup language, meaning that an
XML file has information about the data contained within it, not just how
the data should be displayed. Not only is the Excel 2013 file format based
on XML, but you can also save your Excel workbooks as
StrictOpenXMLSpreadsheet files, which means that your Excel data can be read by a wide
range of programs, not just those programs listed in the Save As dialog
box’s Save As Type drop-down list.
Interacting over the web with XML
Saving data to the cloud using SkyDrive
Editing a workbook in the Excel Web
Sharing Excel workbooks on the web
Sharing a Worksheet online using Lync
Search JabSto ::

Custom Search