Excel 2007 Expert-Excel Expert takes you to the next level

Excel Expert takes you to the next level

Excel 2007 Expert

Excel Expert takes you to the next level

A brief summary

This is a Technical Specialist exam designed to assess candidates’ hands ‐ on skills using Microsoft Office Excel 2010 at the Expert level. We are specifying an item pool of 75 unique performance ‐ based tasks. Items should be written to the Application cognitive level. For more information about cognitive levels, refer to the Cognitive Domain in Bloom’s Taxonomy Who should take this exam? Expert-level Microsoft Office Excel 2010 users are able to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Expert users are proficient with advanced formulas, functions, and data analysis tools. Expert users can manipulate data for analysis, presentation, and collaboration. In addition, expert users can manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.

Instructor:

Priti

What you will learn

Capturing Data

Calculating Data by Using Advanced Formulas

Managing Data Ranges

Summarizing and Analyzing Data

Formatting Worksheet and Chart Content

Managing Macros and User-Defined Functions

Course Fee: Rs. 1380.00

Certification By: Microsoft

Capturing Data

Restrict data entry by using data validation, Link Form controls to cells, Import data from an external source, Link to data in an external source

Calculating Data by Using Advanced Formulas

Create formulas that combine Lookup & Reference and Statistical functions, Create formulas that combine Date & Time, Text, and Logical functions, Manage and reference defined names, Audit formulas

Managing Data Ranges

Consolidate data ranges, Select and manipulate similar cells and objects, Apply advanced filtering, Protect data in a worksheet

Summarizing and Analyzing Data

Create PivotTables and PivotCharts,Modify PivotTable content, Perform What-if-analysis,

Formatting Worksheet and Chart Content

Create custom number formats, Define advanced conditional formatting rules by using formula, Add visual elements to a chart

Managing Macros and User-Defined Functions

Record and edit a macro, Manage existing macros, Create a user‐defined function (UDF)

Back to top