How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues #howto
Join 300,000+ professionals in our courses:
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.
🌍 My Online Courses ►
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
➡️ Join this channel to get access to perks:
🎬 LINKS to related videos:
Excel VSTACK: Quickly Combine Data from Multiple Sheets:
How To Use Excel FILTER Function With Multiple Criteria:
👕☕ Get the Official XelPlus MERCH:
🎓 Not sure which of my Excel courses fits best for you? Take the quiz:
🎥 RESOURCES I recommend:
More resources on my Amazon page:
🚩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!