Microsoft Office Tutorials and References
In Depth Information
A few assumptions
Section 14, “Sharing Excel data with other programs,” and
Section 15, “Using Excel in a group environment,” are all about
sharing the data in your Excel worksheets—whether it’s with
your colleagues, on the Internet, or with other programs.
Section 14 shows you how to make Excel 2013 interact with other
Microsoft Office 2013 programs, such as by embedding
documents from other programs in your Excel workbooks,
exchanging data between Excel and Word, or importing a text file into
an Excel worksheet. In Section 15, you’ll learn how to use Excel
A few assumptions
I had to make a few educated guesses about you, my audience,
when I started writing this topic. Perhaps you just use Excel for
personal reasons, tracking your household budget, doing some
financial planning, or recording your times for weekend bike
races. Maybe you run a small, home-based business, or you’re
an employee of a corporation where you use Excel to analyze
and present sales or production data. Taking all these
possibilities into account, I assumed that you need to know how to
create and work with Excel workbooks and worksheets,
summarize your data in a variety of ways, format your documents
so that they’re easy to read, and then print the results or share
them over the web or distribute your data both ways.
Another assumption I made is that—initially, anyway—you use
Excel 2013 just as it came, meaning that you’d be working with
the standard user interface. I’ve written the procedures and
captured the graphics throughout this topic based on the Excel
2013 user interface as it was installed on my computer.
Adapting task procedures for
In this topic, we provide instructions based on traditional
keyboard and mouse input methods. If you’re using Excel on a
touch-enabled device, you might be giving commands by
tapping with your finger or with a stylus. If so, substitute a tapping
action any time we instruct you to click a user interface element.
Also note that when we tell you to enter information in Excel,
you can do so by typing on a keyboard, tapping in the entry
field under discussion to display, and using the onscreen
keyboard, or even speaking aloud, depending on your computer
setup and your personal preferences.
in a group environment, to add comments to your worksheets,
and to accept or reject the comments made by others. You’ll
also learn how to publish a worksheet to the web as well as
how to pull information from the Internet directly into your
worksheets and to share and edit your workbooks using Excel
Web App. This section also introduces XML (an abbreviation for
Extensible Markup Language), a handy technology that enables
you to exchange data between spreadsheet applications.