Excel, VBA & Macros A Comprehensive Course at sCoolTV
CFA Institute, USA has approved this program[/b], offered by Corporate Bridge, for 3 CE credit hours. If you are a CFA Institute member, CE credit for your participation in this program will be automatically recorded in your CE tracking tool.
This Program on Excel, VBA & Macros is well structured and strategically designed comprehensive online training program for learning Microsoft Excel VBA & Macros. It is full of real world examples & useful theory. The aim of this program is to make a beginner an expert in Excel and VBA. This course starts with several functions of Excel and later get in to VBA & Macros.
When we have to make repetitive reports, dashboards or slides, when the work on excel sheet gets complex and repetitive, the most important solution would be to automate the worksheets and save a lot of time.By using Excel VBA, we can automate several areas of data analysis, reporting and modeling work. VBA & Macros Program is important for those who:
• Want to apply the VBA Programming language to make their excel spreadsheets more powerful
• Looks forward to automate their repetitive excel spreadsheets, reports or dashboard
• Want VBA to help them use Excel better
This program includes introduction to VBA & macros like Understanding VBA Language, Objects Dealing with Constants, Objects Dealing with Variables, Data Filter Template etc. This program will also teach you how to make Income statement using macros, looping, how to make graphs& charts using macros bar chart& pie chart, Creating user Form using VBA & Macros etc
https://www.scooltv.com/course/2921/