🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@hederamom2 жыл бұрын
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.
@Kaz-nf4ns6 ай бұрын
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 😊
@ochuutv71953 жыл бұрын
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..😊😊❤
@emilykasuya2 жыл бұрын
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...
@baltic23023 жыл бұрын
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!
@KristinPelletierMOS9 ай бұрын
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!!
@loloysan64173 жыл бұрын
As usual, always easy to understand, digest, remember and yet really effective tutorial. Nice one Kevs, appreciate this.
@allpoems3 жыл бұрын
Your "timestamp" is an excellent idea. Thank You 🙂
@SavageGothamChess3 жыл бұрын
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!! 😋🍪
@piyushmohapatra46423 жыл бұрын
Hey Kevin you always upload the videos which I need the most at just the right time 😀
@prof.code-dude27503 жыл бұрын
Nothing better than watching Kevin's video and eating a chocolate cookie 🍪
@keishrich3 жыл бұрын
Learned about the multiple values returned and nested XLOOKUP. Thx 😊
@KevinStratvert3 жыл бұрын
👍
@SpotlightImpact2 жыл бұрын
Ah this is the best tutorial and best formula! So much better than VLOOKUP!
@iz65833 жыл бұрын
Thank you for these tuto @Kevin...almost 1.000.000 sub you deserve it 👏
@manakahthey9 ай бұрын
Your lessons are the best. To the point and clear. Thank you so much.
@canirmalchoudhary81733 жыл бұрын
Using SUM with XLOOKUP is brilliant idea
@naveen2008483 жыл бұрын
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.
@Ben007192 жыл бұрын
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.
@AvanishKesharwani3 жыл бұрын
Unbelievable explanation Kevin, I had watched your previous video about VLOOKUP and HLOOKUP but I was not knowing about this. Thanks again :-)
@blackestknight1.0 Жыл бұрын
*Why haven't I been using this function! it's the Biz! Thanks Kevin! You're the GOAT!*
@daiwikkrishna82133 жыл бұрын
Thanks for uploading again waiting for this :) ❤
@UgoCynthia Жыл бұрын
KEVIN you are so good at your teaching, I appreciate
@aplanasroca3 жыл бұрын
Excellent! Thank you for your video!
@peekaboo57093 жыл бұрын
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%
@EnergyHammerGOAT3 жыл бұрын
Near 1M Subscriber's and he deserves :D
@Tpazmachine Жыл бұрын
Absolutely love this level of explanation and detail and ease of use!
@kidspartygames76043 жыл бұрын
Thank you Kevin. Very clear explanation
@pramila9472 Жыл бұрын
The slow you teach, the more we learn.. This video was really helpful, thank you so much.
@baqeralzaki9234 Жыл бұрын
The best explanation in the world. Thank you
@J.O.J13 жыл бұрын
Thanks 😊 Kevin✨✨✨✨✨
@LouisIvara Жыл бұрын
Awesome Kevin. Thanks. You make life easy for us.
@icychickliu65003 жыл бұрын
a xlookup nested in another xlookup, cool !
@KevinStratvert3 жыл бұрын
😁
@kvelez4 ай бұрын
Thanks, Kevin.
@JustBlankNoInfo3 жыл бұрын
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!
@chandrashekharkale1697 Жыл бұрын
Very nice as usual. Love the way you explains.
@binetta856 ай бұрын
Thank you Kevin, you are amazing!
@emilythechef2 жыл бұрын
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.
@auritan32912 жыл бұрын
As usual!!! Wonderful video!!!! Million thanks again!!!!!!!
@saraabdulmonam12803 жыл бұрын
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
@MoodyAlshehaby Жыл бұрын
Wonderful work, much apprecited. Hats off!
@davids33132 жыл бұрын
Thanks Kevin, you helped me complete about 3 hours of work into 3 minutes :)
@KevinStratvert2 жыл бұрын
woohoo! 😁
@koodauskanava9096 Жыл бұрын
Thank you so so much of this! Exactly what I was looking for. 🎉
@jeffc52183 жыл бұрын
No more index match match no more V and H😁
@patwidmayer87712 жыл бұрын
You had me at "final boss."
@Voske09107 ай бұрын
thanks man, made my life a lot easier :)
@robertwhittle37832 жыл бұрын
Thanks this really help me find a value in work 😎
@Ally1232345 ай бұрын
great video, thank you
@Thiago-im4ly6 ай бұрын
Nice work Kevin!
@cenevspeed_CARS3 жыл бұрын
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🔥🔥
@jeremy_317 Жыл бұрын
You officially have to use your cookie analogies as long as you are on KZbin lol awesome video!
@ahmedbahram4653 Жыл бұрын
that was very useful thank you so much
@SRV025 Жыл бұрын
Thanks Kevin for making Excel easy and exciting. Can you please make a guide for using xLookup in horizontal tables instead of vertical ones?
@jennifercarrell11352 жыл бұрын
Love this video!!!
@konli6 ай бұрын
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
@aveerajsharma3 жыл бұрын
Thanks
@lssketchofficial3 жыл бұрын
Can you please tell us how to consolidate the excel workbook, 🙏🙏🌸
@KevinStratvert3 жыл бұрын
Tell me more about what you’re trying to do.
@lssketchofficial3 жыл бұрын
@@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.🙏
@samkitshah12073 жыл бұрын
Can you create a video on how to create a 2*2 passport photo ?
@elijahafola84184 ай бұрын
Thank you
@learnmaths5703 жыл бұрын
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
@KevinStratvert3 жыл бұрын
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.
@susilorejo2 жыл бұрын
Terima kasih tutorialnya sangat membantu
@danielgadoury91682 жыл бұрын
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.
@raktimmazumdar5794 Жыл бұрын
It's crazy good
@nsummy Жыл бұрын
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
@janthompson57125 ай бұрын
greatbjob,loveya
@aniruddhabehere98366 күн бұрын
Great !!!!
@GaurangsTechwithGM3 жыл бұрын
First to like comment and view..
@mockdux6 ай бұрын
Please do an advanced lesson on EXACT added into the second parameter so that I don't have to sort first.
@jayc3399 Жыл бұрын
Man Kevin Cookie Companies has its hands in many cookie jars lol
@loverofYahweh Жыл бұрын
Thank you so much Kevin, but I have two questions; 1. How did you convert your cost column to negative 2. In selecting the price and cost, what happens if the columns are not next to each other like we have in your example
@KristinPelletierMOS9 ай бұрын
I would think you would either hold your ctrl key to select 2 columns not next to each other OR the &. Try both to see if either one works.
@emilythechef2 жыл бұрын
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.
@aniruddh2025 Жыл бұрын
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
@taoufikelmiri2 жыл бұрын
That's a helpful function for database, thanks a lot. One question : when will the Office refreshed UI be available for consumers?
@T-cheerLeihoo Жыл бұрын
Hello, I would like to ask about tutorial xlook up to consolidate the lowest grade. column 1 are the names of the learners. column 1 and row 1 are the quarter grades. quarter 1 up to quarter 4. how to make formulas that shows the quarter in column 5 which the learner gets the lowest grade in every quarter?
@MK-ni6gs2 жыл бұрын
Top!
@InsightKnowlege Жыл бұрын
Hi mate, I am one of your subscriber and learned how to xlookup on csv files. I use xlookup in csv file to update shopify shop inventory as shopify only accept csv format. But the problem is when you use xlookup and after you close the file the xlookup function does not save and lost the formula. Please help if this is something wrong with my version of excel or the formulas doesn't not work with csv format. By the way i am using the lasters version of Microsoft 360.
@Dansk552 жыл бұрын
Thank you so much... is there a way to copy/paste the information that you have used xlookup?
@chris-zu6sf2 жыл бұрын
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.
@MonuMan5 Жыл бұрын
I believe the last example for Nested Lookup is wrong. The return value shows data all the way down the f column from f7 to f12. But there was no action done that would cause xlookup to show values going down. Also, if you drag the formula down it would result in errors because the selected table would move. Perhaps through a video edit something incorrect was shown?
@Tshiamo_Setshedi Жыл бұрын
It's like magic
@sharmilav60013 жыл бұрын
Hi Kevin, Can you pls help with the below query. When an youtube video is uploaded its fine. After some time, only audio is heard and video is blurred. What could be the issue? Please assist. Thank you
@KevinStratvert3 жыл бұрын
Hmm, you should reach out to KZbin support. They’re generally very helpful at tracking down any issues.
@sharmilav60013 жыл бұрын
@@KevinStratvert ,First of all Thank you for checking my msg and replying. Really appreciate it. I never expected it. You are awesome! Thank you for being so humble. Iam not a big youtuber..😁 just have 50 subscribers from a college group. Kind of mentoring and started doing some trainings on various subjects that i have learnt ..
@error73292 жыл бұрын
You can add in Xlookup in older version .
@rajeevdubey22612 жыл бұрын
Great
@antjdj2 жыл бұрын
Thank you! Your videos are so useful thank you. I am struggling with what i thought was the use of vlookup. Using 2 sheets. Sheet 1 has approx 100000 rows, of various data (A to E). In column A would be numeric values, some duplicate. Sheet 2 has 1100 rows, in column A is numeric values, which some are duplicates in Sheet 1 column A. The output I require is in blank cell (column f) in Sheet A, display data from Sheet 2 column B. Vlookup doesnt appear to work "NA". Any assistance would truly help (if it is indeed better in xlookup)
@erichfellmann4867 Жыл бұрын
Hi, Kevin. Very useful indeed. But I still have a problem. In a nested XLOOKUP, when using the capability 'If not found' equals 0, the whole formula fails, because the inside argument doesn't yield an array (but a 0). Is there a workaround for this? All the best.
@HaroldHafner1 Жыл бұрын
This is the closest video to what I’m trying to figure out. I want to copy what I’ve seen. Maybe you or someone can point me to a video that will help. One sheet has search box and clear (also can double click to clear). Second sheet has the data: year range, name, and “department” (which is what my search result would be). I want to be able to create this and have the results generate as I type “name” or a year in the “date range”. Example. Jim worked in IT from 2000-2017, type 2011 and it shows me Jim in IT Sarah worked in HR, etc. where can I find a training video to create this?
@vincentr.61093 жыл бұрын
Hello, this is my xloopup formula I have in my spread sheet: =XLOOKUP(1,B10:B400,A10:A400,,,-1). It works, but what if i want the look up value to be Greater than or Equal to "1". Is it possible to formulate that?
@ExcelSmith2 жыл бұрын
Hello. Your current equation returns a value when the lookup value is equal to 1. To return the value with a lookup value greater than 1, but the closest to 1, you could set the match mode to 1 (“Exact match or next larger item”). This would give the equation =XLOOKUP(1,B10:B400,A10:A400,,1,-1). With this modification, if your lookup array contains a 1, its corresponding value would be returned (same behavior as your existing equation). However, as an example, if your lookup array contains the values 0, 2, 1.2, 0.9, the modified equation would return the value corresponding to the third value, 1.2, as this is the closest value to 1 that is larger than 1 since there was no lookup value equal to 1. Alternatively, you could use INDEX and MATCH: =INDEX(A10:A400,MATCH(TRUE,B10:B400>=1,0)). This would return the first match greater than or equal to 1, which in the previous example would be the value corresponding to 2. MATCH only searches top to bottom. This is different from your XLOOKUP equation, but I wanted to include it in case it would work for your dataset. Both XLOOKUP and INDEX MATCH return a single value. If your data contains multiple values greater than or equal to 1 and you want to return all corresponding values, you could use the FILTER function, =FILTER(A10:A400,B10:B400>=1). Using the FILTER function with the previous example would return the values corresponding to both 2 and 1.2.
@thegriz19722 жыл бұрын
The file in description does not seem to match your video. The prices and cookie talk are distracting (even if they are kind of amusing :) ) I like your speaking voice and charismatic smile though....
@NealHartsChannel Жыл бұрын
I have Excel 2019 and xlookup doesn't work. I tried the Office App and Excel on the web and all it does is redirect to my computer and everything I try just opens up Excel 2019.
@romelsampul71492 жыл бұрын
Would like to ask in what excel version that xlookup available?
@tilted5_gaming2072 жыл бұрын
365
@tomek816 Жыл бұрын
this shit is challenging but great explanations sir
@mockdux6 ай бұрын
This didn't age well, cookies are $5 at Crumbl cookie and have been for a while.
@UniqueSide13 жыл бұрын
16th comment and 26th like 116th view
@AnhPhan-wq3ib2 жыл бұрын
Could you share which tool is used to record your screen
@KevinStratvert2 жыл бұрын
OBS Studio
@udeeshnagula98343 жыл бұрын
Second like , view and comment
@vantienyoutube81473 жыл бұрын
Giao lưu mọi người ơi. Hướng dẫn cách rép giọng nhân tạo vào video ko dính bản quyền
@lovebirds92613 жыл бұрын
Hello sir I want upload movie songs in KZbin can you help
@ardit99882 жыл бұрын
😍😍😍
@Study_Motivation2Success3 жыл бұрын
❤✨️
@shastaham76302 жыл бұрын
Looks like you had a better recipe and/or marketing for fortune cookies in 2020. Something, however, seems to indicate an inconsistency in revenue. Perhaps it's quality control. If this is the case, I humbly offer my services as an experienced and biased, but, most importantly, totally uncorruptible taste tester.