Training Syllabus

Microsoft Office Specialist
Excel 2013

 

Exam Track: MOS 77-420

Durasi: 3 (Tiga) Hari

Outline Materi:

  • Create Worksheets and Workbooks
  • Navigate through Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Configure Worksheets and Workbooks to Print or Save
  • Insert Data in Cells and Ranges
  • Format Cells and Ranges
  • Order and Group Cells and Ranges
  • Create a Table
  • Modify a Table
  • Filter and Sort a Table
  • Utilize Cell Ranges and References in Formulas and Functions
  • Summarize Data with Functions
  • Utilize Conditional Logic in Functions
  • Format and Modify Text with Functions
  • Create a Chart
  • Format a Chart
  • Insert and Format an Object