Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 31 Minute(s)
Language
English
Taught by
ajay parmar
Rating
Course Overview
Interacting with PowerPoint Application and making presentation on Auto mode
Discussing about the connectivity of Excel with PowerPoint in this advance series using Excel VBA.
How to copy table data from excel and paste into PowerPoint application slides.
How to export charts from excel sheets to PowerPoint and paste them in one slide or more slides one by one.
Taking a deep dive into power-point classes like Presentation class, Slide class and shapes class. Understanding the power-point object hierarchy.
How every class is responsible for other class using the dot hierarchy.
How to work with already created PowerPoint applications and also how to create new PowerPoint applications and work with them.
How to resize the charts or tables images in slides and move them to the top or left or right of the slides.
Control which chart should go in PowerPoint using the excel sheet cells.
How to loop through all sides and decide which one to be deleted or used for data presentation.
Collection loops for slides as well as shapes. This is amazing source of learning.
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
Several highly advance level Projects for you - Fully automated and very very knowledgeable practical projects.
This course will have my email support as well.
Course Content
- 1 section(s)
- 12 lecture(s)
- Section 1 Connecting Powerpoint with Excel VBA
What You’ll Learn
- You will be able to understand the basic logics behind connecting excel with other applications , In this case it is powerpoint.
- 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.
- How to use PowerPoint library before running a code.
- How to create PowerPoint applications and make them visible.
- How to create slides and give them indexing one by one. What precautions need to be taken care .
- Learn the powerpoint application classes like Slides, Presentation, Shapes. How to use them in proper hierarchy way
- How to paste Charts and Range objects from Excel to Powerpoint slides.
- How to resize the chart size once it is pasted on Slides. How to move the pasted charts in a slide
- How to delete or move charts from one slide to another.
- How to paste all charts in one slide only OR Paste one chart in one slide.
- How to delete the slides if needed and how to start working with nth slide , if needed.
- How to work with already existing Powerpoint application instead creating a new one.
- How to avoid existing PPT Slides and paste data in new slides but within the same existed PPT.
- What happens when you share code with others who are using different version of PowerPoint.
- I have shared several very amazing and powerful projects with you as well to give you real results if you are serious about business.
- Know your Early binding and Late binding approach - So amazing and must know thing for developers
Skills covered in this course
Reviews
-
BBrian Field
I find this instructor's communication to quite poor. He doesn't speak English well. He was also rude, curt, and generally abrasive with his responses to questions. It is also ridiculous to me that the instructor markets this course as "live" sessions (Udemy courses are not live sessions) when the lectures are clearly recorded sessions - the instructor basically recorded some sessions where he provided live lectures and then posted them here as if they were designed for this course - they weren't - and I think the course suffers as a result.
-
JJ Fric Carlo
Got to learn a lot. Thanks you
-
EExcel Expert
Trainer is cool and explaining very well with so much pauses...thanks man..
-
JJyot
Amazing knowledge...its so fun watching these lectures. I am really liking the stuff. Thanks instructor.
