How to Use Excel's New TAKE Function to Impress Your Boss and Colleagues

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This tutorial is a step by step deep dive into understanding how to use the Excel TAKE function. With the new TAKE function in Microsoft Excel you can extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction and calculations in combination with other Excel functions. For example, you can combine TAKE with the FILTER function. This way you can filter your dataset by certain criteria and then return the top/bottom rows. Or combine TAKE with SORTBY to sort your data by a certain column and then return the top/bottom N results. We'll also cover how you can combine TAKE with another new function: VSTACK. If you're wondering what the difference between TAKE and CHOOSECOLS or CHOOSEROWS functions are, I cover that in the tutorial.
⬇️ Grab the file I used in the video from here 👉 pages.xelplus.com/take-functi...
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
🔍 What You'll Learn:
- How to use the Excel TAKE function for practical data analysis.
- Techniques for combining TAKE with other functions like FILTER, SORTBY, and VSTACK.
- Insights into creating dynamic, efficient formulas for both basic and complex data scenarios.
👩‍💼 Perfect for:
- Excel users seeking to simplify data analysis tasks.
- Anyone in marketing, sales, or finance needing quick insights from recent data.
- Excel enthusiasts eager to explore new, efficient function combinations.
📌 Key Highlights:
- Analyze recent trends by extracting the latest data rows.
- Sort and filter data dynamically using TAKE with other Excel functions.
- Efficiently manipulate large datasets for insightful results.
00:00 How to Use TAKE Function to Extract Data in Excel
01:12 How Excel TAKE Function Works
02:13 Difference between TAKE & CHOOSECOLS or CHOOSEROWS
02:58 TAKE & Average of Last Rows
04:12 Combine Excel FILTER and TAKE Function
05:13 Combine SORTBY and TAKE Function
07:32 Combine VSTACK and TAKE Function
09:55 Wrap Up
🎬 LINKS to related videos:
Excel VSTACK: Quickly Combine Data from Multiple Sheets: • VSTACK Excel - Quickly...
How To Use Excel FILTER Function With Multiple Criteria: • How To Use Excel FILTE...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/take-function-file

[@MrSupernova111]

Its incredible how much Excel is evolving. I'm an expert Excel user and I feel that with so many new 365 functions I need to revamp my Excel skills.

[@LeilaGharani]

There really was a lot of development the last couple of years.

[@kirk1968]

Right? I've been using Excel since the mid-90s and its ever-expanding capabilities mean back to learning cool new stuff 😁

[@ekevanderzee9538]

Same

[@PeymanSayyadi]

I use excel everyday but I didn't know about Take, Choosecols and chooserows until today. Thanks for the great video.

[@sevaspeto]

This is INVALUABLE right now -- there's an analysis I was working on yesterday that requires making a unique, chronological dynamic array of dateranges from multiple tables and I was NOT aware of VSTACK but that is exactly what I need. You're an absolute GODSEND, Leila! ❤❤

[@mattjoy4588]

Thank you so much for your kind words! I'm glad to hear that you found the video helpful and that the VSTACK function will be useful for your analysis. It's always great to hear that my videos are making a difference for people. If you have any other questions or topics you'd like me to cover, feel free to let me know.

[@captvo]

Yet another TAKE on your incredible, clean and crisp teaching videos!😅

[@chh8860]

"TAKE function"??? ... never heard of it. But ONLY 37 seconds 'in' and I was hooked; " ... If you're familiar with the OFFSET function, this TAKE function is a lot easier to write and remember....". I sat back with my morning hot coffee (and pound cake) and shook my head in wonder for the next 9+ minutes ... ideas!!! ... ideas!!! ... ideas!!! ... 🤯🤯🤯. As I have commented many times before, 'Thursdays With Leila' doesn't disappoint ... thank you ... thank you ... thank you ... 😍 ...😍 ...😍.

[@LeilaGharani]

Thanks Chris! Hope you enjoyed the cake 😋

[@chh8860]

@@LeilaGharani I enjoyed the video more ... 😉

[@kpsrathore]

Another great value function from Excel and of course, very well explained. Especially when you split the whole process into smaller fragments and that makes things very clear. Great work.

[@LeilaGharani]

Thank you!

[@ajs11201]

@@LeilaGharani Actually, we should be thanking YOU.... Your videos are enormously helpful to us mere mortals.... 🙂

[@govardhangunda1823]

​@@LeilaGharani thank you so much for the detailed explanation We need one suggestion from you We are working on a large excel file having more 30 to 40 mB files So considering above data can you suggest which laptop is helpful for team or which configuration is required

[@uchewilliam9470]

Amazing lecture Leila. Thanks for always being a source of inspiration to us all.

[@AngelGonzalez-ce9ki]

Excellent use of the different functions combination. I love the way you just break it down to make it so easy to understand. Just comes to prove that Excel is so versatile and there are endless applications for it. Thank you Leila.

[@CJ-gn8ud]

combination use of different formula together is really cool! Thank you Leila for such valuable video!

[@Donkeys_Dad_Adam]

Hi Leila! I've been following your videos for years now and have taken some of your classes (I need to take the Power BI class soon!). I just want to say the way you present topics and produce videos has evolved so much! it's just amazing! I make a lot of videos internally for my company and I'll never be at your level ;-). Thanks for all you do!

[@reng7777]

Hi Leila i really admire the way you teach but not just the way you teach and explanain the step by step of excel fucntions but you also look for further functionallyties to explode in a single function by combining them with other functions that is where your CREATIVITY comes out and makes the differances with other youtubers!!

[@jimloader2]

Already using that one, it is so powerful !! But I didn't know about the curly brackets option on the take function, very useful ! Another great video by the way !! Total fan of you !

[@LeilaGharani]

Thanks David

[@daXcel7448]

CHOOSECOLUMNS +SEQUENCE =TAKE. For example, CHOOSECOLUMNS(Array, SEQUENCE(2)) returns the first two data columns. Thanks for the video.

[@eddycha8009]

That pop up message that asks for new people to subscribe 🔥🔥🔥🔥🔥.

[@ym10up]

Oh the curly brackets part is so good!

[@franzzzis]

clever and stringent explanation for using this functions hand in hand for solving a problem ... very smart!

[@MiRofek]

Awesome tutorial! As always. I love dynamic functions and formulas.

[@fiattenebris]

Hey Leila, thank you so much for your content! I've been following you as of late to improve my Excel and Power BI skills, and I would say your channel is a hidden gem in the internet. The TAKE function was new to me, but I can't wait to use it now. Just one note on the last two examples: I believe the arguments for "highest/top" and "lowest" have switched signs, where "highest/top" should be negative and "lowest" should be positive. Just something you might want to comment on in the video, but it doesn't take away from its essence. Cheers!

[@pc-doctor1416]

What can I say but WOW. Excel is so powerful. The biggest problem is remembering how to use all these brilliant features. A brilliant tutorial from the Excel guru.

[@yamilvogeld.2385]

Hi Leila! Thank you so much for your great videos!!! They are useful and you have the talent to walk us through your reasoning process, thats invaluable. Great job!! Keep it going

[@shivamp0120]

I learned some new functions along with the Take function. Vstack, Choosecol, Filter, Sortby, etc. were new to me. Thank you for such a wonderful video.

[@ruudb72]

Wow!...Thats a lot of possibilities in with a few simple commands. Thanks Leila for this great demo and practical use!

[@aahan1]

I'm loving the 'Breaking Bad' references. 😁😁

[@djwebmasster]

this one is PERFECT!!!!!!!!!!!!!!! thank you so much for the perspectives, different applications and formula combination examples!!

[@TravelRunner]

This is great! Such a clear explanation as well, thank you!

[@abdulsaidmkamara7305]

Thank you Leila , I was having a bad day and this video just made it better.

[@Oprimaita]

It's barely 8:00 am and I'm already inspired thanks to that tutorial. Thank you so much Leila for all you do!

[@vijayarjunwadkar]

Great Tutorial Leila on TAKE function! The function by itself is simple, but when combined with other functions, makes wonders, and you have shown it so perfectly and practically! Thank you so much!

[@LeilaGharani]

It can really be powerful. Glad I could inspire you 👍

[@sonyse2t5]

First time I seen this! ❤ Love the way you combined the Take with other functions.

[@joseantonioperez8273]

Hi Leila as lovely as always, I can see the potential of this function combining with other text and position functions, awesome thanks for sharing 🤩😍

[@obermeierro]

Wow! Excellent video. I really enjoyed you demonstrating how to combine functions.

[@valseguin]

My love of Excel is only increased when you show so many cool ways to use it. Thank you for a great video!

[@LeilaGharani]

Yay! Thanks, Valerie.

[@kevinhenry1681]

You are absolutely THE BEST!! Thanks Leila!

[@katestan7002]

This is one of my favorite function. Yesterday I found out how to subtract the previous cell from the last cell with TAKE and DROP. Super excited.

[@darrengodkin]

Super easy to follow tutorial and great examples to demo the power of this new function

[@hanifuzir9728]

Cool! I need to look deeper into the region setting part and how many more excel functions that are likely to be affected by the different region settings. 💆🏼

[@elphau]

loving that alert at 3:33 🙂 brilliant set up!

[@odewuyimichael3482]

I just got to know about the TAKE function and its amazing what results can be achieved using the function. Well done for sharing this knowledge.

[@mejabelajar]

It's an awesome function! great explanation. Thank you so much!

[@GurayVural-nz1lk]

Thanks a lot for the excellent explanations. Now, I can use the TAKE and VSTACK functions!

[@unnikrishnansanthosh]

wonderful, curly brackets was simply superb, thanks for sharing

[@syedishratzaidi7643]

Hi Leila! Thank you so much for your great videos!

[@arbazahmad7177]

Thanks for the Excellent Explanation....

[@nikhilmehta8128]

It's awesome how you use various formulas to achieve real life results, and you make it look so easy ❤

[@jasonswami9275]

Imparted very well Leila and the formulas are superb

[@antonynganga7868]

Great learning tips and new skills,thanks Leila❤

[@deltawing9]

Amazing skill transfer! Thank you so much!

[@DaveJ6515]

Ok, you definitely know how to teach things. Teaching has been my job for 40 years now, I know there is hard work behind this, very well done.

[@jerry5149]

Good presentation, thanks.

[@mohamedmehana4321]

Thank you for such a video with all of these sorts of combinations.

[@LeilaGharani]

You are so welcome!

[@lalocampo]

You always make it look so easy. Thank you

[@josilhus]

Excellent Video! A quite useful formula indeed. Will save me a lot of time ! Thanks for sharing

[@edwinjonah]

Amazing as always, thanks!

[@camillehenaine1651]

Thank you. This is extremely formative for me.

[@brotato1351]

The first use case I thought of for this function is for dynamic chart ranges. Almost every chart I update at work pulls from the last 6 or 12 weeks of data, and using a take formula in the source data selection would make that process super smooth and dynamic, and it’s a lot more straightforward than using offset.

[@ftdacademy]

love this! I wouldn't have known about this without you so thanks!

[@user-rc3ks4nc8q]

Thank you for sharing,it’s really helpful for me

[@chrism9037]

I have not used it so far but this definitely gave some good ideas, thanks Leila!

[@menfinnar]

Very well explained thank you!

[@ManishSingh-ds3qn]

Really awesome function and video, thanks

[@ExcelWithChris]

Great stuff! Thanks from South Africa.

[@SiemionekTM]

Leila, you are a STAR!!!

[@mozgus79ify]

The "new" Excel is so powerful and it's a pleasure to write formulas. But don't you miss the times we had to think hard to get the result and write 10 lines long formulas with helper columns and all the other secret tricks? 😂😉

[@mahsaomrauni]

Thank you for the valuable content you share . One suggestion I have is to consider toning down the emphasis on phrases like "to impress your boss" as we want to focus more on fostering a healthy and collaborative work environment and not impressing anyone at work. Keep up the great work! 🙌

[@leophrix]

I love your videos and explanations.

[@jasonperry6046]

This is fantastic, Thank you so much.

[@Emanemoston]

Thank you for the video.

[@JHatLpool]

Nice, clear demonstration.

[@canirmalchoudhary8173]

Very detailed explanations i liked it much

[@maikunthaung4136]

woo wonderful formula I never used before and thank you for sharing

[@gospelmoto2833]

You impress me everytime!

[@iskanderium]

I already know where I'm going to use it. Thank you!

[@motivationalhindustan1764]

Your contents are always great!!

[@izainonline]

1st time aware of this Function. Thanks

[@VishwasKadrolli]

This is amazing. Thanks!

[@nadermounir8228]

Very nicely explained 👏

[@sharifularif3665]

THIS IS AWESOME! Thank you!

[@urbaneplanner]

Great video - I recommend Leila’s paid courses on line - I worked through a set of vba ones, which were great - but I also like these freebie videos that are always quite practical

[@zagfat]

Love this Take film

[@turbalejo4999]

That was great! Thank you.!

[@patrickschardt7724]

I’ve been using TAKE/DROP with LET to reference an table and get the data and headers. One reference will give both. This allows for dynamic headers for reports

[@learningwithmaliha]

Amazing function. You have explained it wonderfully!

[@LeilaGharani]

Thanks a lot!

[@antoniskouroupis5030]

Εξαιρετικά. Θαυμάσια παρουσίαση.

[@EricAlainDufresne]

Phenomenal! Thanks.

[@markziundalestef2496]

I'd love to hear more about the new functions 👍. Your explanations are both helpful and instructive. Unfortunately, there is hardly anything to be found in the German area.

[@khanabdussabur8604]

Totally awesome leila, Thanks a lot.

[@MarkFreemanYVR]

Gold! Thank you!

[@ronaldoliver1700]

Fabulous as always. Thanks

[@anishyesudasan6701]

This is a great new function, thanks to that tutorial.

[@NeLzKieTV]

Nice Leila! Thanks for this video🎉

[@LeilaGharani]

My pleasure!

[@MrEocran]

Impressive as always ❤✌️

[@ScrtAznMann]

Thank you! This video helped me automate a tedious process in one of my monthly reports. Also, I loved the Breaking Bad references.

[@samanthadaroga4811]

A truly helpful video

[@richardhay645]

Great video! I have used TAKE since the day it became available to insiders. This is the first video I have seen with a practical example of its use and capabilities. It rather flew under the radar when first introduced partly because of its bad name. I have commented on other channels that it should have been called KEEP! BTW. The single cell combined formulas you crested could make great LAMBDAS.

[@sergegagne874]

Awesome, thank you!

[@joar1319]

Hi Leila, just discovered your content a short while ago and already bought one of your Udemy Courses. I want to bring myself to learn some basic VBA and I am still overwhelmed with all the possibilities why I try to digest each lecture one day after another. This brings me hopefully more forward than waiting for "that one day" where I have time and do it all or most of it which will probably never come. Also in this YT video shown I like youre style of structuring/editing your videos. The "takes" 1 to 4 are great and always show me where I am within that time frame of the content shown. Thanks again, BR

[@TK-jump]

LLMs are taking over those skills, don't waste your energy learning VBA.

[@ivanamarkovic9131]

Thank you Leila for this! Thank you ! Thank you

[@LeilaGharani]

You're so welcome!

[@Magurumadeps]

Thank You so much for all of awesome Yours tips 🙂 (btw curly brackets can write by Alt Gr + b for { and Alt Gr + n for } )

[@DinoDelight]

Brilliant 👏 👏 👏 👏 Thank you