Extract Data with Dynamic Functions TAKE and DROP | Excel 365

Are you tired of doing the same data analysis over and over? What if I told you that you could set up a one-time function to do the heavy lifting for you?

In this tutorial, I unveil Microsoft’s relatively new functions, TAKE and DROP, designed to revolutionize your data analysis workflow. This video is not just about the “how,” but also the “why.”

✨ Join me as I break down these simple yet powerful tools that promise to keep you out of the weeds for good. Let’s transform the way we interact with data together!


00:00 Introduction
00:56 How to use TAKE
01:22 Return First 10 Rows
01:53 Return Last 10 Rows
02:40 Top 5 Values Sorted by Column
04:28 Lowest 5 Values Sorted by Column
04:52 Highest Enrollment by District
08:43 Lowest Enrollment by District
10:58 How to use DROP

[AndrewBennettScience]

Nice! Great new functions, and I appreciate the clear use cases!

[veruscrt]

Again, I'm the first one to learn, and your tutorials are wonderful.