Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We walk through simple methods using built-in Excel tools to organize your ...