Queries, VLookup, XLookup, & Co.
Download or Read eBook Queries, VLookup, XLookup, & Co. PDF written by Ina Koys and published by Computertrainerin.de. This book was released on 2023-05-01 with total page 92 pages. Available in PDF, EPUB and Kindle.
| Author | : Ina Koys |
| Publisher | : Computertrainerin.de |
| Total Pages | : 92 |
| Release | : 2023-05-01 |
| ISBN-10 | : 9783910233126 |
| ISBN-13 | : 3910233120 |
| Rating | : 4/5 (26 Downloads) |
Book Synopsis Queries, VLookup, XLookup, & Co. by : Ina Koys
Book excerpt: 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.
