Excel in PowerPoint for Macintosh

Office 2011 for Mac All-in-One For Dummies

If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon. This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.

Check the book on Amazon.com.

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:

1. 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 or Title.
2. PowerPoint 2004 and earlier users can choose Format | Slide Layout and apply the new layout within the relevant dialog box, as shown in Figure 1, below, or task pane, or use the Formatting Palette.
3. 
   Figure 1: Slide Layout
4. PowerPoint 2008 users can click Slide Layouts under the Elements Gallery, and then choose the relevant layout option, as shown in Figure 2, below.
5. 
   Figure 2: Slide Layout
2. 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, below.
3. 
   Figure 3: Insert Object
3. Enter financial values and calculations into the Excel object. The spreadsheet below, as shown in Figure 4, below, is an example of some very simple calculations.
4. 
   Figure 4: 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 of 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.