Contents
Cal Poly Pomona

Excel Formulas

Date: Tuesday, December 12, 9:00 a.m. - 4:30 p.m.
Class location: Building 98, (CLA) C5-15

registration form

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 request registration for one of the above listed dates/times, please complete the Registration Form and fax to extension 3779.

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.