Microsoft Office 2010 / 2013
Microsoft Word - Beginner
Duration : 1 Day
Price : RM 200
Microsoft Word - Intermediate
Duration : 1 Day
Price : RM 300
Microsoft Word - Advanced
Duration : 1 Day
Price : RM 400
Microsoft Excel - Beginner
Duration : 1 Day
Price : RM 200
Microsoft Excel - Intermediate
Duration : 1 Day
Price : RM 300
Microsoft Excel - Advanced
Duration : 1 Day
Price : RM 400
Microsoft PowerPoint - Beginner
Duration : 1 Day
Price : RM 200
Microsoft PowerPoint - Intermediate
Duration : 1 Day
Price : RM 300
Microsoft PowerPoint - Advanced
Duration : 1 Day
Price : RM 400
Microsoft Access - Beginner
Duration : 1 Day
Price : RM 400
Microsoft Access - Intermediate
Duration : 1 Day
Price : RM 600
Microsoft Access - Advanced
Duration : 1 Day
Price : RM 800
Microsoft Outlook - Beginner
Duration : 1 Day
Price : RM 200
Microsoft Outlook - Intermediate
Duration : 1 Day
Price : RM 400
Microsoft Outlook - Advanced
Duration : 1 Day
Price : RM 600
Microsoft SharePoint 2010 / 2013 for End Users / Power Users
End Users Guide to SharePoint
Duration : 2 Day
Price : RM 1,500
Power Users Guide to SharePoint (Site Admin/Site Owner)
Duration : 3 Day
Price : RM 2,000
Programming in Excel
Excel VBA - Beginner
Duration : 3 Day
Price : RM 1,500
Excel VBA - Intermediate
Duration : 3 Day
Price : RM 1,500
Excel VBA for Absolute Beginners
Duration: 3 Days; Instructor-led
WHAT YOU WILL LEARN
This course provides an introduction to programming for students with little or no prior programming experience. Through this course, students 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 this course can be applied to MS-Excel 2003, MS-Excel 2007, MD-Excel 2020 and MS-Excel 2013.
This is the entry level course for more advanced Excel VBA programming.
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? (Few interesting examples)
- Using the development Integrated Development Environment.
- The project explorer - Introduction to the VBA project concept and project components
- The property Window
- The IDE main menu
- Switching between Excel normal interface and IDE interface.
- Help system
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 instructions
- 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)
- Procedures (Functions)
- Procedures (Event Handlers)
- Pre-mature terminations with Exit keyword
- Grouping instructions using With statement
Module 6 - Modules
- Why module is needed?
- Code Module
- User Form in brief
- Class module in brief
- Workbook module in brief
- Procedures scoping
- Dealing with ambiguities
Module 7 - When you make mistake
- Type of errors
- Dealing with compilation errors
- Dealing with runtime errors
- Dealing with logical errors The debugger and debugging process
Module 8 - The variables
- Why variables are needed?
- Basic Data Types
- Variable declaration and shorthand
- Variable scoping and life cycle
- Variable initialization
- Option Explicit directive
Module 9 - Useful VBA native functions
- MsgBox function
- InputBox function
- Number functions
- String functions
- Date/Time functions
- Format function
- RGB function
Module 10 -Other useful basic VBA entities
- Comments
- VBA Constants
- Excel Constants
- Defining constants
- Selection keyword
- Application object
- ActiveSheet object
- Sheets collection
- Workbooks collection
Module 11 - The Parameter
- What is parameter?
- Optional parameters and techniques to handle default values
- Arbitrary argument support using ParamArray declaration
- Parameter passing mechanisms: ByVal vs. ByRef
- Named arguments
Module 12 - Operators
- What is operator?
- Arithmetic operators
- Comparison Operators
- Logical Operators
- Special Operators
Module 13 - Branching Constructs
- Unconditional Branching with GoTo statement
- Unconditional Branching with GoSub statement
- If..Then..Else Statement
- Select Case Statement
Module 14 - Iteration Constructs
- Unconditional Loop with GoTo statement
- Using For Loop
- Using For Each statement
- Pre-test looping
- Post-Test looping
- Pre-mature termination using Exit keyword
Intermediate Excel VBA
Duration: 3 Days; Instructor-led
WHAT YOU WILL LEARN
This course is the follow up course of آExcel VBA for Absolute Beginnersآ. It provides more in depth understanding the VBA language under MS-Excel environment. Through this course, new VBA developers can learn how to leverage more advanced features of VBA.
The knowledge and skill gained from this course can be applied to MS-Office 2003, MS-Office 2007 and MS-Office 2010.
AUDIENCE
Any of the Microsoft office users that already knows fundamentals Excel VBA programming. This is not the first VBA course.
PREREQUISITES
Before attending this course, students must be able to demonstrate the following skills:
- Familiarity with the general operations of Microsoft Windows operating system.
- Basic knowledge and skill in using any version of Microsoft Excel.
- Basic Excel VBA programming
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 is aim to introduce some of the challenging aspects of Excel VBA programming which is not normally known by new Excel VBA developers
At the end of the course, students will be able to write more advance Excel VBA code to tackle real life problems.
COURSE OUTLINES
Module 1 - Homogeneous Complex types
- Single Dimensional Array
- Option Base directive
- LBound and UBound functions
- Multi Dimensional Array
- Jagged Array
- Dynamic Array
Module 2 - Heterogeneous Complex types
- Using Type..End Type
- The Dot Notation
- Abstract Data Type with Class Module
- Defining and using class module properties
- Creating objects from class module
- The Set keyword
Module 3 - Special System types
- Object
- Collection
- Shapes
Module 4 - Error Handling
- Ignoring errors
- Setup Error Handlers
- Using Error Number
- Raise Error
- Clear Error handler
Module 5 - Using Excel Names in VBA
- What is Name?
- Address independent programming
- Name for single cell
- Name for literal value
- Name for expression
- Name for multi-cells range
Module 6 - Using Excel Tables in VBA
- What is Table?
- Create and destroy tables
- Advantages of using table in VBA
- Accessing to single table column
- Accessing to table header
- Other table handling techniques
Module 7 - Program Excel worksheets
- Event driven programming
- Events and Event handlers
- Techniques for disabling and enabling event
- SelectionChange event
- Change event
- Activate event
- Deactivate event
- BeforeDoubleClick event
- BeforeRightClick event
- Calculate event
Module 8 - Program Excel worksheets
- Event driven programming
- Events and Event handlers
- Techniques for disabling and enabling event
- SelectionChange event
- Change event
- Activate event
- Deactivate event
- BeforeDoubleClick event
- BeforeRightClick event
- Calculate event
Module 9 - ActiveX Controls
- What is ActiveX control?
- Comparing form controls and Active controls
- Design View
- Control properties
- Control events
- Button
- ComboBox
- ListBox
- CheckBox
- RadioButton
Module 10 - Program Excel workbook
- Open events
- BeforeClose events
- NewSheet event
- How to define event handlers for all worksheets?
Module 11 - Advance System Dialog Boxes
- How to select single file name?
- How to select multiple file names?
- Color selection
- Font Selection
- Alternative techniques
Module 12 - The User Form
- The purpose
- How to declare?
- How to call it?
- Form Controls
- The tool box
- Controls events
- Form events
- Field based validation
- Form based validation
- Building custom dialog box
Module 13 - Advanced Techniques
- How to borrow Excel functions from VBA
- Using Application.ScreenUpdating property
- Worksheet level custom validation
- Using Find method with region
Module 14 - Common Pitfalls
- Using Application.Volatile
- Reentrant issue
- Dealing with Undo
