Free 5-day email course

Automate PowerPoint Reports from Excel with VBA

Turn a workbook of 165 charts into a finished PowerPoint deck with sections, using three macros you can rerun every month.

This course is for analysts who build the same PowerPoint deck full of charts again and again. Over five days you will see how to set up the data, put the charts in order with a macro, build the deck, add sections and refresh the whole report for a new month.

Get lesson 1 now

For Analysts who build recurring Excel-to-PowerPoint reports.

Free. 5 emails, one a day. Unsubscribe in one click. See our Privacy Policy.

What you will get

  1. 1

    Day 1

    Lay out a loan dataset so automation has nothing to guess

  2. 2

    Day 2

    Use a macro to list your charts in presentation order

  3. 3

    Day 3

    Create a titled PowerPoint deck from Excel with one macro

  4. 4

    Day 4

    Merge a section template into your chart deck with a macro

  5. 5

    Day 5

    Refresh the monthly report and rebuild the deck in three macro runs

The lessons are drawn from the full course, Actual PowerPoint Automation with Excel VBA.