© Middlesex ITeC Ltd 2020 Registered in England No. 1707396 Charity No. 1015309
The Core-level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% 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. Some of the roles users might take on include, but are not limited to:
• Accountants
• Clerical, Office professionals
• Consultants
• Executives/Managers
• Help desk personnel
• Instructors/Trainers
• Program/Project Managers
• Sales
• Students
Navigate through a worksheet
Print a worksheet or workbook
Personalise environment using Backstage
Creating Cell Data
Construct cell data
Apply AutoFill
Apply and manipulate hyperlinks
Apply and modify cell formats
Merge or split cells
Create row and column titles
Hide and unhide rows and columns
wdded
Manipulate Page Setup options for worksheets
Create and apply cell styles
Create and format worksheets
Manipulate window and workbook views
Create formulas
Enforce precedence
Apply cell references in formulas
Apply conditional logic in a formula
Apply named ranges in formulas
Apply cell ranges in formulas
Create charts based on worksheet data
Apply and manipulate illustrations
Create and modify images by using the Image Editor
Apply Sparklines
Share worksheets by using Backstage
Manage Comments
Filter data
Sort data
Apply conditional formatting