EDITC - Education & Information Technology Centre

Schedule

Training Course Schedule

Automating Excel Functions and Routinces with VBA in Microsoft Excel WEBINAR

Code:	ED21A13
Type:	IT InstructorLed Courses
Category:	Visual Basic For Applications
Course:	Automating Excel Functions and Routinces with VBA in Microsoft Excel

Date:	24 Jun 2021 08:15 - 7 Jul 2021 16:00

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 (4 days)
Location:	Webinar
Language:	Greek
Attendance:	6-28
Speaker:	Maria Knais

Price:	€770.00

Subsidy:	€336.00

Total:	€434.00

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.

TimeTable

Thursday, 24/06/2021 8.15 - 16.00
Saturday, 26/06/2021 8.15 - 16.00
Wednesday, 30/06/2021 8.15 - 16.00
Wednesday, 07/07/2021 8.15 - 16.00