VBA Excel

Home / VBA Excel
0 student

Course Fee

₹ 6000 ₹ 5,000

Course Insides

Level of Course

Beginners to Advance

Duration

2 Months

Classes Mode

Classroom|Online

Classes

Weekend(Sat & Sun)

Live Project

3 Live Projects

Exercises

12 Exercises

About the course

The Microsoft VBA- Visual Basic Application is a program designed for managing every function in the MS Excel quickly and cost-effectively. It allows the users to perform complex and tedious operations in Excel quite easily and accurately. Whether it is creating a spreadsheet, computing huge data or performing common commands, VBA helps in performing all that in a matter of seconds.

The best VBA training in Delhi offers excellent training in VBA helping the students to gain adequate skills and comprehension for becoming a successful professional. VBA is an event-driven programming language from Microsoft which helps in tool automation and development. It increases the efficiency of work and reduces the time frame and manpower.

Course details:

  • Introduction to VBA
  • VBA Editors
  • Designing a Macro
  • VBA syntax and grammar
  • Using variables, loops, arrays, logic, functions
  • VBA dashboard
  • business wizards and other important platforms

Who should take up the course?

The training is best for students who have a basic knowledge of Excel and wish to enhance the knowledge to further heights. The course can be joined by any graduate, excel operators, working professionals, and programmers.

Benefits

  • It enables the user in developing user-friendly programs which helps in performing Excel functions easily.
  • It is a popular tool used by organizations for managing their investments, finance, and banking details.
  • There is a huge scope for VBA and the training will help in fetching a high-pay job.
  • It enhances your computations, programming, and database management skills which increase your prospects of getting a better job.
  • The VBA skills can also be helpful in managing the finances if one starts their own business in future.

Modules

  • Why VBA?
  • Scope of VBA
  • What is VBA?
  • What is Programming Language?
  • IDE, Type of Module, Properties Window ,Immediate window,watch window
  • First program Hello World
  • Class,Object,Absolute Macro, Relative Macro, Objects Tasks
  • Practice, Questions and exercise
  • List of Data type
  • Variable Declaration
  • Constants
  • Static
  • Variable Naming conventions
  • Practice, Questions and exercise
  • Count Last Rows and Columns
  • Working with Active sheet
  • Worksheet,workbook
  • Practice, Questions and exercise
  • If, If Else, Nested IF
  • Select Case
  • IIF Expression
  • Practice, Questions and exercise
  • For Loop
  • For each Loop
  • While Loop
  • Do while Loop
  • Do Until Loop
  • Practice, Questions and exercise
  • Check Even Number
  • Check Odd Number
  • Check Prime Number
  • Built in Functions in VBA
  • Type of Array, Static array(redim, preserve), Single dim,Multi Dim, option base, split ,join
  • Practice, Questions and exercise
  • Create Pivot Advance
  • Filtering
  • Remove Duplicates
  • Text to column
  • Practice, Questions and exercise
  • Command Button
  • Text Box
  • Label,Combo box, List Box
  • Check Box,Radio Button(Option Button)
  • Practice, Questions and exercise
  • Create Folder
  • Move File in Folder
  • Consolidate Files
  • Practice, Questions and exercise
  • Before Close,Before save
  • Sheet Activate,Open, New Sheet
  • Sheet Change, Sheet Deactivate
  • application on key application onetime
  • Practice, Questions and exercise
  • MS Access
  • Outlook
  • SQL Server
  • Internet Explorer
  • MS Word
  • Power Point
  • Note Pad
  • Practice, Questions and exercise
  • Need to develop an Excel based VBA tool to Consolidate the data into single excel file based on multiple excel files
  • Need to develop an Excel based VBA tool to Reconcile the data based on multiple sheets
  • Need to develop an Excel based VBA tool Splits the data into multiple workbooks based on Input Data
Curriculum is empty

Instructor

User Avatar admin

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
₹ 6,000 ₹ 5,000