Queries, Vlookup, Xlookup & Co.: Find Information And Match Values In Excel 365 (Short & Spicy)

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.

• | Author: Ina Koys
• | Publisher: Ina Koys
• | Publication Date: Apr 15, 2022
• | Number of Pages: 82 pages
• | Language: English
• | Binding: Paperback
• | ISBN-10: 3947536828
• | ISBN-13: 9783947536825