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