Excel 2000
Part 1
Course Code: AD315 

A practical "hands on" introduction to the basic features and functions of Excel. Learn how to create a worksheet to meet your financial needs.

Objectives
Course participants will learn how to:

  • Use the Excel menu & toolbars
  • Open, close & print Excel files
  • Enter values & formulas
  • Adjust column width and height
  • Move and copy cell entries
  • Compute a row or column total
  • Insert columns and rows
  • Realign cell entries
  • Change the font and numeric format
  • Add a border and shading
  • Apply a predefined format
  • Change page setup & preview a worksheet

What you will learn
Topics covered by this course include:

Getting Started

  • Accessing & Opening Excel
  • The Excel Application Window
  • Using Excel Menus & Toolbars
  • Displaying Help Information

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
  • Printing a Worksheet
Building a New Worksheet
  • Opening a New Workbook

Using Worksheet Shortcuts

  • Using the AutoFill Feature
  • Copying, Moving & Clearing Cell Entries
  • Using AutoSum
  • Inserting Rows & Columns

Enhancing a Worksheet’s Appearance

  • Using Edit Mode
  • Adjusting Column Width & Row Height
  • Realigning Cell Entries
  • Changing the Font
  • Changing the Numeric Format
  • Adding Border & Shading to a Worksheet
  • Using the AutoFormat Feature

Enhancing Printed Output

  • Changing the Page Setup
  • Previewing a Worksheet & Printing Selected Area

Using Excel Functions

  • Using the Sum, Average, Max, Min and Count Functions

Prerequisites
Basic computer skills are recommended for this course.

Dates and times
Courses are available either in the morning or the evening. Contact the relevant training centre for further details and enrolment information.

© Copyright The Fourth R®

 [Back to MS Office Training Courses]