Login

**Farid** · 08-30-2023, 01:02 PM

Queries, VLookup, XLookup & Co | 84 | Ina Koys | 2021 | Computertrainerin.de |

Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are The filter and the VLOOKUPwhich 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 SWITCHand the brand new, very convenient XLOOKUP().

All are explained with examples and their specific benefits and downsides.
Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUPwhich 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 SWITCHand the brand new, very convenient XLOOKUP().

All are explained with examples and their specific benefits and downsides.

Contents of Download:
Queries, VLookup, XLookup & Co. Find information and match values in Excel 365 and 2021 Short & Spicy.epub (8.18 MB)

KatFile Link(s)