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