Training ini memberikan pengetahuan, skill dan praktek untuk mengambil ujian sertifikasi Microsoft Office Specialist (MOS) dengan materi Microsoft Excel 2010 Expert. Topik-topik yang dibahas sesuai dengan Exam Objectives yang dikeluarkan oleh Microsoft. Anda berhak mendapatkan title sertifikasi MOS Expert apabila lulus dalam mengikuti ujian tersebut.

Durasi : 2 hari

• Sharing and Maintaining Workbooks
  • Apply Workbook Settings, Properties, and Data Options
  • Apply Protection and Sharing Properties to Workbooks and Worksheets
  • Maintain Shared Workbooks

• Applying Formulas and Functions
  • Audit Formulas
  • Manipulate Formula Options
  • Perform Data Summary Tasks
  • Apply Functions in Formulas

• Presenting Data Visually
  • Apply Advanced Chart Features
  • Apply Data Analysis
  • Apply and Manipulate PivotTables
  • Apply and Manipulate PivotCharts
  • Use External Data Sources

• Working with Macros and Forms
  • Create and Manipulate Macros
  • Insert and Manipulate Form Controls