Microsoft Office Excel (COCR1021)

Aim

The aim of this module is to equip you with all the basic tools necessary for producing a comprehensive spreadsheet in order to effect change in the

workplace.

Objectives

At the end of the training you will be able to:

• Format spreadsheets for easy readability and using appropriate objects to enhance appearance
• Retrieve, analyse and generate information for reporting purposes
• Use statistical, financial and logical functions within formulas
• Print, edit and organise worksheets and workbooks
• Create and Manipulate Date
• Create and Modify formulas
• Collaborate and Secure Data

Prerequisite

Computer Literacy which includes: keystroking ability, knowledge of Windows and knowledge of mouse techniques.

Exam Skill Standards

Below are the tasks you’ll be expected to be able to perform in order to pass the Using Microsoft Office Excel 2007 Application Specialist exam. You can use this as a study checklist.

1. Creating and Manipulating Data
   • Insert data by using AutoFill
   • Ensure data integrity
   • Modify cell contents and formats
   • Change Worksheet Views
   • Manage worksheets
2. Formatting Data and Content
   • Format worksheets
   • Insert and modify rows and columns
   • Format cells and cell content
   • Format data as a table
3. Creating and Modifying Formulas
   • Reference data in formulas
   • Summarize data using a formula.
   • Summarize data using subtotals.
   • Conditionally summarize data by using a formula
   • Look up data by using a formula.
   • Use conditional logic in a formula.
   • Format or modify text by using formulas.
   • Display and print formulas.
4. Presenting Data Visually
   • Create and format charts
   • Modify charts
   • Apply conditional formatting
   • Insert and modify illustrations
   • Outline data
   • Sort and filter data
5. Collaborating and Securing Data
   • Manage changes to workbooks
   • Protect and share workbooks
   • Prepare workbooks for distribution
   • Save workbooks
   • Set print options for printing data, worksheets, and workbooks
   • Filter data by using AutoFilter
   • Filter and sort data by using conditional formatting
   • Filter and sort data by using cell attributes

Assessment – Excel (COCR1021)

Each of the five exam skills above is equally weighted

Maximum score is 1000

Passing score is 660

Required Text

Title: Microsoft Office Excel 2007. Step by Step

Author: Curtis Frye

Publisher: Microsoft Press

ISBN-13: 978-0-7356-2304-0