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

Durasi : 3 hari

• Managing the Worksheet Environment
  • Navigate Through a Worksheet
  • Print a Worksheet or Workbook
  • Personalize the Excel Environment

• Creating Cell Data
  • Construct Cell Data
  • Apply Auto Fill
  • Apply and Manipulate Hyperlinks

• Formatting Cells and Worksheets
  • Apply and Modify Cell Formats
  • Merge or Split Cells
  • Create Row and Column Titles
  • Hide or Unhide Rows and Columns
  • Manipulate Page Setup Options for Worksheets
  • Create and Apply Cell Styles

• Managing Worksheets and Workbooks
  • Create and Format Worksheets
  • Manipulate Window Views
  • Manipulate Workbook Views

• Applying Formulas and Functions
  • Create Formulas
  • Enforce Precedence
  • Apply Cell References in Formulas

• Apply Conditional Logic in Formulas
  • Apply Named Ranges in Formulas
  • Apply Cell Ranges in Formulas

• Presenting Data Visually
  • Create Charts Based on Worksheet Data
  • Apply and Manipulate Illustrations
  • Create and Modify Images
  • Apply Sparklines

• Sharing Worksheet Data with Other Users
  • Share Spreadsheets
  • Manage Comments

• Analyzing and Organizing Data
  • Filter Data
  • Sort Data
  • Apply Conditional Formatting