MOS Excel 2010 Expert Central Area, Central

Course details

Microsoft® Excel® 2010 Expert teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Expert Exam #77-88

Course Prerequisites

This course assumes that students have completed the Microsoft Excel 2010 Specialist course or have equivalent Excel knowledge and experience.

• Manage the worksheet environment
• Create cell data
• Format cells and worksheets
• Manage worksheets and workbooks
• Apply formulas and functions
• Present data visually
• Share worksheet data with other users
• Analyze and organize data

About This Courseware

• Lesson 1: Presenting Data Visually
• Lesson 2 - Sharing and Protecting Workbooks
• Lesson 3 - Applying Formulas and Functions
• Lesson 4 - Data Analysis
• Lesson 5 - Macros, Forms, and Data Consolidation

Appendices

• Appendix A: Courseware Mapping
• Appendix B: Glossary of Terms
• Appendix C: Index