Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365
- Length: 82 pages
- Edition: 1
- Language: English
- Publisher: Ina Koys
- Publication Date: 2021-09-30
- ISBN-10: 3947536828
- ISBN-13: 9783947536825
- Sales Rank: #6316808 (See Top 100 Books)
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 in full colour print.
Free ChaptersTry Audible and Get Two Free Audiobooks »
To access the link, solve the captcha.
Recommended BooksMore Similar Books »
Microsoft 365 Copilot At Work: Using AI to Get the Most from Your Business Data and Favorite Apps
2025-01-15
Subscribe
Categories