MS Excel Training for Microsoft Office Specialist Certification


This MS Excel 2013 Course has been designed for students, clerical workers, book keepers, and instructors, to provide them with a basic knowledge of using the various features of Excel. By enrolling for the course, the students can practice working on Excel for creating budgets, charts, sales invoices, exercise logs, and much more. The course aims to equip the students to appear for the MOS:


Ms Excel


After completing, participants should be able to:

✔    Create, format, manage, and navigate through worksheets & workbooks

✔    Customize options & views for worksheets & workbooks, and configure them to print/save

✔    Fill in data, format, order, and group cells & ranges

✔   Create, modify, filter, & sort a table

✔    Use of various functions, such as, SUM, MIN, MAX, COUNT, AVERAGE, SUMIF, AVERAGEIF, COUNTIF, RIGHT, LEFT, MID, TRIM, UPPPER, LOWER, & CONCATENATE

✔    Create and format charts & objects

Module: 77-420

  • Create and manage worksheets and workbooks:

    • 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
  • Create cells and ranges:

    • Insert data in cells and ranges
    • Order and group cells and ranges
    • Format cells and ranges
  • Create tables:

    • Create a table
    • Modify a table
    • Filter and sort a table
  • Apply formulas and functions:

    • 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 charts and objects:

    • Create a chart
    • Format a chart
    • Insert and format an object

Duration: 32 Hours

EXAM (77-427)

  • Manage and share workbooks

    • Manage workbook changes
  • Apply custom formats and layouts

    • Apply advanced conditional formatting and filtering
    • Prepare a workbook for internationalisation and accessibility
  • Create advanced formulas

    • Look up data with functions
    • Apply advanced date and time functionse
    • Filter and sort a table
  • Create advanced charts and tables

    • Create advanced chart elements
    • Create and manage PivotTables
  • Create charts and objects:

    • Create a chart
    • Format a chart
    • Insert and format an object

EXAM (77-428)

  • Manage and Share Workbooks

    • Manage multiple workbooks
  • Apply custom formats and layouts

    • Apply custom data formats
  • Create advanced formulas

    • Apply functions in formulas
    • Create scenarios
  • Create advanced charts and tables

    • Create and manage PivotCharts
Batch Date Course Duration
Citrix Authorize Learning Center Microsoft Partner Network Summer Training Training Center Amcat Partner Network
Testimonials
Enquiry Button
x

Fill this form to Enquiry us


       6 + 5   =
L G Y