Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Queries, VLookup, XLookup & Co. : Find information and match values in Excel 365 and 2021, EPUB eBook

Queries, VLookup, XLookup & Co. : Find information and match values in Excel 365 and 2021 EPUB

Part of the Short & Spicy series

EPUB

Download - Immediately Available
Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

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.

Information

Save 15%

£4.99

£4.24

Download - Immediately Available
Add to Basket
Sign in to add to wishlist
 
Delivered to your inbox

to transfer to your device

eBook Help

Is this the right eBook for
my device? How do I download
this eBook? See help and FAQs pages

Information

Also in the Short & Spicy series  |  View all

New ways to go!

£9.99

Add to Basket

Pivot for office workers

£3.99

£3.39

Add to Basket

How to create Explainer Videos

£3.99

£3.39

Add to Basket

Roll away the boring stuff!

£3.99

£3.39

Add to Basket