Will cover the Excel macro programming using VBA that is required in the Industry. It is a fully practical based training. Beneficial for career oriented people.
Topics Covered
Introduction to Visual Basic Object Orient Programming concepts and Illustration Excel Object Model VBA Data Types Operators Arithmetic Operators Comparison Operators Logical Operators Concatenation Operator Basic Excel Operations Dialogs in VBA screen Defining Constants Defining Variables Defining Global Variables Defining Static Variables Working with Functions Creating Functions using Optional Arguments Creating Private Functions Creating Public Functions Working with Subroutines Creating Functions using Arguments Creating Functions using optional Arguments Creating Private Subroutines Creating Public Subroutines Handling errors Working with Message Box Decision Statements Looping Statements Working with User Forms Developing different Consolidation Tools using VBA programming Working with system Registry Database Connectivity using VBA Introduction to SQL Server Making connections in SQL Server through VBA Concept of Recordset Retrieving records from database Updating records to database Adding records to database Deleting records from database Creating Excel based application Creating Time saving tools Creating Plug-Ins
Who should attend
MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, HR Managers, Students
Pre-requisites
Understanding of Microsoft Excel
What you need to bring
Notebook Pen
Key Takeaways
Develops simple-to-complex models for measuring performance using VBA Automation. Designing and set up new Automated Reporting Systems to monitor the productivity, quality of the employees. Develop Excel based high quality Applications. Develop Time saving Utilities.
View this Course
Certified
You have 
