MOS Excel 2007 Core

Course details

Microsoft® Office Excel 2007 teaches the new information worker how to work with worksheets and workbooks to analyze data using a variety of features to create, modify and format common business reports such as budgets, inventory reports, invoices, and charts. This course is designed for those people who require the skills necessary to use a spreadsheet program on a daily basis to manage and audit numerical reports.Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for a Microsoft Office Specialist Exam #77-602.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent Microsoft Windows knowledge and experience. Students who wish to become proficient using the features of Microsoft Office Excel 2007 will benefit from taking this course.

Course Outline

About This Courseware

• Lesson 1: Introducing Excel
• Lesson 2: Manipulating Items
• Lesson 3: Using Formulas
• Lesson 4: Formatting the Worksheet
• Lesson 5: Preparing to Print
• Lesson 6: Working with Charts
• Lesson 7: Using Functions
• Lesson 8: Working with Illustrations
• Lesson 9: Customized Charts
• Lesson 10: Customized Formatting
• Lesson 11: Working with Tables
• Lesson 12: Working with Databases
• Lesson 13: Using Data Tools
• Lesson 14: Preparing Online
• Lesson 15: Collaborating with Others
• Lesson 16: Using Analysis Tools

Appendices

• Appendix A: A Quick Review of the Basics
• Appendix B: Apply Your Skills Exercises
• Appendix C: Answers to Review Questions
• Appendix D: Microsoft Office Excel 2007 Exam Objectives
• Appendix E: Glossary of Terms
• Appendix F: Index