Learn MS Excel VBA

Belajar Microsoft Excel Visual Basic Application (VBA) dengan cara mudah dan sederhana.

VBA, or Visual Basic for Applications, is the simple programming language that can be used within MS Excel to develop macros and complex programs. The advantages of which are:

– The ability to do what you normally do in Excel, but a thousand times faster

– The ease with which you can work with enormous sets of data

– To develop analysis and reporting programs downstream from large central databases such as Sybase, SQL Server, and accounting, financial and production programs such as Oracle, SAP, and others.

This Application will teach you

Introduction and Environment

Basic Concepts and Terminologies

Variables

Conditional Logic

String & String Functions

Loops

Arrays

Subroutines

Message box

Functions

Text Files

User Forms

Charts

Security

Data with Image Project

Tree View Project

and lot more added soon