Contents
Cal Poly Pomona

Excel Formulas

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

Pre-requisite: Completion of beginning and intermediate MS Excel courses or equivalent/knowledge and experience.

Instructor: California Computer Schools, Inc.

This course is coordinated through Organizational Development & Training.

Course Description/Curriculum:

  • Conditional formulas (IF statement)
  • Write a formula with nested IF statements
  • Using IF AND and IF OR statements
  • Using formulas to calculate date/time
  • =NOW =YEAR =MONTH =DAY
  • =TIME =HOUR =MINUTE =TIME
  • How to use =VLOOKUP
  • Formulas for computing a Straight Note
  • Using =PMT to calculate a loan payment
  • Round numbers using =ROUND
  • Display values: =MIN =MAX and =INT
  • Using the =COUNT function
  • Convert text =LOWER =UPPER =PROPER
  • Using Convert Text to Columns Wizard
  • Join text using =CONCATENATE
  • Creating and using Pivot Tables
  • Creating automatic subtotals
  • Using the Goal Seek feature
  • Using the Function Wizard

To register, please e-mail ljroth@csupomona.edu

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

How to Register

To Register go to Bronco Direct and click on "request training enrollment."

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

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

Reservations will be confirmed by email.