Excel VBA Basic to Advance Part3 ( 12 hours )

In-depth study of VBA Charts,VBA Pivots and Powerpoint Application Connectivity ,Database Connectivity -Advance Level

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• You will be able to learn how to create Charts using VBA
• You will under Charts classes to work with existing and new Charts
• How to work with more than 1 chart and create multiple charts and how to access charts across sheets or few ones
• We are learning how to work with Pivots using VBA. How to automate your pivot reports
• Everything that exists in VBA about Pivots is discussed in this series from working with existing pivots to creating fresh new pivots
• Collection loops used in Pivots are explained
• How to connect database with VBA using SQL command . Del, modify , change and insert , retrieving the information is so easy.

Requirements

• You should already know how to create Charts and Pivots in Excel. This is a VBA Course so here we not learning what are charts and pivots.
• We are learning how to automate them using VBA

Target audience

• Data Analysts or Data scientist who work on excel and want to produce pivot and charts in one click