Microsoft Excel VBA (Visual Basic for Applications) is a programming language specifically for Excel that allows you to program your spreadsheets to respond to new data and parameters. Learning Excel VBA is the best way to get the most out of using Microsoft Excel.
- The Visual Basic Editor
- Recording Macros
- Editing macros using VBA Editor
- Recording and running macro
- Understanding the project explorer
- Storing macro in different books
- Exploring windows properties
- Creating buttons and assigning macro to it
- Modifying code in code window
- Creating my menu
- Debugging code
- Programming fundamentals
- User forms
- Variable ,data type , constant, Array, object variable
- Creating forms, form events
- Conditional structures (if. Then, select case)
- Creating custom menus and toolbars
- Logical operators
- Creating Add-ins MIS with database reports
- Looping constructs (for loop, Do loop, while. Wend)
- Built-in-function, creating subroutines
- Working with other applications
- Excel object model
- Working word, PowerPoint and other applications
- Working with object –properties, event and methods (Note: lecture will be conducted on webinar)
- Application objects
- Workbook objects, worksheet object and range objects
- Understanding Security levels
- Charts objects
- Why security
- Pivot table objects
- Security levels and its meaning
- Working with functions
- What is function and subroutine
- Working with live 15 industry oriented
- Writing function using vba editor comprehensive project
- Calling function in other work book
- Once you complete this master’s program, you will receive the course completion certificate by DICS PITAMPURA
DICS PITAMPURA Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 50% marks in the quiz. DICS PITAMPURA certification is well recognized in top MNCs .
- Any individual who uses Excel in their daily life
- Accountants, Auditors, Financial planners to put an end to boring repetitive tasks
- Managers, Project Managers, Project Planners who handle excel files and want to become more productive by using macros
- Anyone who wants an introduction to programming or want to seek new skills to improve their productivity
