Wawasan Professional Training Centre
Construction | Engineering | Management | Information Technology
E034 Engineering Advance Excel for Engineers 2 Days

BEM Approved 12 CPD Hours (Ref No: IEM09/PP/049/W) Normal Price RM 1500.00
(If 2 or more RM 1200.00 per person Only)
Introduction
PREREQUISITES:
Basic knowledge on Microsoft Excel
Bring your own notebook
Microsoft Excel 2007

Microsoft Excel spreadsheet is popularly used for computations as it has ability to record and display in detail computation steps and also feature of presenting results in the form of graph and summary tables. With the help of VBA (Visual Basic for Applications), engineers can further increase the power of EXCEL spreadsheet that allowing engineers to automate various aspects of engineering computations.
Who are the speakers?
Qualification : Degree in Civil Engineering from Universiti Pertanian Malaysia (Now call Universiti Putra Malaysia)
Strength : He developed software for analyses and design of RC structures, drains, sewers and earthworks.
He also develops software that works on handheld computers and is considering developing application that work on the web.
Current job : Managing Director of C & S Software Solution Sdn. Bhd.
Biodata : Mr. Chee Shai Choon is the Managing Director of C & S Software Solutions Sdn. Bhd., a software provider for civil and structural engineering applications. He has had 14 years programming experience and has developed software for analyses and design of RC structures, drains, sewers and earthworks. Many of his applications work with popular CAD software to automate the output of engineering drawings. He also develops software that works on handheld computers and is considering developing application that work on the web. The latest software built is the Urban Stormwater Design where to MSMA guide line. His website http://www.civilstructural.com.my
 
Objectives
Benefits
Sessions and Scopes
Session Scope Speaker
Session 1
Day 1
0830-0850
Registration
Session 2
Day 1
0850-0900
Introduction of Speaker
Session 3
Day 1
0900-1000
SECTION 1:
What is VBA?
Mr. Chee Shai Choon
Session 4
Day 1
1000-1015
Refreshment
Session 5
Day 1
1015-1200
SECTION 2:
What you can do with VBA
Mr. Chee Shai Choon
Session 6
Day 1
1200-1300
Lunch
Session 7
Day 1
1300-1500
SECTION 3:
Data types, operators
Mr. Chee Shai Choon
Session 8
Day 1
1530-1545
Refreshment
Session 9
Day 1
1500-1600
SECTION 4:
VBA commands
Mr. Chee Shai Choon
Session 10
Day 1
1600-1700
SECTION 5:
Microsoft Visual Basic Editor
Mr. Chee Shai Choon
Session 11
Day 2
0830-0900
Registration
Session 12
Day 2
0900-1100
SECTION 5:
Microsoft Visual Basic Editor
Mr. Chee Shai Choon
Session 13
Day 2
1000-1015
Refreshment
Session 14
Day 2
1100-1200
SECTION 6:
Debugging
Mr. Chee Shai Choon
Session 15
Day 2
1200-1300
Lunch
Session 16
Day 2
1300-1500
SECTION 7:
Coding good practices
Mr. Chee Shai Choon
Session 17
Day 2
1530-1545
Refreshment
Session 18
Day 2
1500-1600
SECTION 8:
How to self help in VBA?
Mr. Chee Shai Choon
Session 19
Day 2
1600-1700
SECTION 9:
VBA resources
Mr. Chee Shai Choon
Session 20
Day 2
1700-1715
Question & Answer
Session 21
Day 2
1715-1730
Distribution of Certificate
Date, Time, Venue, and Fee
Date and time : 8-1-2010 & 9-1-2010 (Friday & Saturday) 0900 - 1700
Venue : Seminar Hall,First Floor, Wisma Wawasan,
No.19-1, Jalan PJS8/12, Dataran Mentari,
Bandar Sunway, 46150 Petaling Jaya,
Selangor Darul Ehsan
Location map : See location map
Fee : Normal Price RM 1500.00
(If 2 or more RM 1200.00 per person Only)
Who should attend?
Civil Engineer, Geotechnical Engineer, Structural Engineers, Building & Piling Contractors, Consultants, Project Manager, RE.
Course related information (FREE)
Additional notes
Certificate of CPD Point with full attendance
4 tea breaks & 2 lunch provided
Handout notes
Class capacity = 30