Microsoft Excel '97 - Level 2 - Computer Solutions s.c. - Swift Current, Saskatchewan providing training, support, Web design, accounting software setup and support

Microsoft Excel '97 - Level 2
Course Outlines	Course Schedule

Course Description

This course is designed to take a new user through the process of creating and formatting spreadsheets. The student will learn how to enter data, select blocks, move cells, and work with basic formulas. Limited time will be spent on multiple worksheets and charting. This course is ideal for those people who have used spreadsheets made by other people but have never been able to create their own spreadsheets. The student will be able to develop his/her own spreadsheets and also work within and understand better the spreadsheets made by other users.

Course Objectives

Ø To learn and become comfortable creating and formatting workbooks and to become familiar with moving through Excel’s menus and tool bars.

Ø Learn the different techniques available for entering data into Excel, moving, copying and deleting cells and how to format cells as well.

Ø Become familiar with entering basic formulas within the spreadsheet including using the speedy formulas with the AutoSum button. Learn how to copy formulas and how to use the Formula Palette to enter and edit formulas.

Ø Discover how to use and link multiple worksheets.

Ø Learn the basics of this program so that the user can productively use any windows based spreadsheet program.

Duration

The duration of the course is one day. This day begins at 8:30 am and ends at 4:30 pm.

Table of Contents

I	Workbook Templates
	A.	What Are Templates?
	B.	Creating a Template
	C.	Using a Workbook Template
	D.	More on Storing Workbook Templates
	E.	Using Form Field Controls
II	More on Functions
	A.	String Concatenation
	B.	The IF Statement
	C.	The ROUND & ROUNDDOWN Function
III	Conditional Formatting
	A.	The Concept
	B.	Setting Up Conditional Formatting
IV	What If - Scenario Manager
	A.	The Concept
	B.	Using the Scenario Manager
	C.	Other Scenario Manager Tidbits
V	What If - Goal Seeking
	A.	The Concept
	B.	Using Goal Seek
VI	What If - Solver
	A.	Understanding the Solver
	B.	Using the Solver
VII	Security within Excel
	A.	The Security Features within Excel
	B.	Shared Workbooks
	C.	Data Validation
	D.	Workbook Protection
	E.	Cell Protection
	F.	Worksheet Protection
	G.	Hiding Rows/Columns & Worksheets

VIii	Databases
	A.	The Concept
	B.	Using a Data Form for List Creation
	C.	Sorting Data in a List
	D.	Finding Records
	E.	Filtering the Database
	F.	Data Subtotals
IX	Working with Macros
	A.	Macros Defined
	B.	Creating Command Macros
	C.	IRunning a Macro
	D.	Adding Macros as an Application Button
X	Pivot Tables
	A.	What Is a Pivot Table?
	B.	What Is the Source of Data?
	C.	Crating a Pivot Table
	D.	Parts of a Pivot Table
	E.	Basic Changes to Pivot Tables

Relevant Links

MS Excel Level 1

MS Excel Level 3

Software Support