💡 This One DOT Will Change How You Write Excel Formulas Forever

Video Description

In this video, I will show you how to use the new TRIMRANGE function in Excel, along with the DOT operator trick that you can use instead of using the function name. TRIMRANGE is a new function available in Excel with Microsoft 365 and Excel on the Web. With this new function and the DOT operator, you can select an entire range, and it will automatically remove any blank rows or columns around the edges of the filled cells. ➡️ Download Example File: Here is the link to the practice file - https://www.dropbox.com/scl/fi/4sm03mrsi4glargmcgisl/Dot-Operator.xlsx?rlkey=0szb5184txrg2i6uiuewb8q1u&dl=1 ➡️ XLOOKUP Video (where DOT doesn't work) - https://youtu.be/y0L-QzTkwcA 00:00 Intro 00:36 TRIMRANGE Function and the DOT Operator 04:25 DOT Operator in Action 05:13 Using DOT Operator with TAKE and DROP 07:28 Creating a Dynamic Drop-Down List 09:10 Using the Dot Operator with the TRANSPOSE Function 10:16 Combine Tables Easily 12:34 When the DOT Operator Does Not Work 15:22 Performance Test of the DOT Operator ☕ 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://trumpexcel.com/excel-vba-course/ ✅ Free Power Query Course - https://trumpexcel.com/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