Microsoft Office Specialist Excel Certification| Microsoft Excel Expert Training | MOS Excel | Excel Certification

Authorized Training and Certification/Testing centre

MOS: Microsoft Office Excel Expert

Course Description

Course Curriculum: MOS: Microsoft Office Excel Expert

Prerequisites

(Click to find out more) +–

Before you start this Course please learn "Microsoft Office Excel Associate" Course.

Course context

64 Lectures

00 : 00 : 00

+

Syllabus work in Progress

1 Lectures 00 : 00 : 00

Syllabus work in Progress

+

Manage Workbooks

6 Lectures 00 : 00 : 00

Save a workbook as a template

Copy macros between workbooks

Reference data in another workbook

Reference data by using structured references

Enable macros in a workbook

Display hidden ribbon tabs

+

Manage Workbook Review

6 Lectures 00 : 00 : 00

Restrict editing

Protect a worksheet

Configure formula calculation options

Protect workbook structure

Manage workbook versions

Encrypt a workbook with a password

+

Apply Custom Data Formats and Validation

7 Lectures 00 : 00 : 00

Create custom number formats

Populate cells by using advanced Fill Series options

Configure data validation

Apply Advanced Conditional Formatting and Filtering

Create custom conditional formatting rules

Create conditional formatting rules that use formulas

Manage conditional formatting rules

+

Create and Modify Custom Workbook Elements

5 Lectures 00 : 00 : 00

Create custom color formats

Create and modify cell styles

Create and modify custom themes

Create and modify simple macros

Insert and configure form controls

+

Prepare a Workbook for Internationalization

3 Lectures 00 : 00 : 00

Display data in multiple international formats

Apply international currency formats

Manage multiple options for +Body and +Heading fonts

+

Apply Functions in Formulas

3 Lectures 00 : 00 : 00

Perform logical operations by using AND, OR, and NOT functions

Perform logical operations by using nested functions

Perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions

+

Look up data by using Functions

4 Lectures 00 : 00 : 00

Look up data by using the VLOOKUP function

Look up data by using the HLOOKUP function

Look up data by using the MATCH function

Look up data by using the INDEX function

+

Apply Advanced Date and Time Functions

2 Lectures 00 : 00 : 00

Reference the date and time by using the NOW and TODAY functions

Serialize numbers by using date and time functions

+

Perform Data Analysis and Business Intelligence

5 Lectures 00 : 00 : 00

Import, transform, combine, display, and connect to data

Consolidate data

Perform what-if analysis by using Goal Seek and Scenario Manager

Use cube functions to get data out of the Excel data model

Calculate data by using financial functions

+

Troubleshoot Formulas

4 Lectures 00 : 00 : 00

Trace precedence and dependence

Monitor cells and formulas by using the Watch Window

Validate formulas by using error checking rules

Evaluate formulas

+

Define Named Ranges and Objects

4 Lectures 00 : 00 : 00

Name cells

Name data ranges

Name tables

Manage named ranges and objects

+

Create Advanced Charts

3 Lectures 00 : 00 : 00

Add trendlines to charts

Create dual-axis charts

Save a chart as a template

+

Create and Manage PivotTables

7 Lectures 00 : 00 : 00

Create PivotTables

Modify field selections and options

Create slicers

Group PivotTable data

Reference data in a PivotTable by using the GETPIVOTDATA function

Add calculated fields

Format data

+

Create and Manage Pivot Charts

4 Lectures 00 : 00 : 00

Create PivotCharts

Manipulate options in existing PivotCharts

Apply styles to PivotCharts

Drill down into PivotChart details