Microsoft Excel 2002 Core: Formulas, Formatting, Charts, and Graphics

Overview/Description
Microsoft Excel 2002 is a powerful spreadsheet program. The Help system and the many intuitive features make Excel easy to learn and use. This course, Formulas, Formatting, Charts, and Graphics, presents techniques for formatting, manipulating, processing, and adding graphics to worksheets.

Target Audience
This course is designed for Microsoft Excel 2002 beginners or those new to Microsoft Excel 2002. Prior experience with opening and editing worksheets is recommended.

Expected Duration
This course, including the practice exercises, will take up to four hours to complete.

Objectives:

Using Formulas and Functions

  • Identify formula elements
  • Recognize operators and operator precedence
  • Enter formulas
  • Edit formulas
  • Use built-in functions in formulas
  • Recognize function arguments and insert function options
  • Enter a formula containing a recently used function
  • Enter a formula from built-in functions
  • Enter a commonly used function using AutoSum
  • Edit functions in formulas
  • Recognize relative and absolute references in formulas
  • Resolve common errors in formulas
  • Use the functions SUM, MIN, MAX, and AVERAGE in formulas
  • Use the functions DATE, NOW, and PMT in formulas
  • Use the IF function in formulas

    • Formatting Worksheets

  • Insert cells, rows, and columns
  • Delete cells, rows, and columns
  • Hide rows and columns
  • Modify column width
  • Modify row height
  • Transpose rows and columns
  • Create scrollable and frozen worksheet panes
  • Create and apply worksheet styles
  • Modify, delete, and merge worksheet styles
  • Format worksheets using AutoFormat

    • Using Charts and Graphics in Worksheets

  • Identify types of charts and their components
  • Create charts using the Chart Wizard
  • Select chart objects
  • Adjust the displayed size of charts
  • Position charts
  • Delete, move, and copy charts
  • Change the type of a chart
  • Change the data range, series, and axes for a chart
  • Set options for chart objects
  • Format the chart area
  • Format the plot area
  • Format the legend
  • Position and format the chart title
  • Format an axis and gridlines
  • Format a data table and data labels
  • Select and format a data series and data points
  • Identify the types of Excel graphics
  • Create and edit text boxes
  • Find and insert clip art
  • Insert and edit a WordArt graphic
  • Insert and edit a diagram


    • Course Number: MOFF0212