Uploaded November 2023 | Updated November 2026, 1 hour ago
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:
chandoo.org/wp/wp-content/uploads/2023/11/xlookup-10-adv-examples-practice.xlsx
Even more examples here: chandoo.org/wp/xlookup-examples
πΊ Watch next:
=============
Advanced Excel Functions - Play List
youtube.com/playlist?list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
Top 10 Excel Functions for Data Analysis
youtu.be/HgNCvd8IbSc
Top 10 Excel Functions for Finance People
youtu.be/xarUaqsjmFY
Top 10 Excel Functions for Data Cleaning
youtu.be/q7EpoOwBcnM
Top 10 Advanced Examples of SUMIFS
youtu.be/YEt-aYbDTrs
How to use XLOOKUP
youtu.be/DDlZXXEI1bU
How to use FILTER
youtu.be/JuTdj2j-9Kg
How to use VLOOKUP
youtu.be/8rtvDQVQaA0
How to use IF formula
youtu.be/-yFpzIRifK4
π FULL Excel Course
==================
I run a complete Excel course to make you a rockstar at work. Please check out the program herE:
chandoo.org/wp/excel-school-program
~
Why can't we add guitars? πΈ+ πΈ
Because they are STRING instruments. π
#vlookup #xlookup
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:
chandoo.org/wp/wp-content/uploads/2023/11/xlookup-10-adv-examples-practice.xlsx
Even more examples here: chandoo.org/wp/xlookup-examples
πΊ Watch next:
=============
Advanced Excel Functions - Play List
youtube.com/playlist?list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
Top 10 Excel Functions for Data Analysis
youtu.be/HgNCvd8IbSc
Top 10 Excel Functions for Finance People
youtu.be/xarUaqsjmFY
Top 10 Excel Functions for Data Cleaning
youtu.be/q7EpoOwBcnM
Top 10 Advanced Examples of SUMIFS
youtu.be/YEt-aYbDTrs
How to use XLOOKUP
youtu.be/DDlZXXEI1bU
How to use FILTER
youtu.be/JuTdj2j-9Kg
How to use VLOOKUP
youtu.be/8rtvDQVQaA0
How to use IF formula
youtu.be/-yFpzIRifK4
π FULL Excel Course
==================
I run a complete Excel course to make you a rockstar at work. Please check out the program herE:
chandoo.org/wp/excel-school-program
~
Why can't we add guitars? πΈ+ πΈ
Because they are STRING instruments. π
#vlookup #xlookup
![How to make an employee time tracker with Excel [Easy setup]
π₯Check out Connecteam π https://connecteam.cc/3QSAjlQ
~
Recently I needed to make a timesheet solution for my clients. I used Excel 365 with forms to create a quick & elegant application. It works on phones, web browsers and PC. You can track shift information and consolidate the data at the end of month for payroll processing.
In this video, let me present you with the solution and approach I took.
For an easier and error proof solution, do check out the sponsor of this video Connecteam here - https://connecteam.cc/3QSAjlQ
~
Timestamps for the video:
0:00 - Demo of my time tracking app
1:06 - Creating the app using Excel on web
1:52 - Setting up the data entry form
3:45 - Adding Branching Logic to show different options based on the data entered.
4:32 - Saving and publishing the form (app)
5:30 - Testing our app
8:12 - The problem with our solution
8:45 - A better time tracking solution (with Connecteam)
~ How to make an employee time tracker with Excel [Easy setup]](https://i.ytimg.com/vi/ZJLYMYhtDRc/mqdefault.jpg)
![This formula changes how you make dashboards [TOPN in One Cell]
TEXTJOIN magic for your next dashboard This formula changes how you make dashboards [TOPN in One Cell]](https://i.ytimg.com/vi/Zj4tQP-Cptc/mqdefault.jpg)

![Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?
Do you wonder what is the difference between a data analyst, engineer and scientist is? In this video, let me explain what these 3 roles are, what skills you need to get in, how the career path looks like, what is the typical salary and how the work feels. LETS GO!
β± IN THIS VIDEO:
0:00 - Data Engineer vs. Data Analyst vs. Data Scientist
0:35 - The rules
1:08 - What they do? DE vs. DA vs. DS
4:07 - Skills you need to be a Data Engineer
5:38 - Skills needed for Data Analyst
6:56 - Skills for Data Scientists
9:01 - Salaries for Data Engineer vs. Data Analyst vs. Data Scientist
11:24 - Career pathways for Data engineer / analyst / scientist
14:11 - People you work and how the work looks like
16:08 - Getting the skills
π WANT MORE?
If you want more, consider my paid courses. They are the best in the world when it comes to explaining complex data concepts in lucid and practical terms. Check out the courses using the links below and sign up today.
Essential Data Skills with Excel - https://chandoo.org/wp/excel-school-program/
Essential Data Skills with Power BI - https://chandoo.org/wp/power-bi-course/
πΊ DATA PLAYLISTS
Data Analyst vs. Business Analyst - What is the difference? - https://youtu.be/pIbL4aSUIas
Tech skills needed to be a data analyst: https://youtu.be/R3bZ0LLv3Fk
Data Analyst 3-month roadmap: https://youtu.be/x0Cd4TTOgwI
Day in the life of a Data Analyst: https://youtu.be/Lc55Y7Ai23Q
Top 10 Data Analyst interview questions: https://youtu.be/MX6Ee_ubE1s
7 critical mistakes to avoid in Data Analyst interviews: https://youtu.be/f7lBYh1_9BQ
5 Skills you need to be a GREAT data analyst: https://youtu.be/gVr9f1GJdZc
[Playlist] Data Analyst Skills: https://www.youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
[Playlist] Data Careers, Interview and Job Prep: https://www.youtube.com/playlist?list=PLmejDGrsgFyAw9Qya6SgrXfcfKCn7Va_D
~
#dataengineer #datascientist #dataanalyst
~
Data analyst: The glass is 50% full π₯
Data scientist: The glass is over fitting the water π
Data Engineer: Somewhere a pipeline must have broken. Only half the water is loaded π€ Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?](https://i.ytimg.com/vi/ZyRH6FMcVlw/mqdefault.jpg)






