January 4, 2024

Our series of Mastering Excel courses provides participants with a comprehensive understanding of formulas and techniques to efficiently manage data and visualize it in charts and dashboards. This month, we’re focusing on XLOOKUP and VLOOKUP, the two most powerful lookup functions in Excel. You’ll learn how to:

  • Understand the difference between XLOOKUP and VLOOKUP formulas
  • Use XLOOKUP and VLOOKUP to return values in a range based off of a lookup value
  • Understand when and how to use lookup formulas with exact and approximate matches
  • Return a specified value if the lookup value is not found in the lookup range
  • Use the array capabilities of XLOOKUP

Course resources will get you working with real-life CU scenarios so you can move from theory to practice right within the two-hour session.

Get more information, and sign up, on the OUC website at www.cu.edu/controller/schedule-and-registration.

And, as always:

  • The Office of University Controller provides no-cost CPE for the University's Certified Public Accountants (CPAs) and no-cost professional development for employees in general.
  • Use your CU-affiliated email address to avoid incurring a registration fee.
  • If you have questions, drop us a line at CU.CPE@cu.edu.