VBA Macros & Excel Course

VBA Macros & Excel Course

Number of lessons 12

Time spent on a lesson 1h

Number of lessons: 12 lessons

Lesson Duration: 1hour

Course Format։ Face-to-face learning

Course Fee։ 75․000 AMD

Venue։ IBT Educational Center, Citadel Business Center, 105/1 Teryan, Yerevan

Who is the course intended for?

VBA Macros & Excel course is designed for those who have in-depth knowledge of Excel. At the end of the course, the participating student will be able to write and edit codes on their own, which will allow her/him to automate calculations.

Course benefits

• The course includes practical tasks and theoretical materials,
• Free consultation on your work files,
• There is no age restriction and no prior knowledge is required for the participation in the course.

Course Content

Lesson 1.

• VBA overall, the basic concepts
• VBA import and activation options
• Developer menu activation
• Macro storage
• VBA recording modes
• VBA operation options
• VBA insert’s suborders
• Types of access to procedures and  input types
• Line break in VBA
• Basic types of data used in VBA

Lesson 2.

• Operators
• MsgBox Function
• InputBox Function
• Variables and constants

Lesson 3.

• Definition of conditions:  If … then … Else
• GoTo

Lesson 4.

• VBA functions
• Excel Function

Lesson 5.

• Cycles
• 1st group cycles 
• 2nd group cycles

Lesson 6.

• Types and Features of the links to the cells
• Copy & Paste
• Color

Lesson 7.

• Ways of sheet linking
• Ways of file linking

Lesson 8.

• Summary in the form of tasks

Lesson 9.

• Formulas

Lesson 10.

• Creation and application of your own functions
• Types of errors in VBA

Lesson 11.

• GetOpenFileName
• Task solving

Lesson 12.

• VBA additional skills
• Summary in the form of tasks