909.981.6331
Excel

Excel

Word

Word

Access

Access

PowerPoint

PowerPoint

Outlook

Outlook

Publisher

Publisher

Quickbooks

Quickbooks

Windows & Computers

Windows & Computers

Internet & Cloud

Internet & Cloud

Specialty

Specialty

Excel VIII IFs and VLOOKUPS

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel VIII IFs and VLOOKUPS10/4/2021 (Mon)9AM - 12PM54$80.00 Register
Excel VIII IFs and VLOOKUPS10/22/2021 (Fri)1PM - 4PM44$80.00 Register

Need a Different Date?

Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.



Topics Include:

IF Function

  • Recording and running
  • Creating a macro button
  • Adding custom menu to a toolbar
  • Assign a macro to a custom menu

AND Function

OR Function

  • Using An If To Help Data Entry Errors
  • Use An If To Clean Up Report Errors

=VLOOKUP

  • When To Use Exact Match
  • 6 Tips For Writing Better Vlookups
  • Making Vlookup Formulas Go Wild
  • Comparing 2 Lists With A Vlookup
  • Range Lookup In Excel [Formulas]
  • Formula To Find Duplicate Values In A Data Range

IFERROR Function

California Computer Schools, Inc.

Location 3290 East Guasti Road
Suite 110
Ontario, CA 91761
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)