Microsoft Office Tutorials and References
In Depth Information
Adding Tables to Slides
Adding Tables to
Up to speed
OLE (pronounced oh-lay ) may bring to mind dashing
toreadors, swirling capes, and charging bulls, but the reality is a
bit more prosaic—and a lot more useful to your PowerPoint
presentations. OLE stands for object linking and
embedding, and it’s a way to make two programs work together
to share information.
Excel, embed the worksheet in a PowerPoint slide, and then
link the embedded worksheet to its Excel version, you can
update the linked file to reflect any changes made to it in
Excel. That way you can be sure that your presentation has
OLE is useful when you want to take advantage of the power
of other Office programs as you work in PowerPoint, such
as using a complex Excel formula on spreadsheet data. It’s
also great for making sure that your linked files stay up to
date, so you know you’re presenting the very latest sales
data, for example. But OLE does have some limitations.
Embedding a file in a slide can increase a presentation’s
size dramatically. And moving a file you’ve linked to, or
emailing someone a copy of the presentation, breaks any
links. Still, OLE is a handy tool to have in your PowerPoint
toolbox, letting you work with a program-within-a-program.
Embedding a file in a PowerPoint slide is like opening a
version of a different program from inside PowerPoint. When
you click an embedded Word document, for example, you
no longer see the PowerPoint ribbon at the top of your
screen; instead, you see the Word tabs and buttons you
need to work with a document. When you click outside the
embedded file, the PowerPoint ribbon returns.
Linking goes one step beyond embedding by keeping your
embedded file in sync with a version of the same file that
lives in another program. So if you create a worksheet in
Note: OLE works in other programs besides PowerPoint. Word, Excel, Outlook, and Publisher all let you
embed objects from the Insert tab. Select Insert➝Object (Alt, N, J) to begin.
Adding Tables to Slides
Tables are a good visual for slides because they present a lot of information in a
compact space. PowerPoint automatically formats tables according to your
presentation’s theme, so their color scheme, style, and fonts fit perfectly with other slides. (Of
course, you can adjust the formatting if you like.)
Working with tables in PowerPoint is much like working with them in Word (see
page 81 for the full story). This section focuses on the key differences.
Inserting a Table
PowerPoint gives you several different ways to put a table on a slide. Read on to see
Note: In PowerPoint, unlike Word, you can’t start with data and then convert your text to a table.