课程详情

In first Section, we are learning about Chart automation. How to create new charts iusing VBA. We can fully automate the making of charts using VBA.Learn the Chart class called Chart and see how easy it is to create the new charts.The role of macro recordings plays a very important role here as most of the code we can record and later customize as per the requirement.How to work with existing charts in excel. How to go to each of them one by one and do modifications. Any type of modification like changing chart design or editing labels or chart titles etcUnderstand the Loops importance in charts. You can loop through infinite charts using one simple collection loop.Collection loops of charts - to work with multiple charts either to delete them or to edit their design, colors. You can do whatever. Even change the axis's.Use of other Collection loops with chart collection loops. Loops in LoopsIn section2, you will become master in Pivots. From making new pivots to working in existing pivots and modifying them Collection loops in PIvots - how to access pivots. How to loop pivot field items and fully control it.We will learn the classes we use in Pivots to handle new pivots or existing pivots like Pivot-table and Pivot cache classes.We will take a deep dive into knowing other classes as well which helps us in controlling the pivot fields and field items like pivot item class and pivot-Field class.How to mix worksheet collection loops with pivot collection loops in real time projects and what are the benefits of sameWhat is the role of macro recording in making pivots and how to edit those recording if requirement changes.How to work with row or column of filter pivot fields. Line by line explanation.In Section3 , we are learning how to connect Powerpoint with Excel VBA.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.In Section4 , we are learning how to connect with databases like ms access using SQL commands in Excel VBA.How to retrieve information from a database using SQL in vbaHow to delete/ update and insert the information in database like ms access using VBA and also using Userforms

课程标签

0人关注该课程

主题相关的课程