In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't support sorting across multiple columns. For example, I might want to sort column A then sort columb B within column A.
Is there a way to achieve this using native functionality that doesn't involve having to write a macro? I am also excluding the use of Excel's sort option from the toolbar/ribbon since this is a more advanced feature than not many novice Excel users (business owners, other higher-ups, etc) know how to use.