About the Course
MICROSOFT excel programming
It is a sophisticated programming language that enables you to control any and all aspects of the program. Anything you can do with the keyboard and mouse you can also do with programming.
INTEGRATE WITH OTHER applications
CREATE INSTRUCTIONS OR FLOW CHART BEFORE CREATING A PROGRAM.
DATA STORED OUTSIDE THE PROGRAM.
DATA STORED WITHIN THE PROGRAM.
WHAT IS VBA LANGUAGE?
VBA stands for Visual Basic for Applications. The name Visual Basic for Applications reflects the fact that VBA is based on Microsoft’s Visual Basic programming language, and that it is designed for programming within applications—specifically, the applications that comprise the Microsoft Office suite (Excel, Word, Access, PowerPoint, and Outlook). VBA is relatively easy tolearn, as programming languages go, but does not sacrifice power and flexibility.
VBA Editor is a platform to write Excel programs. It can open by pressing Alt F11 when in Excel, or by selecting Tools?Macro?Visual Basic Editor from the menu.
Topics CoveredTopics covered are:
VBA 2007 Programming
Who should attendAnyone who have the knowledge on Advance Excel.
Pre-requisitesAdvance Excel, Pivot tables, Charts, H Lookups, VLookups.
What you need to bringNotebook, Pen
Key TakeawaysHands On exp on VBA & Excel