Actual Powerpoint Automation With Excel Vba

Automate your PowerPoint Presentations with Excel VBA

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.

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!

Overview

Section 1: Introduction to the Instructor and to the Course

Lecture 1 Introduction

Section 2: A Look at the The Course Dataset

Lecture 2 Let's look at the data

Section 3: Building the Excel

Lecture 3 Building the Excel - Step 1

Lecture 4 Building the Excel - Step 2

Lecture 5 Building the Excel - Step 3

Lecture 6 Building the Excel - Step 4

Lecture 7 Building the Excel - Step 5

Lecture 8 Building the Excel - Step 6

Lecture 9 Building the Excel - Step 7

Lecture 10 Building the Excel - Step 8

Lecture 11 Building the Excel - Step 9

Lecture 12 Building the Excel - Step 10

Lecture 13 Building the Excel - Step 11

Lecture 14 Building the Excel - Step 12

Lecture 15 Building the Excel - Step 13

Lecture 16 Building the Excel - Step 14

Lecture 17 Building the Excel - Step 15

Section 4: Let's start working with PowerPoint through Excel VBA

Lecture 18 Listing the charts in the desired order of presentation in the Powerpoint

Lecture 19 Adding a sheet that lists the PowerPoint Slide Titles

Lecture 20 Create a PowerPoint from within Excel!

Lecture 21 Create Sections to Map into the Final PowerPoint

Lecture 22 Incorporating the Section Slides into the PowerPoint

Lecture 23 The Final PowerPoint

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