| |
|
|
Information Technology Programmes
Duration:
1 day, from 8:30 am to 4:30 pm
Training dates:
Thai: TBD
English: TBD
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 on Basics of Excel
- Data Entry
- Formatting
Revision on Data Menu
- Filtering
- Validations
- Subtotal Reports
- Forms
- Pivot Table Reports and Charts
- Consolidation
Revisiting Shortcuts
Frequently asked Questions and Solutions
Practice Session
Refreshing macros
- MacrSecurity
- Creating Macros
- Running Macros
Working on Analysis
- Goal Seek
- Solver
- Scenarios
Working with Functions
- Text
- Number
- Date
- Lookup
- Programming
Creating Profession Workbooks
Workbooks from Templates
Protecting Files, Sheets and Formula Cells
Workbooks from Online Templates
Useful tips & tricks
Practice Session
|
Contact person: Ms. Vanviva Bhumibhanit, extension no. 2020
|
|
