Everyone's Talking About This NEW Excel Function (TRIMRANGE)
Автор: MyOnlineTrainingHub
Загружено: 2024-10-21
Просмотров: 180336
New Excel TRIMRANGE Function Explained
Download the example/practice file here: https://www.myonlinetraininghub.com/e...
👩🏫 Master Excel with my courses: https://bit.ly/trimrange24courses
▶️ Learn more about the BYROW function: • 2 NEW Excel Functions ELIMINATE Copying Fo...
There's a new function just released in the beta version of Excel that will save you a ton of time. It's called TRIMRANGE! It’s nothing like the TRIM function.
TRIMRANGE automatically detects the cell range your data occupies and expands and contracts with it. You no longer need to write dynamic named range formulas with OFFSET or INDEX.
There’s also a new dot operator shorthand for TRIMRANGE that simplifies referencing dynamic ranges even further.
It’s got the Excel fans on Reddit excited about how this new functionality will simplify and streamline formulas.
TRIMRANGE is still in preview, so keep in mind that the syntax and functionality may change before it’s generally available.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
#Excel #ExcelFunctions #TRIMRANGE
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![Продвинутый метод Excel, о котором вам никто не рассказывал [Комбинация DROP REDUCE LAMBDA STACK]](https://image.4k-video.ru/id-video/kBhRyXkqefI)
