Advertisement

Stop Writing Huge Excel Formulas. (Use ONE DOT Instead)

By Leila Gharani 10:24 1,107,715 views on YouTube Watch on YouTube
🔥 500,000+ professionals trust our courses—become an Excel Black Belt 👉 https://www.xelplus.com/course/excel-black-belt/
or checkout our other courses: https://www.xelplus.com/courses
Stop fighting with empty cells and zeros in your Excel reports. This video introduces the revolutionary "Trim Refs" (dot notation) and the TRIMRANGE function—a feature designed to automatically clean leading and trailing empty cells from your dynamic arrays.

đź”— Get my free practice file here: https://www.xelplus.com/trimrange-function-excel/#download

TRIMRANGE is a new feature in Excel 365 that allows you to reference an entire column while "trimming" the empty spaces. By adding a simple dot (.) to your ra…
Ready for your next step?

Put these tips to work — thousands of new jobs are added every day.

Browse jobs Get job alerts

This video is shown with YouTube's player and belongs to its creator, Leila Gharani.

Report this video