Skip to main content
Western Kentucky University

CWD: Courses: Computer Training

Print this page

Introduction to Excel 2007

Session Format:

4 Hours Total (One 4-Hour Session)

Introduction

This course provides the student the foundation needed to utilize a spreadsheet for business applications. Design concepts, databases, charts and macros will be examined thoroughly along with the major built-in functions. Students will design several spreadsheets both in and out of class to solve specific business problems.

Objectives

The participant will learn: (1) entry and use of the three data types, (2) use of menus and commands, (3) cell addressing and manipulation, (4) saving and printing spreadsheets, and (5) creating and printing graphs.

Content Outline

  • Steps for spreadsheet design
  • Entering values and text
  • Constructing formulas
  • Working with functions, blocks
  • Relative and absolute copying
  • Formatting text and values
  • Saving and retrieving files
  • Preparing to print your spreadsheet and graph

Who Should Attend

This seminar is intended for individuals who are just beginning to use electronic spreadsheets.

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 
 Last Modified 9/24/14