Home Search again Enrollment procedure
Sorry, JavaScript required!

Professional Microsoft Office Skills - Excel 2010

Title Professional Microsoft Office Skills - Excel 2010
Course code MG33-11-2015-C
Objective Upon completion of the course, participants should have acquired the essential skills of using Microsoft Excel professionally and is capable to take the Microsoft Office Specialist (MOS) exam.
1. Managing the Worksheet Environment
  • Navigate through a worksheet
  • Print a worksheet or workbook
  • Personalize environment by using Backstage
2. Creating Cell Data
  • Construct cell data
  • Apply AutoFill
  • Apply and manipulate hyperlinks
3. Formatting Cells and Worksheets
  • Apply and modify cell formats
  • Merge or split cells
  • Create row and column titles
  • Hide and unhide rows and columns
  • Manipulate page setup options for worksheets
  • Create and apply cell styles
4. Managing Worksheets and Workbooks
  • Create and format worksheets
  • Manipulate window views
  • Manipulate workbook views
5. Applying Formulas and Functions
  • Create formulas
  • Enforce precedence
  • Apply cell references in formulas
  • Apply conditional logic in a formula
  • Apply named ranges in formulas
  • Apply cell ranges in formulas
  • Audit formulas.
  • Manipulate formula options
  • Perform data summary tasks.
  • Apply functions in formulas
6. Presenting Data Visually
  • Create charts based on worksheet data
  • Apply and manipulate illustrations
  • Create and modify images by using the Image Editor
  • Apply Sparklines
  • Apply advanced chart features
  • Apply data analysis
  • Apply and manipulate PivotTables
  • Apply and manipulate PivotCharts
7. Sharing Worksheet Data with Other Users
  • Share spreadsheets by using Backstage
  • Manage comments
8. Analyzing and Organizing Data
  • Filter data
  • Sort data
  • Apply conditional formatting
9. Sharing and Maintaining Workbooks
  • Apply workbook settings, properties, and data options
  • Apply protection and sharing properties to workbooks and worksheets
  • Maintain shared workbooks
10. Working with Macros and Forms
  • Create and manipulate macros
  • Insert and manipulate form controls
Assessment In-class exercises, assignments and exam
Target audience
  • Individuals who are interested in mastering the skills of using Microsoft Excel.
  • Individuals who intend to take "MOS" Exam.
Prerequisite A basic knowledge of using PCs, a keyboard, a mouse, MS Windows is required.
Class size 20
Instructor CPTTM appointed instructor, Microsoft Office Specialist (MOS) certified.
Instruction language Cantonese
Handout language Handouts in Chinese (supplemented with English terminology)
Duration 21 hours in 7 sessions
Schedule 19:00-22:00, from Nov 25, 2015 to Dec 16, 2015 every Monday, Wednesday.
Fee MOP890
Venue CPTTM Head Office (Rua de Xangai 175, Edf. ACM 7 Andar, Macau)
Certificate Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code ---
  • Approved Course under the SAR Government "Continuing Education Development Program", Code: 1504320014
  • Microsoft Office Specialist Exam fee : MOP600
  • Supporting: Microsoft Macau
  • Practice exam for MOS is available in English by appointment, please call CPTTM at tel:88980801
Sorry, JavaScript required!