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 IFs and VLOOKUPS

Welcome to Excel VII IFs and VLOOKUPS class!

In this course, we will unlock the power of the IF and IFS functions, as well as delve into the versatility of the VLOOKUP function. These essential tools will enable you to perform advanced calculations, make logical comparisons, and retrieve specific data efficiently. We will explore how the IF function allows you to create conditional statements that automate decision-making processes based on specified criteria. Furthermore, we will discover the expanded capabilities of the IFS function, enabling you to evaluate multiple conditions simultaneously and generate more complex logical outcomes. Additionally, we will delve into the VLOOKUP function, which empowers you to search for and retrieve data from large datasets with ease. We will also cover related functions such as AND and OR, providing you with the ability to combine multiple conditions for enhanced logical evaluations. Finally, we will explore the IFERROR function, helping you handle and manage errors gracefully within your formulas. By the end of this class, you will possess a deep understanding of these functions and their practical applications, equipping you with the skills to perform sophisticated calculations and data retrieval in Excel. Get ready to unleash the full potential of IFs, IFS, and VLOOKUPS, and take your data analysis to new heights of efficiency and accuracy.

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel IFs and VLOOKUPS11/2/2024 (Sat)9AM - 12PM44$125.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 123 East 9th Street
Suite 300
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)