MS-Excel 2007 Level 1

MS-Excel 2007 Level 1

COURSE INTRODUCTION:-

In this course, students learn to create and manage worksheets and workbook files; enter data and create basic formulas to perform calculations. They learn to edit and manipulate cell content, modify worksheet structure, view and format worksheets, and use Excel’s predefined functions. Students use the Find and Replace feature, use themes to format workbooks and practice preparing, previewing, and printing worksheets.

Students accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the skills covered in the course.

A practice exercise and review questions are included at the end of each lesson to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review to reinforce the topics learned throughout the course, and to help prepare students for the exam.

top

OF INTEREST TO:

Those who are interested in preparing and maintaining financial statements and other kinds of reports in an up-to-date office spreadsheet environment.

COURSE AIMS:

To provide an overview and introduction to the Excel 2002 software program and its application within the Windows environment.

COURSE CONTENT:

Lesson 1: Exploring Microsoft Excel; Creating Workbook Files; Getting Help While You Work

Lesson 2: Viewing Worksheets; Navigating Worksheets and Workbooks; Managing Worksheets and Workbook Files

Lesson 3: Creating Basic Formulas; Editing Text and Values; Clearing, Moving, and Copying Cell Content; Modifying Worksheet Structure

Lesson 4: Understanding Functions; Using Functions; Using Statistical Functions; Using Date and Time Functions;

Lesson 5: Formatting Cells and Cell Content; Formatting Worksheets

Lesson 6: Preparing Worksheets for Printing; Using Find and Replace; Previewing and Printing Worksheets

top

Lab Exercise

COURSE NOTES:

A course manual is provided as an ongoing reference.

A certificate is issued upon the student’s completion of the course and on attaining a pass mark of 75% or higher for the final assessment.

PREREQUISITES:

It is advised that students first take an Introduction to Windows course.

Courses Start every Monday

We are open weekdays, one evening and Saturday mornings.

Flexi-Time Self-Paced, Pick-'n-Mix Training. Our Exclusive System allows you to learn at your own pace within your own flexible, time commitments. There is no need to keep pace with other students

Set your own schedule; You can create a schedule that lets you accommodate your job, your family and other time commitments.

Financial arrangements available or use our Time Payment Plan.

WINZ funding may be available - conditions apply.

top

email us