This course is included under the “Training Scheme for Human Resources Upgrading”.Practice exam for MS Office Specialist is available in English by appointment for appointment, please call CPTTM Registry at Head Office (tel:88980801).Under all circumstance students must complete their exams during the 1-month validity period
For those students who met the attendance requirement and scored 85% or above in the CPTTM exam, they will be sponsored to take one "MS Office Specialist" exam free-of-charge. Students who passed the CPTTM exam will be awarded a coupon for taking one "MS Office Specialist – Excel" exam at a preferential exam fee of MOP270 (regular price MOP380).Qualification certification awarded by the relevant public examination authority, if applicable.Completion certificate issued by CPTTM (for students who have attained at least 80% attendance and passed the CPTTM assessment) and.Those who pass the assessments and whose attendance is 80% or greater will be reimbursed 75% of the fee Those who pass the assessments but whose attendance is 50% or greater but less than 80% will be reimbursed 50% of the fee Those who fail in the assessments but whose attendence is 80% or greater will be reimbursed 50% of the fee.ĬPTTM Head Office (Rua de Xangai 175, Edf. Handouts in Chinese (supplemented with English terminology)ġ9:00-22:00, from to every Wednesday, Friday. In the Move or Copy dialog box, use the drop-down boxes to select the name of the workbook you will move the. Should have a good working knowledge of Microsoft Excel (as in MG33.1 ) Choose Edit Move or Copy from the menu bar.
#How to consolidate data in excel 2003 plus
Trace formula precedents, dependents, and errors.Create PivotTable and PivotChart reports.Perform data analysis using automated tools.Add, show, close, edit, merge and summarize scenarios.Upon completion of the course, participants should have acquired the essential skills of using Microsoft Excel professionally at a more advanced level.