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 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
phone: 909-869-2705.

Reservations will be confirmed by email.