Training Courses : Developers : Visual Basic For Applications

Training Courses
Automating Excel Functions and Routinces with VBA in Microsoft Excel

Code: MSO.VBA
Type: IT InstructorLed Courses
Category: EXCEL SPECIALIST, Visual Basic For Applications

VBA (Visual Basic for Applications) is an Object Oriented Language. This programming language can be used to automate tasks by developing procedures and functions. It is useful for programmers and for people who wish build procedures (macros) in order to automate tasks and increase their own productivity and the productivity of the people of their departments.



Duration: 28 hours
Location: EDITC & MMC Conference Center, 16 Imvrou Street, 1055 Nicosia
Language: Greek
Attendance: 6-28
 

Topics

Unit 1: What  Is VBA?
Unit 2: Jumping Right In 
Unit 3: Working in the Visual Basic Editor 
Unit 4: Introducing the Excel Object Model
Unit 6: Using the Excel Macro Recorder
Unit 7: Essential VBA Language  Elements
Unit 8: Working with Range Objects
Unit 9: Using VBA and Functions
Unit 10: Controlling Program Flow and Making Decisions
Unit 11: Automatic Procedures and Events
Unit 12: Error-Handling Techniques
Unit 13: Bug Extermination Techniques
Unit 14: VBA Programming Examples
Unit 15: Simple Dialog Boxes



Who Should Attend
This course is intended for Programmers/Developers, Managers in small / medium enterprises and people who work with Excel intensively in positions where automation of Excel tasks is imperative such as Accountants, Actuaries, Financial Controllers, Project Managers, Scientific personnel that wishes to build macros to automate routines

Objectives
  • Describe the Essential VBA Language  Elements
  • Distinguish between VBA Sub and Function Procedures
  • Name and Describe Looping techniques/commands
  • Use the Excel Macro Recorder
  • Create Macros with Range Objects
  • Control flow of Sub and Functions Procedures with Decisions and Looping
  • Create Automatic Procedures and Events
  • Apply Error-Handling Techniques
  • Use Bug Extermination Techniques
  • Create Simple Dialogue boxes for data input


Prerequisites
Participants should have a very good knowledge of Excel.

Methodology
Lecture, discussion, demonstration and practice.



Find Training Courses
Name
Type
v
Category
v
 

© EDUCATION & INFORMATION TECHNOLOGY CENTRE (EDITC). All Rights Reserved. Developed by CMP POLYMEDIA LTD