FREE TODAY ONLY! Learn Microsoft Excel Advanced

Coupon Details

FREE TODAY ONLY! Learn Microsoft Excel Advanced, FREE FOR TODAY ONYL! Learn Microsoft Excel Advanced from Microsoft Certified Trainer

Created by Info Trek

Preview This Course - GET COUPON CODE

What Will I Learn?

• Microsoft Excel advance level

Description

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Have attended Microsoft Excel – Foundation and Intermediate Level; OR

Able to use and apply Database function

Able to use and apply Logical function (IF, AND)

Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)

Able to use and apply Mathematical function (SUMIF, SUMIFS)

Able to use and apply Lookup function (VLOOKUP)

Able to use Auto and Advanced Filter command

Able to validate data

Able to apply Conditional Formatting

Able to Protect worksheet and workbook

Upon completion of this program, participants should be able to:

Advance Chart function and PowerPivot Function

Analyze data Using Pivot Tables

Perform What If Analysis using:

Goal Seek

Solver

Input Table

Scenarios

Use VLOOKUP function to extract data

Nesting INDEX and MATCH Function

Combining & Consolidating Data

Create Hyperlink in a workbook

Location:

Share :