Do you spend too much time looking for information in large amounts of data in your Excel spreadsheets? Want to free up some of that time? When you want to pull information from an Excel worksheet, Excel lookup functions are handy solutions. Their ability to dynamically lookup and retrieve information can be a game-changer for many users!
Participants in this one-day class will learn how to perform powerful information gathering in an Excel range or table, utilizing lookup and reference functions as well as other related time-saving formulas and techniques. Participants should have a good understanding of and experience with Excel prior to this class.
Performance Objectives: Upon completion of this course, participants should be able to:
Competencies covered in this course: VLOOK Up functions in Excel and working with large amounts of data.
Intended Audience: Anyone who works with large amounts of data in Excel
Prerequisites: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you have a good understanding of Excel.