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

Microsoft Excel 2002 - Level 2
Course Outlines	Course Schedule

Course Description

This course will take Excel users through some of the advanced spreadsheet functions that Excel has to offer. The database functions will be featured as well as advanced charting and setting up and using macros. There are a number of powerful features like the Scenario Manager and Goal Seek that will be taught and will give the student added proficiency with the program.

Course Objectives

Ø To help Excel users learn the other powerful features that Excel has to offer.

Ø Spreadsheets are great for doing what-if analysis. See how to use the Scenario Manager and the Goal Seek function to do the what-if analysis.

Ø This course will cover areas of Excel that people may not commonly use but it may be the functions that help to develop powerful spreadsheets and achieve your goals.

Ø We look at Databases and how they can be used in Excel.

Duration

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

Table of Contents

I	INTRODUCTION
	A.	Using the Pmt Function
	B.	Create Linear and Growth Trends with the Series Command
II	Show Formulas
III	Using Comments
	A.	The Concept
	B.	Adding Comments
	C.	Viewing Comments
	D.	Printing Comments
	E.	Editing Comments
	F.	Deleting Coments
IV	More On Functions
	A.	String Concatenation
	B.	The =IF Statement
	C.	The ROUND Function
V	Conditional Formatting
	A.	The Concept
	B.	Setting Up Conditional Formatting
VI	Using Named Ranges
	A.	The Concept
	B.	Guidelines for Naming Cells, Formulas, and Constants in Microsoft Excel
	C.	Naming Cells Based on Existing Labels
VII	The Scenario Manager
	A.	The Concept
	B.	Using the Scenario Manger
VIII	Goal Seeking
	A.	The Concept
	B.	Using Goal Seek
IX	What If - Solver
	A.	Understanding Solver
	B.	Using the Solver

X	Advanced Worksheet Management
	A.	Using Paste Special
	B.	Hiding/Unhiding Rows and Columns
XI	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.	Advanced Filtering
	G.	Data Subtotals
XII	Charts
	A.	Using the Chart Wizard
	B.	Editing a Chart
	C.	Adding Data to an Existing Chart
XIII	Graphics For Worksheets
	A.	Activating the Drawing Toolbar
	B.	Using the Drawing Toolbar
	C.	Moving & Sizing Objects

Relevant Links

MS Excel Level 1

MS Excel Level 3

Software Support