Excel VBA Connecting PowerPoint Application - Series 9

Course

Online

£ 13 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Discussing about the connectivity of excel with power=point in this advance series using Excel VBA.
Taking a deep dive into power-point classes like Presentation class, Slide class and shapes class. Understanding the power-point object hierarchy.
Real time projects discussion with you to give you live exposure of working with Power-point.
Understanding the concept of Early Binding and Late Binding methods or techniques
Live Projects for you - Fully automated and high level automation.
This course will have my email support as well.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

You will be able to understand the power-point object hierarchy and its classes which will be useful in automating the daily PPT work for you
You will be able to understand the basic logic behind connecting excel with other applications , In this case it is power-point
You will be able to understand the power-point object hierarchy and its classes which will be useful in automating the daily PPT work for you

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • PowerPoint Presentation
  • Power Point
  • Ms PowerPoint
  • MS Excel
  • Project
  • Presentation
  • Powerpoint
  • Excel

Course programme

PowerPoint Connectivity 8 lectures 04:31:07 Chapter 1
  • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
  • How we use these Classes in Excel VBA
  • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter4
  • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
  • How to Loop over slides one by one in powerpoint presentation
  • How to loop over shapes pasted inside each slide
Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • Chapter6 In this video we are learning how to add shapes or pictures in every slide but with a condition that each slide will have four pictures pasted, So, if you have 12 images or shapes or pictures , your vba code will create three slides and each of it will have 4 shapes getting pasted. Chapter7 This is one of my greatest project which is covering everything about Powerpoint and Excel VBA. See this from scratch. To practice on this download the code file and then create your own dummy other excel file from where we need to pick ranges and charts as shown in the video and then start doing it. chapter8 Its a surprise test for you. Let us see how much you score in it. Please understand the questions first and then do it without looking at the solutions. later, of-course you can come back and see the coding. All the best. This is not just a test but also a good revision PowerPoint Connectivity. 8 lectures 04:31:07 Chapter 1
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter4
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • Chapter6 In this video we are learning how to add shapes or pictures in every slide but with a condition that each slide will have four pictures pasted, So, if you have 12 images or shapes or pictures , your vba code will create three slides and each of it will have 4 shapes getting pasted. Chapter7 This is one of my greatest project which is covering everything about Powerpoint and Excel VBA. See this from scratch. To practice on this download the code file and then create your own dummy other excel file from where we need to pick ranges and charts as shown in the video and then start doing it. chapter8 Its a surprise test for you. Let us see how much you score in it. Please understand the questions first and then do it without looking at the solutions. later, of-course you can come back and see the coding. All the best. This is not just a test but also a good revision Chapter 1
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    Chapter 1
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    Chapter 1
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    Chapter 1
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.
    Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter2 We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter3 If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. Chapter4
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    Chapter4
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    Chapter4
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    Chapter4
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide
    Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • Chapter5
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
  • One has to be good in collection loops . Charts and Worksheet collection loops
  • This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes This is one of...
  • Additional information

    Good knowledge of Loops and Collection loops along with understanding of Charts is must This is super advance series where we are going to connect power-point with Excel so you need to have good understanding of Loops and basic knowledge of classes

    Excel VBA Connecting PowerPoint Application - Series 9

    £ 13 + VAT