| |
|
|
Information Technology Programmes
Duration:
1 day, from 8:30 am to 4:30 pm
Training dates:
Thai: Tue., 10 June 2008
English: Thu., 12 June 2008
Venue: IT Learning Lab, UNESCAP Learning Centre, 3 rd 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:
•
•
•
•
•
•
•
•
•
•
•
•
•
•
|
Understanding Worksheets
Understanding Excel Layouts
Entering Data
Types of Data
Formatting data
Inserting Rows, Columns, Worksheets
Deleting Rows, Columns, Worksheets
Linking Worksheets
Working with Formula
Working with Auto formatting
Working with Data
- Sorting
- Filter
(Auto and
Advance filter)
Working with Sheets
- Sheet Synchronization
- Moving & Copying Sheets
- Renaming Sheets
Tips & Tricks
- Protect Workbook
- Protect Sheet
- Protect Formula
- Network Sharing
- Relative & Absolute Cell Address
- Conditional Formatting
Practice Sessions |
Contact person: Ms. Vanviva Bhumibhanit, extension no. 2020
|
|
