Microsoft Excel 2007: Exploring the Basics


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number


Overview/Description
This course will introduce you to Microsoft Excel 2007. In the first unit, you will be introduced to the Excel 2007 interface. You will learn to identify the spreadsheet components of Excel, access help when required, work and manage workbooks, use templates and protect data. The Formulas, Functions, and Charts unit will show you how to enter and work with formulas. You will also learn to use references, and create and modify charts.. The Formatting Worksheets unit of this course will cover methods to format worksheets. It will take you through the procedures to format text, rows, and columns. You will also learn to apply different styles, special formats, and format date and time styles. The final unit is titled Managing and Printing Workbooks. Here you will learn to work with multiple worksheets and link and manage workbooks. You will also learn to prepare and print a worksheet, and print multiple worksheets. .

Target Audience
The audience for this course consists of small office/home office (SOHO) users to all levels of business users. These users possess basic to intermediate PC skills and want to use Excel 2007 as a productivity tool. They have a couple of years of experience using a PC and have limited or no experience with Excel.

Expected Duration (hours)
4.0

Lesson Objectives

Microsoft Excel 2007: Exploring the Basics

  • Enter formulas and work with formulas and functions.
  • Use references.
  • Create and work with charts.
  • Add graphic elements to a chart.
  • Format worksheets to suit needs.
  • Format numbers using special formats.
  • Format date and time.
  • Work with multiple worksheets.
  • Link and manage workbooks.
  • Set up print options for single and multiple worksheets.
  • Course Number:
    KN00076030_ng