77-888 – Excel 2010 Expert

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.

What will you Learn

Sharing and maintaining workbooks
Applying formulas and functions
Presenting data visually
Working with macros and forms

Course Content:

Module1: Sharing and Maintaining Workbooks
1.1. Apply workbook settings, Properties, and data options
1.2. Apply protection and sharing properties to workbooks and worksheets
1.3. Maintain shared workbooks

Module2. Applying Formulas and Functions
2.1. Audit Formulas
2.2. Manipulate formula options
2.3. Perform Data Summary Tasks
2.4. Apply functions in formulas

Module3:Presenting Data Visually

3.1. Apply advanced chart features
3.2. Apply data analysis
3.3. Create and manipulate PivotTables
3.4. Create and manipulate Pivot Charts

Module4: Working with Macros and Forms
4.1. Create and manipulate macros
4.2. Insert and manipulate form controls

Free Exam Practice Test:

77-888 Excel 2010 Expert Certification Exam Dumps

International Student Fee : 150 USD

Job Interview Preparation (Soft Skills Questions & Answers)