| |
|
|
Information Technology Programmes
Duration:
1 day
Training date: TBA
Venue: IT Learning Lab, UNESCAP Learning Centre
Facilitator: TBA
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.
Woranan Thoophom, ext. 2693
|
|
