Queries, VLookup, XLookup, & Co.
Find information and match values in Excel 365 and 2021
78 Seiten
Reihe:
Short & Spicy, Band 11
Zusammenfassung
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.
Leseprobe
Inhaltsverzeichnis
Details
- Seiten
- ISBN (ePUB)
- 9783910233126
- Sprache
- Englisch
- Erscheinungsdatum
- 2023 (Mai)
- Schlagworte
- calculation Excel functions