Sayers & Associates - Excel 97 Advanced Level 3

		Course Description
		EXCEL 97 - LEVEL 3 ADVANCED

		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.