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. Advantages SAVE TIME. REDUCING ERRORS ENFORCING STANDARDS INTEGRATE WITH OTHER applications Programming Fundamentals CREATE INSTRUCTIONS OR FLOW CHART BEFORE CREATING A PROGRAM. HANLING DATA 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 Covered

Topics covered are: Advance EXCEL Macros Access SQL VBA 2007 Programming

Who should attend

Anyone who have the knowledge on Advance Excel.

Pre-requisites

Advance Excel, Pivot tables, Charts, H Lookups, VLookups.

What you need to bring

Notebook, Pen

Key Takeaways

Hands On exp on VBA & Excel