| |
|
|
Information Technology Programmes
Duration:
1 day, from 8:30 am to 4:30 pm
Training dates:
Thai: Tue., 8 July 2008
English: Thu., 10 July 2008
Venue: IT Learning Lab, UNESCAP Learning Centre, 3rd floor of UNCC
Facilitator: APTECH Education
Target audience: Staff from UNESCAP and participating UN agencies in the Common IT Training initiative of the Operations Management Team - Bangkok
Course outline:
|
Revision of Excel & Level understanding
Validating Data
Working with Sub-Total
- 2 Dimensional Reports
Working with Pivot Table Reports
- 3 Dimensional Reports
Linking different workbooks
Transfer Data to Word & PowerPoint
Import Data
- Access
- Internet
- SQL Server
- Text File
Automating Job
- Creating Macro
- Macro Programming
- Creating Forms
- Working with Visual Basic for Application (VBA)
.......Complete Programming with VBA
.......Making Own Forms for Data Entry with Validations
- Creating Your Menu
- Creating Your Tool Bar
VBA Advance Programming
- Creating Customized Forms
- Linking Sheets and Files
- Working with Advance level of Interaction of Sheets
|
Contact person: Ms. Vanviva Bhumibhanit, extension no. 2020
|
|
