Скачать с ютуб 10 Advanced XLOOKUP Tips & Tricks в хорошем качестве

10 Advanced XLOOKUP Tips & Tricks

You don't need a guitar to make your data sing 🎶🎵 You just need XLOOKUP. In this video, I present 10 advanced tricks to master the XLOOKUP function. Dive in and thank me later :) ~ In this video: 0:00 - XLOOKUP Rockstar - 10 advanced examples 0:50 - Setting up data in a table format 1:15 - XLOOKUP Syntax and basic usage (TRICK 0) 2:30 - Get all columns of data with XLOOKUP (Trick 1) 3:35 - Get all columns, but vertically (Trick 2) 4:18 - Lookup values that begins with (wild card match, Trick 3) 5:42 - Equal to or higher than lookup (Trick 4) 7:02 - Multiple conditions with XLOOKUP (Trick 5) 9:44 - Lookup between two dates (Trick 6) 11:52 - Lookup highest value (Trick 7) 14:34 - Advanced Lookup of highest value (Trick 8) 15:38 - Second matching value (Trick 9) 18:13 - Get all matching values with XLOOKUP (Trick 10) 18:44 - Bonus: XLOOKUP but get two different columns. 20:21 - Other important Excel functions for your success 📂 Download the sample file to practice: ================================= Get the sample file and practice these 10 tricks today: https://chandoo.org/wp/wp-content/upl... Even more examples here: https://chandoo.org/wp/xlookup-examples/ 📺 Watch next: ============= Advanced Excel Functions - Play List    • Advanced Excel Formula Examples   Top 10 Excel Functions for Data Analysis    • Top 10 Excel Functions you should lea...   Top 10 Excel Functions for Finance People    • If you work in finance, here are the ...   Top 10 Excel Functions for Data Cleaning    • Data Cleaning in Excel - 10 Tricks (B...   Top 10 Advanced Examples of SUMIFS    • 10 *next level* SUMIFS tricks only Ex...   How to use XLOOKUP    • I don't use VLOOKUP anymore. I use th...   How to use FILTER    • I don’t use filters in Excel anymore....   How to use VLOOKUP    • How to use Excel VLOOKUP? Complete Be...   How to use IF formula    • 10 Advanced IF formulas every analyst...   📚 FULL Excel Course ================== I run a complete Excel course to make you a rockstar at work. Please check out the program herE: https://chandoo.org/wp/excel-school-p... ~ Why can't we add guitars? 🎸+ 🎸 Because they are STRING instruments. 😂 #vlookup #xlookup