The Result

Listing 14.3 produces a new PowerPoint presentation with a title slide and three additional slides corresponding to the reports in Excel. Figure 14.11 shows what the slides look like in PowerPoint.

Although the chart was embedded in the presentation in a picture format, the Sales Summary and Top 5 Stores reports are embedded in the presentation as Excel documents. This means that you can take advantage of in-place editing directly in PowerPoint as I am doing in Figure 14.12.

Figure 14.11

This is the presentation created by Listing 14.3.

0 Microsoft PowerPoint - [October Sales Analysis.ppt]

: File EcSt View Insert Format Tools Slide Show Window Help 5 Type a qiiesbon for heip - X

: CODSnaglt Window

/ Outline ) Slides

October Safes Analysis

October Sales Analysis

Figure 14.12

You can edit the reports directly in PowerPoint if desired.

Figure 14.12

You can edit the reports directly in PowerPoint if desired.

Although this is rather rudimentary as far as PowerPoint presentations go, it is not that much of a stretch to see how you might apply automation to your reporting and presentation cycles.

0 0

Post a comment