Project on Excel VBA - Attendance Register using Microsoft Excel VBA

The main course objective of this online training is to deliver the knowledge of advanced options that a user can apply to create a CRM tool without using any coding or intense programming. VBA and Macros are the best tools that an employee can use to automate processes.

Visual Basic for Applications (VBA) is a programming language which is event driven. This language is efficient to build proper user defined functioning commands, process automation and also allows a user to use Application Program Interface of Windows. Excel VBA with the help of Macro makes the programming part easier for the user.

The training includes the following topics:

• Basic Controls in VBA
• Additional Controls
• Adding References
• Overview of Advanced Controls
• List views
• Adding List view to User form
• Properties of List view
• Events of List view
• Methods of List view
• Populating data in List view
• Tree Views
• Adding Tree view to User form
• Properties of Tree view
• Events of Tree view
• Methods of Tree view
• Population data in Tree view
• Creating a Basic Project Management Tool with Tree view & List views

Who this courses is for:

• Commerce students
• Students from the business administration
• Chartered Accountants
• Working professionals who go through the hectic working schedule of same repetitive work every day can do the training and make their life easier