Dot Operator will CHANGE how you Write Formulas in Excel | TRIMRANGE Function
Computergaga
@computergagaAbout
Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.
Latest Posts
Video Description
The TRIMRANGE function and dot operator in Excel are game changers. They will change how you write formulas in Excel. Stop dragging Excel formulas and start creating single-cell Excel formulas. They're faster, consistent, dynamic and robust. The dot operator and TRIMRANGE formula are the keys to the one-cell formula dream. 📚 Resources Practise file from the video - http://computergaga.com/_excel/files/formulas/trimrange-formula.xlsx 📺 Related Videos https://youtu.be/yaI7lTLnXrs - TAKE & DROP functions in Excel https://youtu.be/kd3qdL0BxSM - 3 best ways to write running totals in Excel https://youtu.be/35KgLRJhd8Q - BYCOL & BYROW functions in Excel ⌚ Timings 00:00 Pitfalls of dragging formulas in Excel 01:12 TRIMRANGE function in Excel 03:50 Introducing the dot operator in Excel 05:04 Trimming entire column references 05:34 DROP function to remove headers 07:15 Dot operator with rows 09:49 Dynamic formula expansion Get your Free 40 Incredible Excel tips book here ⬇️ https://bit.ly/49y6Ox3 #excel #excelformulas #trimrange
You May Also Like
Excel Power User Essentials
AI-recommended products based on this video
