MOS Excel 2007 Core

Course details

The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The trainee will be able to accomplish standard mathematical and logical operations using basic formulas and functions. The trainee will be able to demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.

This course prepares the participants for the Microsoft Office Specialist exams.

COURSE OUTLINE

• Module 1. Using Basic Workbook Skills
• Module 2. Using Formulas and Functions
• Module 3. Using Range Names
• Module 4. Using Advanced Functions
• Module 5. Using Conditional and Custom
• Module 6. Using Page Setup
• Module 7. Using Large Worksheets
• Module 8. Managing Files
• Module 9. Using Worksheet Protection
• Module 10. Creating Charts
• Module 11. Formatting Charts
• Module 12. Using Shapes and SmartArt
• Module 13. Working with Comments
• Module 14. Using Paste Special
• Module 15. Working with Tables
• Module 16. Using AutoFilter
• Module 17. Sharing Workbook