🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I am a Microsoft Instructor and own my own Post Secondary school - Excel has always been hard to explain these features to beginners who fear Excel because no one is able to teach it so newbies can understand. You broke that mold Kev! Thanks for giving me simplicity so I can give that to my students!!
Remember all these days needing to look at his videos quickly to understand something quickly on excel. Now I'm probably going to need to watch videos from Kevin most of the time and wow didn't realise how enjoyable these videos really are. Got a knack for making boring things look interesting, and that is a true talent...
Kevin is such an amazing teacher. He intuitively expects the exact question that pops in my mind as he instructs, and always answers simply, thoroughly and pleasantly. One request - with all the 60+ fantastic videos available, I wish they could be listed in order of basic to difficult, so I know what to watch next. I know it's subjective for some, looking for a specific tasks.
vlookup and xlookup are very confusing for me but your tutorials are super awesome! I love how you repeat the steps and those repeats greatly improve my understanding of these functions. The different levels of examples are interesting. Thanks, Kevin for all your outstanding and consistent tutorials. I just search for your name whenever I require any tutorials 😊
Thank you Kevin for the nested Xlookup example! Even though we may alternatively use INDEX and MATCH functions to get the same result, nested Xlookup is much easier to use!
You know what i always try to watch videos even i know that featur but i willalways be amazed by hidden or complete futures until u have covered. Today its returnin multiple lists and without helper column combining search array and grideview.
Thank you Kevin! I'm learning so much about "Lookup" functions. People handle so many data and this is a great help for those who work a lot with Excel sheet.
Remarkable Explanation Kevin!! I know VLOOKUP but XLOOKUP was new to me🤔. Thanks for the explanation. It was very crisp and precise👍.... Now that I know both LOOKUPs I can easily work between different sheets. I have recommended your channel to my dad and friend and they are really benefitting it!👏👏
Always so helpful… thank you!!! And you know what?? You’ve been learning too much about cookies!! Why don’t you open your own Cookie Bakery??? But please, don’t quit the UA-cam Channel (is freacking awesome!! I told you before that at my office, I asked my employees to use your tutorials! Thanks man!! Keep it going and I expect a sample of Kevin’s Cookies!!
I'm grateful for your content, Kev! Learning this in school and your explanation is way better! Thank you for also using cookies as an example -- I'm able to understand 100%
Hopefully in the future there will be something called Diagonal Look Up. That would be hysteric? Loved the video and thanks for a chocolate chip cookie!! 😋🍪
VLOOKUP then XLOOUP. Aww! These videos are soooo informative. Also a note even my favourite Cookie is the chocolate chip cookie from the Kevin Cookie Company. I'm not a MS 365 subscriber, hopefully, soon I will. When I do I will surely watch this video again. Very informative, Great Video!
Thank you Kevin, this was just what I needed! I have had this feature available to me for over a year, but I was just so used to VLookup, and accommodating my data to facilitate it working, but this is really a game changer and will make for less complicated spreadsheets.
I am from Saudi Arabia and my English is not good, and despite that, I used a translator to put a comment for you. I wish you would put an Arabic translation because your content is very easy and easy to apply, so this is my wish
Well explained as always, thank you. Question: do you think the XLOOKUP function is intended to replace the INDEX-MATCH combination for performing lookups?
If I could give 2 Likes to this video, I would give them immediately!. Clear, concise, direct and at good pace to understand what Kevin is doing. Thanks Kevin!
I need to use this function once a year in a spreadsheet, and i never remember how. I have this playing in the background while I do other work. This stuff is like watching paint dry lol. Thanks for creating videos like this though. The tiny jokes make it less painful
Xlookup is too good I learnt so much I am looking for this video everywhere then I saw your channel has uploaded the video superb Kevin keep it up 👌👌👌👍👍👍👍👍👍❤️❤️
Guess what Kevin, we share some feelings together! I like excel tutorials and so do you, I like chocolate cookies and so do you! Just the difference is that you are an Excel Champion while I am still becoming one.... Thanks for these never-ending tutorials🔥🔥
Your explanations are great with the different xlookup scenarios. My only feedback for you is to slow down just a little bit when going thru the steps. It doesn't hurt to go thru even if trying to speed it up the lookup and return array selections either. The later parts of the video U sped past the lookup and return array and assumed the viewer would know what to put in. I wouldn't assume the viewer will automatically catch on or remember what to put in. It helps for repeating some viewers who like to take time to process and grasp the concept. Different types of learners & how they are processing information are viewing your videos so take time to understand that when doing future videos.😊
Kevin, I have enjoyed your videos and how simple but effective are your explanations and sequence you use to explain concepts. Kudos. As an educator I take my hat to you. Outstanding and keep up this great work.
@@KevinStratvert actually I working on 12-15 excel sheet in one workbook, and I just want to make a summary of these excel sheet, but I don't how to do that. Can you please tell me how to make a summary of all worksheet of workbook in a single sheet.🙏
Great video! But at 5:20 when you switched to horizontal, did you use TRANSPOSE to convert the table from vertical to horizontal? I used transpose to convert the table to horizontal, but when I tried to convert that horizontal list to a table, I got an error message saying: "Multi-cell array formulas aren't allowed in tables." Is there a solution other than manually keying in the table as horizontal?
Hi Sir Would you please help to sort out my problem? I have a work sheet where VLOOKUP working properly but when i add a cell value that contain sheet name using formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255). No issue at all, adding sheet name manually in that cell. but adding with formula i got error.
Great job. I love your tutorials. They are clear and well structured. Unfortunately i have a hard time using this one to solve a problem. I cant find xlookup (btw i have a fench version of excel cause i'm in Quebec, Canada) I have an interesting problem to submit as a study case. It's about pairing student's to trainng site according to they priority choice list versus the number of sites available and the number of positions in the site also respecting the rank of the student. It doesnt seem to work using Index, Match and Xlookup so i'm thinking about writing a macro but i would rather have it done with formulas. Msg me for more information. Thanks and keep doing those great tutorial but if you coul add the according function in french version that would help me a lot.
hey Kevin, I was trying Xlookup and the way you explained it was super easy and it worked. But when I tried it for the merged columns, it did not. can someone help me with that
Kevin you have such interesting and informative videos......I have a question...am a teacher and am tired of marking exams or assignments for my students....whether in soft or hard copy....what approach can I use to ease my work and safe me time to do other things.....preferably using my computer?....my name is Philip......Thank you
You could use Microsoft Forms or Google Forms to design your assignments / exams. You can pre-program correct answers and then the service can grade any non-open ended questions.
Nested lookup- what I came for 🙌 One question though, is it necessary for the years (the example in your data 2020,2021 etc) to be in a continuous columns for the formula to work. If the years are in column B, D, F, would it still work?
Can you make a video that will return a partial string such as 'Ft G Meade, MD' from a text string 'Fort George Meade, MD'? Both are from different tables. Both table values will be joined together.
thanks a lot, i'm a big fan of the function helper too hahaha.. Anyway x lookup works great but not with multiple values, i get the error value... why is that?
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I am a Microsoft Instructor and own my own Post Secondary school - Excel has always been hard to explain these features to beginners who fear Excel because no one is able to teach it so newbies can understand. You broke that mold Kev! Thanks for giving me simplicity so I can give that to my students!!
Remember all these days needing to look at his videos quickly to understand something quickly on excel. Now I'm probably going to need to watch videos from Kevin most of the time and wow didn't realise how enjoyable these videos really are. Got a knack for making boring things look interesting, and that is a true talent...
Kevin is such an amazing teacher. He intuitively expects the exact question that pops in my mind as he instructs, and always answers simply, thoroughly and pleasantly.
One request - with all the 60+ fantastic videos available, I wish they could be listed in order of basic to difficult, so I know what to watch next. I know it's subjective for some, looking for a specific tasks.
vlookup and xlookup are very confusing for me but your tutorials are super awesome! I love how you repeat the steps and those repeats greatly improve my understanding of these functions. The different levels of examples are interesting. Thanks, Kevin for all your outstanding and consistent tutorials. I just search for your name whenever I require any tutorials 😊
0:00 - Hi Kevin. 👋 16:39 - 284th thumbs up from me. 👍 Cheers.
Ah this is the best tutorial and best formula! So much better than VLOOKUP!
Thank you Kevin for the nested Xlookup example! Even though we may alternatively use INDEX and MATCH functions to get the same result, nested Xlookup is much easier to use!
As usual, always easy to understand, digest, remember and yet really effective tutorial. Nice one Kevs, appreciate this.
Your "timestamp" is an excellent idea. Thank You 🙂
Kelvin you such a sweet man... this short video, hv made me understand xlookup with ease after years of confusion...
You're a great teacher..😊😊❤
*Why haven't I been using this function! it's the Biz! Thanks Kevin! You're the GOAT!*
Thanks 😊 Kevin✨✨✨✨✨
Nothing better than watching Kevin's video and eating a chocolate cookie 🍪
Learned about the multiple values returned and nested XLOOKUP. Thx 😊
👍
You know what i always try to watch videos even i know that featur but i willalways be amazed by hidden or complete futures until u have covered. Today its returnin multiple lists and without helper column combining search array and grideview.
YOUR TEACHING IS PRECISE NO NON-SENSE TALKS, KEEP IT UP
Hey Kevin you always upload the videos which I need the most at just the right time 😀
The best explanation in the world. Thank you
Thanks for uploading again waiting for this :) ❤
Near 1M Subscriber's and he deserves :D
Unbelievable explanation Kevin, I had watched your previous video about VLOOKUP and HLOOKUP but I was not knowing about this. Thanks again :-)
Thank you Kevin! I'm learning so much about "Lookup" functions. People handle so many data and this is a great help for those who work a lot with Excel sheet.
KEVIN you are so good at your teaching, I appreciate
Thank you for these tuto @Kevin...almost 1.000.000 sub you deserve it 👏
Your lessons are the best. To the point and clear. Thank you so much.
a xlookup nested in another xlookup, cool !
😁
Hey Kevin, I have enjoyed your videos, and you help me a lot in my post secondary studies with excel stuff, much appreciated.
Remarkable Explanation Kevin!! I know VLOOKUP but XLOOKUP was new to me🤔. Thanks for the explanation. It was very crisp and precise👍.... Now that I know both LOOKUPs I can easily work between different sheets. I have recommended your channel to my dad and friend and they are really benefitting it!👏👏
You are the best excel teacher💫
The slow you teach, the more we learn.. This video was really helpful, thank you so much.
Kevin sir u r really epic...... 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Absolutely love this level of explanation and detail and ease of use!
The best way to learn excel and Power bi! Thanks thanks thanks. Easy to understand and apply.
Awesome Kevin. Thanks. You make life easy for us.
Excellent! Thank you for your video!
Always so helpful… thank you!!!
And you know what?? You’ve been learning too much about cookies!!
Why don’t you open your own Cookie Bakery???
But please, don’t quit the UA-cam Channel (is freacking awesome!! I told you before that at my office, I asked my employees to use your tutorials!
Thanks man!! Keep it going and I expect a sample of Kevin’s Cookies!!
Using SUM with XLOOKUP is brilliant idea
I'm grateful for your content, Kev! Learning this in school and your explanation is way better! Thank you for also using cookies as an example -- I'm able to understand 100%
Amazing video Kevin! 😁😁 and that thumbnail is just AWESOME!! 😎😎 and I also LOVE chocolate chip cookies!! 😁😎
Hopefully in the future there will be something called Diagonal Look Up. That would be hysteric?
Loved the video and thanks for a chocolate chip cookie!! 😋🍪
Thanks Kevin, you helped me complete about 3 hours of work into 3 minutes :)
woohoo! 😁
Thank you Kevin. Very clear explanation
VLOOKUP then XLOOUP. Aww! These videos are soooo informative. Also a note even my favourite Cookie is the chocolate chip cookie from the Kevin Cookie Company. I'm not a MS 365 subscriber, hopefully, soon I will. When I do I will surely watch this video again. Very informative, Great Video!
Thank you Kevin, this was just what I needed! I have had this feature available to me for over a year, but I was just so used to VLookup, and accommodating my data to facilitate it working, but this is really a game changer and will make for less complicated spreadsheets.
Thank you Kevin, you are amazing!
You officially have to use your cookie analogies as long as you are on UA-cam lol awesome video!
As usual!!! Wonderful video!!!! Million thanks again!!!!!!!
Thank you so so much of this! Exactly what I was looking for. 🎉
Very nice as usual. Love the way you explains.
Wonderful work, much apprecited. Hats off!
Spot on mate. This was what I needed. Just the basic explanation to get it working. Thanks. Most video's go too far.
You're the best!! Thanks a lot!
I am from Saudi Arabia and my English is not good, and despite that, I used a translator to put a comment for you. I wish you would put an Arabic translation because your content is very easy and easy to apply, so this is my wish
Thank you sir for the excellent tips and tricks!
Such an interesting and informative tutorial. And your timestamps are amazing too.
Nice work Kevin!
thanks man, made my life a lot easier :)
Well explained as always, thank you.
Question: do you think the XLOOKUP function is intended to replace the INDEX-MATCH combination for performing lookups?
Great function
If I could give 2 Likes to this video, I would give them immediately!. Clear, concise, direct and at good pace to understand what Kevin is doing.
Thanks Kevin!
16mins? utube shorts worked better
You earned a subscriber.
I need to use this function once a year in a spreadsheet, and i never remember how. I have this playing in the background while I do other work. This stuff is like watching paint dry lol. Thanks for creating videos like this though. The tiny jokes make it less painful
Thanks this really help me find a value in work 😎
Thanks, Kevin.
Thank you ❤️❤️
love this guy
that was very useful thank you so much
great video, thank you
Xlookup is too good I learnt so much I am looking for this video everywhere then I saw your channel has uploaded the video superb Kevin keep it up 👌👌👌👍👍👍👍👍👍❤️❤️
Love this video!!!
Thank you so much!
Good
Oh, that's nice! I've had to do some monkey business in the past with Vlookup, getting the proper column at the leftmost of the range.
does thi work for Oreo Cookies?
the first example in xlook up, looks like a function I use in lotus alot, when started using Excel, I miss a lot that functon
Guess what Kevin, we share some feelings together! I like excel tutorials and so do you, I like chocolate cookies and so do you! Just the difference is that you are an Excel Champion while I am still becoming one.... Thanks for these never-ending tutorials🔥🔥
dont remember subsrcibing to you,
thought i don't regret it.
You had me at "final boss."
Your explanations are great with the different xlookup scenarios. My only feedback for you is to slow down just a little bit when going thru the steps. It doesn't hurt to go thru even if trying to speed it up the lookup and return array selections either. The later parts of the video U sped past the lookup and return array and assumed the viewer would know what to put in. I wouldn't assume the viewer will automatically catch on or remember what to put in. It helps for repeating some viewers who like to take time to process and grasp the concept. Different types of learners & how they are processing information are viewing your videos so take time to understand that when doing future videos.😊
Thanks for the feedback! Will incorporate into future videos.
Kevin, I have enjoyed your videos and how simple but effective are your explanations and sequence you use to explain concepts. Kudos. As an educator I take my hat to you. Outstanding and keep up this great work.
Thank you so much... is there a way to copy/paste the information that you have used xlookup?
Terima kasih tutorialnya sangat membantu
Can you please tell us how to consolidate the excel workbook, 🙏🙏🌸
Tell me more about what you’re trying to do.
@@KevinStratvert actually I working on 12-15 excel sheet in one workbook, and I just want to make a summary of these excel sheet, but I don't how to do that. Can you please tell me how to make a summary of all worksheet of workbook in a single sheet.🙏
Thanks Kevin for making Excel easy and exciting. Can you please make a guide for using xLookup in horizontal tables instead of vertical ones?
Great video! But at 5:20 when you switched to horizontal, did you use TRANSPOSE to convert the table from vertical to horizontal? I used transpose to convert the table to horizontal, but when I tried to convert that horizontal list to a table, I got an error message saying: "Multi-cell array formulas aren't allowed in tables." Is there a solution other than manually keying in the table as horizontal?
Can you create a video on how to create a 2*2 passport photo ?
Hi Sir
Would you please help to sort out my problem? I have a work sheet where VLOOKUP working properly but when i add a cell value that contain sheet name using formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255). No issue at all, adding sheet name manually in that cell. but adding with formula i got error.
Great job. I love your tutorials. They are clear and well structured.
Unfortunately i have a hard time using this one to solve a problem. I cant find xlookup (btw i have a fench version of excel cause i'm in Quebec, Canada)
I have an interesting problem to submit as a study case. It's about pairing student's to trainng site according to they priority choice list versus the number of sites available and the number of positions in the site also respecting the rank of the student.
It doesnt seem to work using Index, Match and Xlookup so i'm thinking about writing a macro but i would rather have it done with formulas.
Msg me for more information.
Thanks and keep doing those great tutorial but if you coul add the according function in french version that would help me a lot.
It's crazy good
hey Kevin, I was trying Xlookup and the way you explained it was super easy and it worked. But when I tried it for the merged columns, it did not. can someone help me with that
Kevin you have such interesting and informative videos......I have a question...am a teacher and am tired of marking exams or assignments for my students....whether in soft or hard copy....what approach can I use to ease my work and safe me time to do other things.....preferably using my computer?....my name is Philip......Thank you
You could use Microsoft Forms or Google Forms to design your assignments / exams. You can pre-program correct answers and then the service can grade any non-open ended questions.
Thank you
Nested lookup- what I came for 🙌 One question though, is it necessary for the years (the example in your data 2020,2021 etc) to be in a continuous columns for the formula to work. If the years are in column B, D, F, would it still work?
amazing
greatbjob,loveya
Can you make a video that will return a partial string such as 'Ft G Meade, MD' from a text string 'Fort George Meade, MD'? Both are from different tables. Both table values will be joined together.
thanks a lot, i'm a big fan of the function helper too hahaha.. Anyway x lookup works great but not with multiple values, i get the error value... why is that?
Could you use xlookup to return all of Lola’s order dates in separate columns?
Great !!!!