Microsoft Certified Trainer

in 1 days, with 10 revisions

You must sign in to purchase

$50 START DISCUSSION

Service Description

Get training from Excel Expert with 100% Practical and scenario-based classes.

Topics Covered for Excel Training Mentioned Below:

Create and manage Worksheets and Workbooks

Navigate in Worksheets and Workbooks

Format Worksheets and Workbooks

Apply Custom Data Formats and Validation

Apply Advanced Conditional Formatting and Filtering

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

Summarize Data and look up Data by using Functions.

Apply Advanced Date and Time Functions

Perform Conditional Operations by using Functions.

Format and Modify Text by using Functions.

Generate numeric data by using RANDBETWEEN, RANDARRAY and SEQUENCE

Get unique values by using the UNIQUE function.

Format text by using the CONCAT and TEXTJOIN functions.

Forecast data by using the AND, IF, and NPER functions

Perform Data Analysis and Business Intelligence

Troubleshoot Formulas

Create and Format Charts

Create and Manage PivotTables and Pivot Charts

You can master yourself by taking training from Microsoft Certified Trainer (MCT)