EXCEL VBA (BEGINNER)
3 days



Public Program Available on 22-24 June 2015
Venue: Menara UOA Bangsar,KL
Fee: RM 1,300/pax (Group Registration - 3 pax and above enjoy 20% Off)
Email to aliff@timeslotsnetworks.com

INTRODUCTION

This Excel VBA training empowers you to take control of your data using relational database software to manage information that helps you store information for reference, reporting and analysis. It can help you to overcome limitations you may find when you try to manage large amounts of information in Excel or other spreadsheets.

Excel VBA for Absolute Beginners provides an introduction to programming for students with little or no prior programming experience. Through this course, you will gain a strong, accessible, hands-on foundation in the language skills needed for learning Visual Basic for Applications (VBA) under MS-Excel environment.

The knowledge and skill gained from these courses can be applied to MS-Excel 2003, MS-Excel 2007 and MS-Excel 2010.


AUDIENCE

Any Microsoft Excel users whoever want to do extra ordinary thing from their Microsoft excel applications where but limited by the predefined features. This includes those who know nothing about computer programming.


PREREQUISITES

Before attending this course, students must be able to demonstrate the following skills:
· Ability to use a computer keyboard and a mouse
· Familiarity with the general operations of Microsoft Windows operating system.
· Basic knowledge and skill in using Microsoft-Excel (Any version).
The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.

TRAINING TOOLS
· MS Windows XP Professional SP3 or higher
· MS Excel 2003/2007/2010/2013 (Depends on the target audience)
· Host PC: Any PC and OS support MS-Excel

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.



COURSE OBJECTIVES

This course introduces students to the techniques used in the key areas of computer programming:
· Programming principles
· Basic program control structures
· Data types
· Subroutines and Functions
At the end of the course, students will be able to start creating simple VBA solution by using MS-Excel.

COURSE OUTLINES

Module 1 - Introduction

· What is VBA? Why need to do programming for MS-Excel ? What can we do with Excel VBA? (with interesting examples)
· Using the development Integrated Development Environment.
· The project explorer - Introduction to the VBA project concept and project components
· Switching between Excel normal interface and IDE interface.
· And more......
Module 2 – Automation via Macros

· Why we need automation in MS-Excel?
· What is macro?
· Recording macros
· How to trigger macros from Excel normal interface?
· How to trigger macros from VBA IDE?
Module 3 – Using instructions
· The immediate window
· What is instruction?
· Evaluation & Command instructions
· Dealing with Excel VBA objects and their properties
Module 4 – Linking VBA with Excel

· Single cell reference methods
· Range reference methods
· Inter-worksheets reference)
· Inter-workbook reference
Module 5 –The instructions building block
· The Procedure concept
· Procedures (Subroutines, Functions, Event Handlers)
· Pre-mature terminations with Exit keyword
· Grouping instructions using With statement
Module 6 –Modules

· Why module is needed?
· Code Module
· User Form, Class module, Worksheet in brief
· Procedures scoping
· And more......
Module 7 –When you make mistake…

· Type of errors
· Dealing with compilation, runtime or logical errors
· The debugger and debugging process

CONTACT US FOR COURSE DETAILS AND AVAILABILITY!