VBA Course

What is ANALYTICS?
The purpose of analytics is to take existing data collected from either a single source or multiple sources and use it to arrive at the optimal decision. Essentially, analytics can be best defined as a science of analysis.
Commonly, one of the most frequent uses of analytics is in the field of business. Managers or researchers for an analytics company can use various data mining techniques combined with historical patterns to make predictions about the performance of a particular market or business.

10 most popular analytic tools in business

• Business analytics is a fast growing field and there are many tools available in the market to serve the needs of organizations. The range of analytical software goes from relatively simple statistical tools in spreadsheets (ex-MS Excel) to statistical software packages (ex-SAS, SPSS).

• To sophisticated Business Intelligence suites (ex-SAS, Oracle, SAP, IBM among the big players).

Topics Covered Understanding on Macros.

• How to record a macro

• How to edit a macro

• How to debug a macro

• Implementing macro security and digital signatures

• How to assign a short cut button to a macro

• Adding a macro as a custom button in excel

• Tips on analyzing the requirement and recording a successful macro

• Various Exercises on Macros

Visual Basic in Applications.

• VBA and its advantages

• Overview of VBA editor

• How to use various features in VBA editor

• Definition of Modules. How to create and delete VB module

• Events, How to add a event to a workbook, How to make Macro work automatically when a workbook is opened, saved etc..

• How to use references and help in VBA

VBA Programming Kit.

• Various codes available in VBA and its usage

• The Excel Object Model

• How to get the required codes for programming

• How to declare variables, arrays, assign values etc

• How to declare constants and data types

• Methods and Properties

• Using IF and Loop functions in VBA

• Input and Output facilities in programming

• Workbooks and worksheets

• Ranges and Cells

Creating User Forms.

• What is User form, Advantages

• Techniques in creating user form

Coding Standards Introduction to Interaction of Excel VBA with other application. Session and Review of Various Projects done in Excel VBA You are also going to learn things required to make a successful automation project, To build a automation project what are all the different things to be taken care, Understand customer requirements, How to come up with a idea, Find out the pros and cons of each logical way, Understanding customer knowledge level and system capabilities, developing the automation, testing, working on fixing the issues, User acceptance testing, production release and maintenance. You will also know Just with Excel VBA how You can talk and take control of other applications. What is required to do this? And many more things which will make you think out of the box and create magic in Excel.