(TRIMRANGE) The NEW Excel Function that CHANGES EVERYTHING!
In this video, I'll teach you how to use the new TRIMRANGE function and the new POINT operator. Both the TRIMRANGE function and the POINT operator will make it easier to handle empty cells in your spreadsheets.
INDEX:
00:00 Introduction to the TRIMRANGE function and the DOT operator
00:17 Basic example on the TRIMRANGE function and the DOT operator
02:03 Using the DOT operator in Excel
03:08 Using the TRIMRANGE function in Excel
05:25 Extracting unique data with the TRIMRANGE function and the DOT operator
07:34 Creating dynamic charts with the TRIMRANGE function and the DOT operator
11:55 Combining data with the TRIMRANGE function and the DOT operator
16:24 Using the TRIMRANGE function and the DOT operator to create drop-down lists
19:01 Using the TRIMRANGE functions and the DOT operator to transpose data
📗 File Work:
https://t.me/Enriquexls
🔴Whatsapp Group
https://chat.whatsapp.com/IUt0uwSbPCQ...
✅Other useful videos:
🎦How to activate DARK MODE in Excel?
• ⚫ Microsoft Libera el MODO OSCURO en EXCEL...
🔴Do you want to learn Excel for free?
https://www.youtube.com/@enriquexls?s...
#EnriqueXLS #excel #exceltutorial