Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021
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.
Ina Koys is an experienced instructor for Microsoft Office. Many questions are frequently asked in trainings, but seldom covered in books. Now she answers some of them in her originally German "short & spicy" series. A little accent will add to the fun :-)
1143443849
Ina Koys is an experienced instructor for Microsoft Office. Many questions are frequently asked in trainings, but seldom covered in books. Now she answers some of them in her originally German "short & spicy" series. A little accent will add to the fun :-)
Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021
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.
Ina Koys is an experienced instructor for Microsoft Office. Many questions are frequently asked in trainings, but seldom covered in books. Now she answers some of them in her originally German "short & spicy" series. A little accent will add to the fun :-)
Ina Koys is an experienced instructor for Microsoft Office. Many questions are frequently asked in trainings, but seldom covered in books. Now she answers some of them in her originally German "short & spicy" series. A little accent will add to the fun :-)
3.99
In Stock
5
1
Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021
78
Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021
78
3.99
In Stock
Product Details
| ISBN-13: | 9783910233126 |
|---|---|
| Publisher: | Computertrainerin.de |
| Publication date: | 05/02/2023 |
| Series: | Short & Spicy , #11 |
| Sold by: | Barnes & Noble |
| Format: | eBook |
| Pages: | 78 |
| File size: | 9 MB |
About the Author
From the B&N Reads Blog