|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-connecting-powerpoint-application-series-13/
课程评论：没有评论
课程名称：Excel VBA与PowerPoint应用连接 课程概述：本课程深入探讨Excel与PowerPoint之间的连接，专注于使用Excel VBA实现高级功能。学习如何从Excel复制表格数据然后粘贴到PowerPoint幻灯片中，以及如何将Excel中的图表导出并逐个或一次性粘贴到一张或多张幻灯片中。课程将深入讲解PowerPoint的各类类，如Presentation类、Slide类以及Shapes类，理解PowerPoint的对象层次结构及其相互关系。 学习内容包括：如何处理已创建的PowerPoint应用程序，如何创建新的PowerPoint应用程序并进行操作，调整幻灯片中图表或表格图像的大小以及位置，利用Excel单元格控制哪些图表应插入到PowerPoint中，以及循环遍历所有幻灯片决定哪些需要删除或用于数据展示。此外，课程还涵盖了幻灯片和形状的集合循环。 课程提供了实时项目讨论，让学员获得实际操作的经验，并理解早绑定和晚绑定的方法。学员将完成多个高度复杂的自动化项目，这将增强知识的实用性。课程还提供邮件支持，以解答学员在学习过程中遇到的问题。 简而言之，这是一门实用性极强的高级课程，旨在提升学员在Excel VBA与PowerPoint交互方面的能力。
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 techniquesSeveral highly advance level Projects for you - Fully automated and very very knowledgeable practical projects.This course will have my email support as well.
