Learn how to master custom sorting in Excel with SORTBY, LET, and XMATCH. Organize data dynamically and save time with advanced techniques.

We show you how to put data in alphabetical order in Excel, sorting columns, rows, and using handy shortcuts.

Getting to grips with Excel's text functions will be invaluable if you need to split a single column into multiple columns, or create a single column from multiple columns. Peter Hool's Expert guide ...