Cal Poly Pomona

Excel IF and VLOOKUP

Instructor: California Computer Schools, Inc.

This course is coordinated through Organizational Development & Training.

Course Description

Want to really capture the power of Excel? Then you absolutely need to know how to write these 2 formulas!
The IF function is probably the most powerful, multipurpose function offered by Excel. It is also one of the most confusing to learn. This class will help you to write effective IF formulas. Covered topics include basic “IF”, “IF” function with equations, “If” function to display text, and “IF” function to display text with a cell reference.

VLOOKUPs are second only to the IF in usefulness. Type in a value in Excel and utilize the VLOOKUP to pull corresponding data from a separate data set. Covered topics include modifying data for use with a VLOOUP, basic VLOOKUPs, suing a Named Range as a source data, and creating a dynamic Named Range that grows as your data grows.

The class will include individual practice time to test your new skills. Bring a flash drive and you can take the samples plus additional practice with you after class.

To register, please e-mail

*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, or by
telephone: 909-869-2705.

Reservations will be confirmed by email.