Level 2Excel (Core)

Overview

Microsoft Office Specialist (MOS)  is a valuable credential that recognizes the desktop computing skills needed to use the full features and functionality of the Microsoft Office suite.

Microsoft Office Specialist (MOS) is a premier industry recognized certification that provides validation of students’ knowledge, skills and abilities relating to the Microsoft Office applications.

Successful Students for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016.

Students will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Course content:

• Create Worksheets and Workbooks
• Navigate in Worksheets and Workbooks
• Format Worksheets and Workbooks
• Customize Options and Views for Worksheets and Workbooks
• Configure Worksheets and Workbooks for Distribution
• Insert Data in Cells and Ranges
• Format Cells and Ranges
• Summarize and Organize Data
• Create and Manage Tables
• Manage Table Styles and Options
• Filter and Sort a Table
• Summarize Data by using Functions
• Perform Conditional Operations by using Functions
• Format and Modify Text by using Functions
• Create Charts
• Format Charts