Visual Basic for Analytics

₹11,000 + taxes

Enroll Now

₹11,000 + taxes

New to Analytics?
Sign Up for a free course!

+91
In an age where businesses always focus on the user, learn how to make user-centric, intuitive and interactive analytic dashboards and reports using Visual Basic. Also learn implementation of statistical models, and impactful presentation of results.
Learning Mode:  Online
Certification Certification:  Jigsaw Academy
Course Duration:  1 month
Access Duration:  3 months

What you get

Faculty & Technical Support
Mobile App Access
Case Studies
UChicago Certification
Guaranteed Internships
IBM Certification
IBM Certification
In-Person Faculty Support
Placement Support
Capstone Project
Online Classes
Online Q&A Sessions
IOT Hardware Kit
IOT Hardware Kit
IconNot Applicable
IconApplicable
* T&C apply

Tools & Curriculum Covered

Tools

Introduction to VBA, Variable and Data types

VBA Logic & Loops

Case Study - Writing an excel macro to extract individual elements from a string

VBA Functions, Variables / Procedure Scope and Lifetime

Case Study - Using msgbox and functions in VBA to generate desired results

Worksheets & Arrays

Importing Data into Excel

Case Study - Writing SQL statements in VBA to manipulate data

GUIs and User Forms

Case Study - Creating user forms to make meaningful filtering of data

Form & Excel Controls

Case Study - Appending and creating new files before using form and ActiveX controls to call macros

Charts and Pivots

Case Study - Creating legends using checkboxes and pivot tables

Building Regression Tool

Faqs

You can start by browsing through our Explore Analytics section. You could also visit our Analytics Training blog for more reading material, reports and in-depth articles on other topics like data science, machine learning, artificial intelligence, Big Data and IOT. If you’d prefer watching videos, head over to our Youtube channel.

Participants can pay through an online transfer, debit card or credit card (Visa, Master Card and Amex). Foreign students can pay via credit card or PayPal.

Our programs have been designed for all students regardless of any prior knowledge of analytics, statistics or coding. We have had and continue to have many successful students who are from non-IT or non-mathematics backgrounds. But the subject matter is quantitative, and hence a background in maths, statistics or coding is helpful. If you have specific questions regarding eligibility or prerequisites for any program, please contact us at +91 9019217000.

Jigsaw Academy has been at the forefront of analytics in India for the last 8 years. In that time, the institute has been ranked #1 in the country by Analytics India Magazine multiple times, including for the last two years running. With our expert faculty and carefully designed courses, we have been able to help several students build towards a career in analytics. We also have ongoing collaborations with prestigious institutes such as the University of Chicago and Bocconi University in Milan. In addition to individuals, we are also invested in providing high-quality analytics training at the corporate level.