Actual PowerPoint Automation with Excel VBA

Name: Actual PowerPoint Automation with Excel VBA
Rating: 4.8 (92 reviews)

Automate your PowerPoint Presentations with Excel VBA

Created byBrian Field

Last updated 2/2026

English

What you'll learn

Step by Step Instructions on how to Automate PowerPoint Deck Creation with Excel VBA.
Learn to Create Dynamic Output that Requires Minimal Manual Interaction.
Accelerate Your Report Production Process.
Understand How to Create and Manipulate PowerPoint from Inside Excel.
Avoid Endless Copying and Pasting from Excel to PowerPoint Each Day, Week, Month, etc.

Course content

4 sections • 24 lectures • 2h 32m total length

Introduction3:23
Course Ratings1:21

Building the Excel - Step 19:54
Building the Excel - Step 25:44
Building the Excel - Step 322:36
Building the Excel - Step 46:35
Building the Excel - Step 51:06
Building the Excel - Step 68:24
Building the Excel - Step 75:07
Building the Excel - Step 87:13
Building the Excel - Step 91:17
Explore dynamic references in Excel, copy formulas to update sheets, and optimize performance by using manual calculation to counter Excel’s automatic recalculation weaknesses, plus a few time-saving tricks.
Building the Excel - Step 106:28
Explore using the offset function to create dynamic Excel references that adjust as data grows, by counting nonempty cells and computing height and width, then preview named ranges with VBA.
Building the Excel - Step 119:12
Apply Excel VBA to automate named ranges with offset, by building and testing period and dim references, deleting and redefining thousands of names, and ensuring contiguity for dynamic charts.
Building the Excel - Step 1219:16
Build and format dynamic charts in Excel using named ranges to visualize units, dollars, weighted average term and rate, and distributions (FICO, LTV, DTI), with automated updates as data grows.
Building the Excel - Step 135:19
Building the Excel - Step 143:19
Building the Excel - Step 154:32

Listing the charts in the desired order of presentation in the Powerpoint5:07
Adding a sheet that lists the PowerPoint Slide Titles1:01
Add a new sheet to the spreadsheet and use column a for slide titles, aligning each title with its slide number, then proceed to charts in the next lecture.
Create a PowerPoint from within Excel!3:03
Create Sections to Map into the Final PowerPoint1:23
Incorporating the Section Slides into the PowerPoint3:16
The Final PowerPoint7:04

Requirements

No VBA Experience Needed. Familiarity with Excel Assumed. I will walk you through everything step by step!
Finance Professionals will find this course particularly interesting

Description

This course will be truly transformative for your productivity. No more copying and pasting from Excel to PowerPoint! No more worrying about resizing charts. positioning shapes, or adjusting colors, etc. in PowerPoint to make the presentation consistent. This course will teach you how to do it all with the minimal keystrokes....

You will learn valuable Excel tricks to optimize your reporting PLUS you will know how to automate the PowerPoint presentation creation. You will also learn shortcuts that I use in my professional role as the Head of Reporting and Analytics for a large US Bank.

This course is particularly useful for Finance professionals but all other industries can benefit substantially from these techniques.

I will be available to answer your questions and address concerns, if any, as they pop up. I will also provide you with my personal email so that you can contact me via that avenue as well.

I am here to ensure that this course creates a life changing experience for you....if you have ever been frustrated by having to manually perform steps in PowerPoint, please, please, please take a look at this course! It will change your life!

I cannot wait to hear how you benefited from this course!

Who this course is for:

Anyone Who Builds PowerPoint Presentations Using Excel Tables, Charts, etc.

Actual PowerPoint Automation with Excel VBA

What you'll learn

Explore related topics

Course content

Introduction to the Instructor and to the Course2 lectures • 5min

A Look at the The Course Dataset1 lecture • 11min

Building the Excel15 lectures • 1hr 56min

Let's start working with PowerPoint through Excel VBA6 lectures • 21min

Requirements

Description

Who this course is for: