ICDL Module 4: ES WSQ - Perform Spreadsheet Functions (Microsoft Excel 2007) Fast Track Central Area, Central

Course details

This course provides the basis for the practice-based test for ICDL Module 4 Perform Spreadsheet Functions exam.

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

COURSE OUTLINE

• Module 1. Exploring Excel
• Module 2. Getting help
• Module 3. Using Basic Workbook Skills
• Module 4. Working with Ranges
• Module 5. Working with Columns and Rows
• Module 6. Formatting Numbers
• Module 7. Formatting Text
• Module 8. Formatting Cells
• Module 9. Creating Simple Formulas
• Module 10. Copying and Moving Data
• Module 11. Creating Charts
• Module 12. Formatting Charts
• Module 13. Managing Data
• Module 14. Using Page Setup
• Module 15. Printing