Microsoft Excel - Expert Level (Microsoft Certification)
Expert-level candidates for the Microsoft Excel exam have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the program’s features.
They will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.
This exam measures your ability to accomplish the technical tasks listed below:
1. 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
2. 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
3. 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 PivotCharts
4. Working with Macros and Forms
4.1. Create and manipulate macros
4.2. Insert and manipulate form controls
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.
Though it is not required, most students earn Microsoft Office Specialist (MOS) before moving onto Microsoft Office Specialist (MOS) Expert certification.
Candidates must pass the exam to receive the Microsoft certification.
The course is over 4 Saturdays and an additional part Saturday for the exam.
What is the cost?
The cost will be $400 (special introductory rate) including the training sessions and preparation exam, plus the final certification exam. NOTE: College students will receive a discount - please call 0771 994 5097 for more information about this.
Meet the MSELECT Trainer
Mr. Sarm Abbas is a Microsoft Office Specialist, certified Master Trainer with more than 15 years of experience in IT training. Known for his creative and engaging teaching style, Mr. Sarm has multiple advanced certifications from Microsoft, COMP TIA, Certiport, and ITIL. He is fluent in English, Arabic and Kurdish languages. He has offered IT courses to major oil companies and international organizations throughout Iraq.
How do I register?
You can register confirming on this page or by emailing firstname.lastname@example.org with the following details:
- Full Name:
- Email Address:
- Phone number:
- Name of course:
For more information, please call 066 261 4455 or 0771 994 5097.