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

Microsoft Excel 2000 - 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.

Ø There is a special section on macros. Find out how macros easy it is to set up macros and they can help performance within Excel spreadsheets.

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	INTRODUCTION
	A.	Using the Pmt Function
	B.	Create Linear and Growth Trends with the Series Command
II	Showing Formula’s And Comments
	A.	Showing Formulas
	B.	Using Comments
III	String Concatenation
IV	Using Named Ranges
	A.	The Concept
	B.	Guidelines for Naming Cells, Formulas, and Constants in Microsoft Excel
	C.	Naming Cells Based on Existing Labels
V	The Scenario Manager
	A.	The Concept
	B.	Using the Scenario Manger
VI	Goal Seeking
	A.	The Concept
	B.	Using Goal Seek
VII	Advanced Worksheet Management
	A.	Using Paste Special
	B.	Hiding/Unhiding Rows and Columns

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	The If & The Round Functions
	A.	The =If Statement
	B.	The Round & Rounddown Function
X	Charts
	A.	Using the Chart Wizard
	B.	Editing a Chart
	C.	Adding Data to an Existing Chart
XI	Graphics For Worksheets
	A.	Activating the Drawing Toolbar
	B.	Using the Drawing Toolbar
	C.	Moving & Sizing Objects
XII	Working With Macro’s
	A.	Macros Defined
	B.	Creating Command Macros
	C.	Running a Macro
	D.	Adding Macros as an Application Button
XIII	Conditional Formatting
	A.	The Concept
	B.	Setting Up Conditional Formatting

Relevant Links

MS Excel Level 1

MS Excel Level 3

Software Support