Microsoft Excel 2010: Expert 2010

Product Description

Overview

This certification class provides a complete instruction solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Excel 2010 Expert Accreditation. This is an Expert accreditation in addition to the lower level MOS Microsoft Excel 2010 Specialist accreditation which is NOT a prerequisite of the Expert exam. It is aimed at delegates usually as part of the MOS Master Certification track or those simply seeking to attain a higher level accreditation in Microsoft Excel 2010.
It concentrates on getting delegates from knowledgeable to ?exam ready? in a 2 day class. The class is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills & practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.
Please note this is the Expert level: one of two levels of exam available for Microsoft Excel 2010 (Specialist & Expert). MOS exams are also available for Word, Power Point, Outlook & Access 2010.
Included Are
?2-days Instructor Led Instruction using MOS Official Classware
?MOS Practice Exam Voucher
?MOS Exam Voucher
? Free Exam Re-take (where required)
Class Outline
During the 2 day class you will cover the following topics to prepare you for exam 77-888: Microsoft Office Excel 2010 Expert. During the class, you will have the opportunity to test your knowledge & complete a full practice exam before taking the final exam at the end of day two.
Sharing & Maintaining Workbooks
Apply workbook settings, properties, & data options
setting advanced properties, saving a workbook as a template, & importing & exporting XML data
Apply protection & sharing properties to workbooks & worksheets
? Protecting the current sheet, protecting the workbook structure, restricting permissions, & requiring a password to open a workbook
Maintain shared workbooks
? Merging workbooks & setting Track Changes options
Applying Formulas & Functions
Audit formulas
? Tracing formula precedents, dependents, & errors, locating invalid data or formulas, & correcting errors in formulas
Manipulate formula options
setting iterative calculation options & enabling or disabling automatic workbook calculation
Perform data summary tasks
? Using an array formula & using a SUMIFS function
Apply functions in formulas
? Finding & correcting errors in functions, applying arrays to functions, & using Statistical, Date & Time, Financial, Text, & Cube functions
Presenting Data Visually
Apply advanced chart features
? Using Trend lines, Dual axes, chart templates, & Sparklines
Apply data analysis
? Using automated analysis tools & performing What-If analysis
Apply & manipulate Pivot Tables
? Manipulating Pivot Table data & using the slicer to filter & segment your Pivot Table data in multiple layers
Apply & manipulate Pivot Charts
? Creating, manipulating, & analysing Pivot Chart data
Demonstrate how to use the slicer
? Choosing data sets from external data connections
Working with Macros & Forms
Create & manipulate macros
? Running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access Toolbar, & applying modifications to a macro
Insert & manipulate form controls
? Inserting form controls & setting form properties