Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 in Bloomington, MN

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()
.
All are explained with examples and their specific benefits and downsides in
full colour print