- Excel 2013 uses a Single Document Interface (SDI). Each workbook opens in a separate window. This is long overdue because a fair number of power users are on two screens and Excel pre 2013 loads all the workbooks into the same window unless you run Excel empty as another instance and then use File . Open to load the next workbook you want to use. So SDI is good. However, it is said to give macros that switch workbooks some issues.
- Excel 2013 has an Quick Analyze pop up icon at the bottom right corner of a dense block of cells. This offers options to carry out charting, creation of tables, pivot tables, conditional formatting, add subtotal row. However, it seems to automatically choose the columns in your block of cells to carry out this operation. I can't yet see the usefulness in that.
- Excel 2013 seems to have lost the tin stubs at the end of the scroll bars. I like using them to split a window into panes. The Command Ribbon . Views Tab still has the Split Window icon.
- For the new generation Excel, 2007 and later, creation of a table in the workbook blocks the use of the Views . Custom Views feature.
- You can use Custom Lists for Advanced Sorting in Excel 2007 and later. But Custom Lists are stored in the specific Windows registry of the machine (MSKBID 213796). You can produce lists on a worksheet, then run a macro to take those lists and push them into the registry of another machine.
More as I encounter