Jigsaw Academy recently launched a new course in VBA for professionals who have mastered the skills of model building but want to implement models using an easy front end. It’s a short course of 11 hours of pre-recorded video lectures that will help students learn at their own pace (one can access the videos for 4 months).
So why one should go for a VBA training if you are already aware of SAS, R or any other language:
1. Close Integration with Excel: MS-Excel without a doubt is the most widely used software for storing & manipulating data and VBA is the only language closely bounded with the excel object model. Hence, this functionality of VBA allows users to realize the true potential of scope.
2. VBA is Powerful & Flexible: VBA is power & flexible and comes as a free toll with Microsoft Office. It can be used as an excellent platform to deploy all your models. However, If you deploy the same models with some other platforms, you might need to pay some licence and fees.
3. Provides a user interface: Using VBA, you can provide a graphical userinterface and hence ensuring that the end user can use your work or implement your model much more easily.
4. Connects to other programs and applications: VBA can be used to connect to your external databases. For example, excel and VBA together give you the flexibility to connect to your database might be present on a SQL server which is in a remote location.
5. Statistical Analysis using Excel: Statistical analysis toll pack present in Excel can be evoked by VBA and hence, you can do all types of analysis arranging from regressions to a normal correlation or time series analysis.
6. Extend the power of Excel Graphs & Histograms: We all know how useful Excel is for creating graphs and histograms, but, when you couple this with the power of VBA, it gives you the ability to manipulate the graphs and histograms. For example, if you want users to select which series are to be shown in a particular chart you can easily create checkboxes with a small line of code in the background.
7. Import & Export data in various formats: Excel can import and export data in various formats like csv, txt, xml file to name a few.
8. Excel can be used as a database
9. Interfaces with other programs using web services: Excel can communicate with other programs using web services. So one can download some data directly from a website. For example, one can download stock data directly from Yahoo! website. Excel can also communicate with programs based in your system like Power Point (using Macros), SAS or R.
Following introductory video in VBA would help one get an idea about the quality and depth of the VBA course by Jigsaw Academy.
If the above video interests you into VBA, you can check out VBA course by Jigsaw Academy at: http://jigsawacademy.com/online-vba-courses/