Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

How to use advanced sorting options in Excel Once you’ve mastered the simple sorts–alpha and numeric–you might want to check out the advanced sorting options.