If you have visited our website recently, you will notice that we have some new additions to our list of advanced courses. One of them is the VBA For Reporting And Analytics course. Well for those of you whose curiosity is piqued here is a low down of what the course teaches, who it’s for, what it costs and lots more. Also take a look a sample video and see for yourself how easy to understand we make or courses.
What does the course teach?
The VBA For Reporting And Analytics course teaches how to use the VBA programming functionality of Excel effectively. It also teaches how to build decision support systems. Participants will also learn how to get data into excel from various places & formats ( i.e. relational databases, flat files (csv, txt)) and how to create Excel Add-Ins and User defined functions.
The VBA course is divided into five modules namely:
1. Introduction to VBA
2. Functions and Addins
3. GUI Building
4. Programming in VBA
5. Data Manipulation using VBA
There will also be three case studies that explain how to build a regression tool, simulation in Excel and querying using Excel.
Who is the course for?
This course was essentially developed for students looking to pursue a business analytics career and professionals who have mastered the skills of model building but now need to implement models with a easy to use front end. However this course is also relevant and useful for those working in modern day corporations, on data which resides in numerous places in various formats. This course will teach them to integrate this data, so that reports and models for data mining can be built.
What is the duration of the course?
Participants will get access to about 11 hours of pre-recorded video lectures. The videos can be viewed at any time and as many times as the participant wants for a period of 4 months.
What else do you get access to?
Participants are also given access to Jigsaw Academy’s virtual lab-a unique cloud-based solution to providing the lab experience where they will be able to work on real life business datasets, for a period of 4 months.
Prerequisites of the course
The pre-requisites for the course are Knowledge of Excel- Formulas, Charts, Pivots and Knowledge of data manipulation techniques. It is also recommended that participants have exposure to basic SQL language and programming concepts in any language like SAS, R and Java.
What is the price?
The VBA course is priced at Rs. 20,000 (Indian students) and $500 (Foreign students-Outside India). However as an introductory offer the course can now be purchased for Rs. 15,000 (Indian students) and $375 (Foreign students-Outside India).
For more information about the course and to register please visit the VBA Course Page on the Jigsaw website.
Remember you can also experience Jigsaw’s courses and get access to some complimentary Analytics and Big Data resources by visiting the FREE TRIAL section of our website.