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

Показать описание

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.

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:

🚩Let’s connect on social:

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

Рекомендации по теме

Комментарии

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.

MrSupernova

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! ❤❤

sevaspeto

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!!

reng

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!

Donkeys_Dad_Adam

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 !

jimloader

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

PeymanSayyadi

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!

fiattenebris

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.

AngelGonzalez-ceki

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

uchewilliam

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!

vijayarjunwadkar

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

CJ-gnud

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

yamilvogeld.

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.

shivamp

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.

katestan

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.

brotato