EXC-100
 Excel 2003 Introduction

Course Length: 1 day

*Prerequisite*
Introduction to Windows or equivalent working knowledge
General knowledge of other MS Office applications (i.e. Word, Outlook)

What past students had to say about this class:

The instructor has a great energy level and I think this is the first computer training class that I haven't fallen asleep in! ~ B.K. \ City of Carlsbad

The class rocks, the staff rocks and I recommend Systems courses for the beginner to the most experienced! ~ S.R. \ USMC

This was the best computer class I ever attended. The instructor was very clear, had a great approach instructing and paced the learning rate to the students. Continuously touched base with the students to make sure we were comfortable with the material and absorbing the concepts. ~R.S. \ Financial Profiles

It was AWESOME!! Organized, fun, personal. A++!! ~S.L. \ Solatube 

Very informative, very satisfied with information needed to perform my required task. ~M.W.

Highly recommended! ~ S.P. \Barratt American

 

Course Contents

Introduction

Getting Started

  •  What is Excel? 

  •  Starting Excel

  •  The Excel application window

  •  Using the Excel menu system

  •  Using the Excel toolbars

  •  Using Excel task panes

  •  Displaying help information

  •  Exiting from Excel

Modifying an existing worksheet

  •  Resetting the working folder

  •  Moving the cell pointer

  •  Changing data in a worksheet

  •  Reversing an edit operation

  •  Saving a workbook

  •  Adding data to a worksheet

  •  Entering a Formula into a Worksheet

  •  Adjusting column width in a worksheet

  • Adjusting row height in a worksheet

  •  Printing a worksheet

Building a new worksheet

  •  Opening a new workbook

  •  Using the spelling checker

editing a worksheet

  • working in edit mode

  • selecting ranges in a worksheet

  • using autoFill

  • copying cells

  • moving cells

  • clearing cells

  • using autoSum

  • inserting and deleting rows and columns

  • inserting and deleting a range of cells

Using Excel functions

  •  What is a function? 

  •  Using the SUM function

  •  Using the AVERAGE

  •  Using the MAX and MIN functions

  •  Using the COUNT function

  •  Using the INSERT function button

Enhancing worksheet appearance

  •  Working in edit mode

  •  Adjusting row height in a worksheet

  •  Realigning cell entries

  •  Resetting the font of cell entries 

  •  Adding borders and shading to a worksheet

  •  Using auto format

Enhancing printed output

  •  Changing the page setup of a worksheet

  •  Previewing a worksheet

  •  Inserting a Manual Page Break into a Worksheet

  •  Printing selected worksheet entries

Creating a chart

  •  What is a chart ? 

  •  Plotting a basic chart

  •  Modifying and enhancing a basic chart

  •  Previewing and printing a chart

  •  Including non-contiguous data ranges in a chart

Final case study


Home
Solaris Programming Microsoft Desktop Linux Cisco Security
About SYSTEMS Computer Training
Contact Us


© 2003-2004 SYSTEMS Computer Training, A Testmasters Company

Solaris and Java are registered trademarks of Sun Microsystems.