VBA: Leveraging VBA to Work with Charts Stocks & MS Access

Leveraging VBA with Excel has many useful capabilities including the creation and management of pivot tables and charts and the automation of tasks in MS Access the lightweight relational database. In this course youll learn how to create and edit pivot tables and different chart types such as bar charts and line charts using VBA in Excel. Youll then save these Excel charts as images again using VBA. Next youll use Excels stock datatype to access financial data. Moving on youll learn how to use VBA to automate tasks in MS Access accept user input validate it and insert it into an MS Access database. Youll also learn how to run simple SQL queries against that database. Finally youll set up event handlers in Excel using VBA and illustrate their purpose.