VBA in Excel as MS-Excel itself provides loads of inbuilt functions. MS-Excel provides only basic inbuilt functions which might not be sufficient to perform complex calculations. Under such circumstances, VBA becomes the most obvious solution.
VBA is used in Microsoft Excel to create sophisticated tools that can be used in business, engineering and science. VBA allows users a level of customization beyond what is typically available in Microsoft Office products, such as Excel, Word and Power Point. A user types commands into an editing module to create a macro. Macros then allow the user to automatically generate customized reports, charts and perform other data processing functions. Within the finance industry, VBA for Excel is commonly used to develop and maintain complex financial spreadsheet models.
Course Content:
Understanding The Basic Introducing VBA:
- Getting Started with Macros
- Introducing the Visual Basic Editor
- Working in the VBE
Diving Deepet Into VBA:
- Object-oriented Programming
- An Overview
- Variables, Data Types, and Constants
- Understanding Objects and Collections
- Making Decisions with VBA
Beyond The Macro Recorder: Writing Your Own Code:
- Repeating Actions with Loops
- Working with Arrays
- Automating Procedures with Worksheet Events
- Automating Procedures with Workbook Events
- Using Embedded Controls
- Programming Charts
- Programming PivotTables and PivotCharts
- User Defined Functions
Debugging Your Code:
- Advance Programming Techniques
- Creating UserForms
- UserForm Controls and Their Functions
- Advanced UserForms
- Class Modules Add-Ins
- Managing External Data
- Data Access with ActiveX Data
- Not Gone, Not Forgotten
Interacting With Other Office Applications:
- Overview of Office Automation from Excel
- Working with Word from Excel
- Working with Outlook from Excel
- Working with Access from Excel
- Working with PowerPoint from Excel