 |
|
|
Do this on PowerPoint:mac
Excel in PowerPoint for Macintosh
by Jim Gordon, March 14th 2008
 About
James Gordon
James Gordon (pictured to the right) has been a Microsoft MVP (Most Valuable Professional)
since 2000 and can be found in the Microsoft Macintosh
newsgroups for Excel, PowerPoint and Word. PowerPoint users
will recognize Jim as the creator of InsertPicture add-in
for Macintosh. He has made other add-ins and templates
for Excel, PowerPoint and Word and is knowledgeable about
graphs and mail merge. At SUNY University at Buffalo, Jim
works helping faculty, staff and instructors with a wide
array of technologies for higher education.
Do
visit James' site...
This article was originally authored by Naresh
Nichani and Brian Reilly for Microsoft Office for
Windows -- James consented to do a Mac version of the
technique.
|
Although you can copy and paste
an Excel sheet inside a PowerPoint slide, there's an alternative
method. Microsoft Excel possesses an amazingly intuitive and powerful
calculation engine -- and tons of formulae.
Let us say you need to present some financial projections and also do some “what-if” analyses on these financial projections.
Follow these steps to get started:
- Create a new, blank presentation in PowerPoint, or add a new,
blank slide to an existing one. Change the layout of the slide
to either Blank of Title.
PowerPoint 2004 and earlier users can choose
Format | Slide Layout, and apply the new layout within the relevant
dialog box (see Figure 1) or task pane, or use the Formatting
Palette.
Figure 1: Slide Layout
PowerPoint 2008 users can click Slide Layouts
under the Elements Gallery -- and then choose the relevant layout
option (see Figure
2).
Figure 2: Slide Layout
- Now you will add an Excel spreadsheet object to this blank
slide. From the Insert menu choose Object | Microsoft Excel Sheet
(or Microsoft Excel Worksheet in older PowerPoint versions) as
shown in Figure
3.
Figure 3: Insert Object
- Enter financial values and calculations into the Excel object. The spreadsheet below (see Figure 3) is an example of some very simple calculations.
Figure 3: Enter Values
- Sales are $200,000 (cell D2).
- Fixed costs are $50,000 (cell D3).
- Variable costs are 65% of sales – $130,000 (cell D4)
- Net Profit is $20,000 i.e. Sales – (Fixed Costs + Variable Costs). It is in cell D5.
- In your presentation, you may want to allow the audience to enter different profit goals, and see what sales they need to achieve to meet those profit goals.
- Cell D7 is an entry cell to enter the profit goal.
- Cell D8 is the sales you need to achieve to meet the profit goal in cell C7.
- The formulae are listed in the E column for all D column entries
Remember, you don't have to manually input all the values above
if you download
the sample presentation...
Note: When in PowerPoint’s Normal View you
can edit the embedded Excel by double-clicking it. OpenSource Active-X
has not been ported to the Mac, so you cannot edit or open the
workbook while the slide show is running.
Power User Tip: Office 2004 and earlier supports
Visual Basic for Applications as well as ODBC connections and web
queries to a wide variety of databases. Using various combinations
these technologies it is possible to update workbooks automatically
when the presentation runs so that live data feeds are possible.
Visual Basic for Applications is not supported in Office 2008.
           
|
|
