img Leseprobe Sample

Queries, VLookup, XLookup, & Co.

Find information and match values in Excel 365 and 2021

Ina Koys

EPUB
4,49
Amazon iTunes Thalia.de Weltbild.de Hugendubel Bücher.de ebook.de kobo Osiander Google Books Barnes&Noble bol.com Legimi yourbook.shop Kulturkaufhaus ebooks-center.de
* Affiliate Links
Hint: Affiliate Links
Links on findyourbook.com are so-called affiliate links. If you click on such an affiliate link and buy via this link, findyourbook.com receives a commission from the respective online shop or provider. For you, the price doesn't change.

Computertrainerin.de img Link Publisher

Naturwissenschaften, Medizin, Informatik, Technik / Informatik, EDV

Description

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.

customer reviews

Keywords

calculation, functions, Excel