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 you ll learn how to create and edit pivot tables and different chart types such as bar charts and line charts using VBA in Excel. You ll then save these Excel charts as images again using VBA. Next you ll use Excel s stock datatype to access financial data.
Moving on you ll learn how to use VBA to automate tasks in MS Access accept user input validate it and insert it into an MS Access database. You ll also learn how to run simple SQL queries against that database. Finally you ll set up event handlers in Excel using VBA and illustrate their purpose.á”