CLOSURE: Central Library will be closed Tuesday, July 21, through Saturday, July 25, while emergency repairs are made to the building’s cooling system. We expect to reopen Monday, July 27. Click for more details on holds, program schedules, and returns during the closure. 

Notice of Public Meeting: Kalamazoo Public Library Board of Trustees | July 27 | 5:30 pm | Central Library/Van Deusen Room. The packet of information for the meeting can be found on the library’s website. 

eLearning linkedin.com

Mastering Lookup Functions in Excel: Seven Powerful Formulas

Summary

Learn how to leverage Excel data more effectively and efficiently in this crash course on lookup functions including XLOOKUP and VLOOKUP.

Dive into the world of Excel lookup functions in this engaging crash course designed to enhance your data handling and data management skills. Join instructor Josh Aharonoff—also known as Your CFO Guy, who has hundreds of thousands of professional online followers on social media—as he offers an in-depth exploration of Excel's most widely used and important lookup functions. Gain insights into a broad range of topics, such as detailed function syntax and the pros and cons of each function, along with practical exercises that will empower you to leverage your data more effectively. By the end of this course, you’ll be prepared to start using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, the powerful INDEX/MATCH combination, and GETPIVOTDATA. Whether you're just getting started or looking to refine your skills, this course is tailored to help you navigate your datasets with ease and greater confidence.

Subjects

Added Authors

linkedin.com (Firm)