Computer Training



Course Description


Course Length 1 Day - 8 Hour Class Session

Overview Students will learn the skills and concepts necessary to work with the advanced capabilities of Excel

Prerequisite Introduction to Personal Computers 
Window 2000 Introduction or Windows XP Introduction
Excel 97 – Level One – Worksheets 
Excel 97 – Level Two – Charting and Organizing Data

Delivery Method Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities

Benefits Students will learn how to customize the Excel work area and how to create advanced formulas, pivot tables, file linking formulas and outlines Students will also use Goal Seek, Solver and Scenario Manager to analyze data.

Target Student Students enrolling in this course should have the basic understanding of Windows and Excel 97 - Level One – Worksheets and Excel 97 – Level Two – Charting and Organizing Data.    They should be familiar with data types, (text and values), copying data, basic formulas and functions and opening and saving files.  

Objectives Customize the work area by creating a custom toolbar, custom styles, and a template file. 

Create a nested function; build advanced formulas using the IF an VLOOKUP functions and use the Auditing feature. 

Create and work with pivot tables. 

Compare and contrast workbook files and file links. 

Outline and consolidate worksheets. 

Use the Goal Seek, Solver and Scenario Manager to analyze worksheet data. 

Display and protect worksheet data. 

Please Contact Us For Class Outlines.



e-mail.gif (7997 bytes)To Contact Us:
Office:    (479) 452-4439
                   (888) 933-3579
    Fax:    (479) 452-4418
       Post Office Box 10783  

             Fort Smith, Arkansas 72917