Uploaded April 2023 | Updated September 2026, 14 hours ago
Join 300,000+ professionals in our courses: xelplus.com/courses
You're going to love the new TAKE function in Microsoft Excel! It let's you dynamically take the parts of a data set (rows or columns) you need. Basically you can use a function to keep the rows you need and discard the rest. In this video I'll show you how it works.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
🌍 My Online Excel Courses ► xelplus.com/courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
👉 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
Join 300,000+ professionals in our courses: xelplus.com/courses
You're going to love the new TAKE function in Microsoft Excel! It let's you dynamically take the parts of a data set (rows or columns) you need. Basically you can use a function to keep the rows you need and discard the rest. In this video I'll show you how it works.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
🌍 My Online Excel Courses ► xelplus.com/courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
👉 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
