EDITC - Education & Information Technology Centre

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