Koys I. Queries, VLookup, XLookup and Co. Finrmation...2023

Textbook in PDF format

Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF, Database functions and the new, cutting-edge ones like SWITCH and the brand new, very convenient XLOOKUP.
Excel worksheets often contain huge datasets. All important information is somewhere within them; finding it is a whole different thing. And once it’s found it may need some processing. Therefore, we’ll be covering known, less known, and brand-new ways of filtering, evaluation with database functions and a number of ways to query, applying custom conditions. To get it done, there’s a set of different possibilities, traditional ones and also the cutting-edge ones, so far confined to the users of Excel 365.
What we’re going to look at
The standard filter
Advanced Filter
The FILTER-Function
Database functions
Insertions using conditions
Calculations using conditions
VLOOKUP
XLOOKUP
More