The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life.
Home and Office users taking this course should already be familiar with Microsoft Office Excel 2003, Microsoft Office Excel 2007, or other spreadsheet programs. Learners familiar with Excel 2003 should complete Course ‘Introduction to the New Microsoft Office Fluent User Interface’.
At the course completion
This course provides you with skills to create, customize, enhance, and share Excel 2010 workbooks.
Topics covered in this course include:
- Working with the Interface Elements
- Creating and Editing Worksheets
- Formatting Cell Data
- Working with Equations and Formulas
- Creating and Formatting Charts
- Creating and Formatting Tables
- Working with PivotTables
- Working with Pivot Charts
- Creating, Editing, and Running Macros
- Working with External Data
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.
Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.
- Managing the worksheet environment
- Creating cell data
- Formatting cells and worksheets
- Managing worksheets and workbooks
- Applying formulas and functions
- Presenting data visually
- Sharing worksheet data with other users
- Analyzing and organizing data