Lookups and Database Functions
There is nothing more time-consuming that searching an enormous spreadsheet for one line of information. This course on Lookup and Database functions will help you quickly find records in large Excel datasets. You will learn how to use these functions, create drop-down lists, build search panels and much more.
Intermediate 12 Lessons 150 Minutes CPD Credits
About This Course
It can be frustrating to know you have a wealth of information stored in your spreadsheet, but not know how to access it. Excel helps with functions to speed up your search.
Throughout this course, you’ll learn how to find unique records, split data into different tiers, and create go-to functions for ease of access.
After completing the 12 lessons, you’ll be comfortable in updating your search panel formulas to automatically include any new records added to your dataset.
Find specific values using VLOOKUP, INDEX, and MATCH
Create names for arrays of data
Create nested IF functions
Build a search panel using lookup functions
Use Excel’s database functions
Update your formulas automatically when new data is added