This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

You don’t have to struggle or scratch your head when it comes to using Microsoft Excel. This guide for beginners will get you off to a solid start with Excel.

Now, if we add more values to column A, Excel will automatically extend the LEN function downwards. Excel also lets you be more targeted with your use of TRIMRANGE by using Trim References.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.