Contents
Cal Poly Pomona

Intermediate Excel


Time: 8:30 a.m. to 3:00 p.m.
Class location: Building 98, (CLA) C5-15

Instructor: California Computer Schools, Inc.

Pre-requisite: Completion of beginning Excel course or equivalent knowledge/experience.

Course Description/Curriculum:

  • Enter data into a spreadsheet
  • Name and rename worksheets
  • Create a chart using the Chart Wizard
  • Verify or change the chart source data
  • Add or modify chart titles
  • Select or modify the chart axes
  • Select or modify the chart legend
  • Select or modify chart label options
  • Create an embedded chart
  • Selecting a pie chart
  • Show/hide data table options
  • Select or modify the chart location
  • Format the chart:
    --How to select chart components
    --Add Borders, colors, and fill effects
    --Select font size, color, and orientation
    --Move and resize chart components
  • Modifying chart scale
  • View or hide the Drawing toolbar
  • Use the Drawing tools to draw/format:
    --Text boxes, arrows, AutoShapes
  • Transform (or resizing) a drawing object
  • Understanding object ordering
  • How to group and ungroup objects
  • Inserting a picture or clipart image
  • Using Fixed Decimal to enter data
  • Using Paste Special to copy values
  • Using Paste Special to copy formats
  • Using Paste Special to transpose data
  • Defining names in a spreadsheet
  • Creating names in a spreadsheet
  • Using the Go To feature
  • Using Find and Replace to search for data
  • Protecting a document
  • Add and remove document passwords
  • Change displayed gridline colors
  • Select and change spreadsheet fonts
  • Add borders, shading and patterns
  • Select AutoFormats
  • View or hide toolbars
  • Create a customized toolbar

To register, please log into BroncoDirect

*Note to staff participants: Please be sure to clear your attendance with your managers.

If you have a disability and need an accommodation, please inform us by email at ljroth@csupomona.edu or by calling the ODT office at x3726 one week prior to the workshop.

If you have questions regarding registration for classes, please contact:

Loretta Roth, Organizational Development & Training,
email: at ljroth@csupomona.edu
phone: 909-869-2705.

Reservations will be confirmed by email.