YouTube on MSN

Stop overcomplicating Excel formulas: Just use the dot

In this video, learn how to use the dot operator in Excel to simplify adding formulas. Discover how to avoid unwanted zeros ...
Hosted on MSN

How to Use TRIMRANGE & Trim Ref Operators to Tidy Up an Excel Spreadsheet

Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, INDEX, or TOCOL? TRIMRANGE detects the cells your data occupies and ...