MS-Excel 2007 Level 3

MS-Excel 2007 Level 3

COURSE INTRODUCTION:-

The Excel 2007 – Level 3 course teaches students advanced-level concepts and features of the Microsoft Excel 2007 application.

In this course students will build upon the skills learned in the Microsoft Excel 2007 Level 1 and Level 2 courses, and will cover more advanced level concepts and features of Microsoft Excel 2007. They will learn to increase productivity and enhancements of spreadsheets using some of Excel’s more advanced level features. Students will be given ample opportunity to explore and practice these techniques throughout the course.

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 Microsoft Excel skills covered in the lesson.

A practice exercise and review questions are included at the end of each lesson to measure progress and enforce 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, beyond an introductory level, to the Excel XP software program, and its application, within the Windows environment.

PREREQUISITES:-

MS-Excel 2007 Levels 1 & 2

COURSE CONTENT:

Lesson 1: Using Formulas to Project Values; Using the Analysis ToolPak; Using Goal Seek, Solver, and Scenario Manager

Lesson 2: Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports

Lesson 3: Using the Formula Auditing Tools; Correcting Errors in Formulas

Lesson 4: Modifying Workbook Properties; Customizing the Quick Access Toolbar; Customizing the Microsoft Excel Environment; Automating Tasks with Macros

Lesson 5: Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbooks

Lesson 6: Using Microsoft Excel with Other Microsoft Office Programs; Importing Data from External Sources; Using Microsoft Excel Data on the Web

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