ICDL Module 4: ES WSQ - Perform Spreadsheet Functions (Microsoft Excel 2013) Fast Track

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 Microsoft Excel 2013
• Module 2. Getting Help
• Module 3. Basic Workbook Skills
• Module 4. Selection
• Module 5. Working with Columns and Rows
• Module 6. Number Formatting
• Module 7. Text Formatting
• Module 8. Cell Formatting
• Module 9. Filtering Data with AutoFilter
• Module 10. Working with Tables
• Module 11. Basic Formulas
• Module 12. Cut, Copy and Paste
• Module 13. Data Management
• Module 14. Creating Charts
• Module 15. Using Page Setup
• Module 16. Printing