SPIT 013 : MS Excel 2013 – MOS Exam 77-420

SPIT 013 : MS Excel 2013 – MOS Exam 77-420

Mr. Fazel Pasha
  • course description:

    This course prepares the participants for the official Microsoft Office Specialist (MOS) MS Excel 2013 Exam 77-420.

  • course learning outcomes:

    At the end of the course, the participants will be able to;
    - Create and Manage workbooks and worksheets.
    - Manage cells and ranges.
    - Manage tables.
    - Apply formulas and functions.
    - Create charts and objects.
    - Prepare participants to take MOS certification.

  • Course outlines:

    - Create workbooks and worksheets.
    - Navigate through worksheets and workbook.
    - 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 tables.
    - Modify tables.
    - Filter and sort tables.
    - Utilize cell ranges and references in formulas and functions.
    - Summarize data by using functions.
    - Utilize conditional logic in functions.
    - Format and modify text by using functions.
    - Create charts.
    - Format charts.
    - Insert and format objects.

  • practical aspects of the course:

    - All training hours will be conducted in a computer lab equipped with Microsoft Office suite. The MOS certification exams will be conducted on JIC’s Certiport Authorized Testing Center (CATC).

  • who should attend?

    - The participant should has at least six months of experience using all aspects of the MS Excel application on a regular basis.
    - Proficiency in English language and proficiency in doing basic computer tasks.
    - At least High-school diploma.

  • duration:

    5 Days


    Click here