Visual Basic for Analytics– JIGSAW ACADEMY

With the help of this course you will learn how to make dashboards and reports user-centric, informative and easily understood. You will also learn how to implement statistical models and impressive presentation.

This course contains 10 modules-

• Introduction to VBA – Variable and Data types
• VBA Logic & Loops
• VBA Functions, Variables / Procedure Scope and Lifetime
• Worksheets & Arrays
• Importing Data into Excel
• Files and Folders
• GUIs and User Forms- I & II
• Form & Excel Controls
• Charts & Pivots
• Building Regression Tool

Duration: 8 Weeks

Mode: Online self-paced

Fees: INR 19,000 + taxes

Knowledge of Excel, SQL, data manipulation techniques and basic programming concepts in any language (SAS, R, Java)

• Excel