⚡NEW Excel Functions - TAKE and DROP

Video Description

TAKE and DROP are two new Excel functions that can be used to extract data from a dataset. TAKE function allows you to Extract a specific number of rows or columns from the beginning or end of the data set. And, the DROP function allows you to extract everything after dropping the specified number of rows or columns from the beginning or end of the data set. While these functions are useful, in most cases, you will be using them with other Excel functions. I will cover some examples where I have used the TAKE function and DROP function with other functions such as FILTER and SORT 00:00 Intro 00:04 TAKE Function 01:59 DROP Function 03:07 TAKE + CHOOSECOLS 04:33 Using TAKE with SORT Function 06:46 Using TAKE with FILTER Function ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 #Excel #ExcelTips #ExcelTutorial #SumitBansal