Microsoft Excel 2010 Expert
Book Now - 1 Delivery Method Available:Scheduled Virtual Onsite
This certification course provides a complete training 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 course. The course is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills and 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 and Expert). MOS exams are also available for Word, PowerPoint, Outlook and Access 2010.
- 2-days Instructor Led Training using MOS Official Courseware
- MOS Practice Exam Voucher
- MOS Exam Voucher
- Free Exam Re-take (where required)
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Sharing and Maintaining Workbooks (3 topics)
- Apply workbook settings, properties, and data options
- Apply protection and sharing properties to workbooks and worksheets
- Maintain shared workbooks
Applying Formulas and Functions (4 topics)
- Audit formulas
- Manipulate formula options
- Perform data summary tasks
- Apply functions in formulas
Presenting Data Visually (5 topics)
- Apply advanced chart features
- Apply data analysis
- Apply and manipulate PivotTables
- Apply and manipulate PivotCharts
- Demonstrate how to use the slicer
Working with Macros and Forms (2 topics)
- Create and manipulate macros
- Insert and manipulate form controls
This course has strict prerequisites â€“ delegates should have already attended the relevant Levels 1, 2 and 3 courses or have equivalent knowledge. This course is NOT a fast track course for learning the exam material but a course for turning knowledge in to exam readiness.
The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .
Excel 2010 Level 1
Gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets on this 1-day training course.
Excel 2010 Level 2
Take the Excel 2010 Level 2 training course to learn how to streamline repetitive tasks and display spreadsheet data in more visually effective ways.
Excel 2010 Level 3
Extend your knowledge into some of the more specialized and advanced capabilities of Excel with the 1-day training course Excel 2010 Level 3.