The new features in the perpetual license version of Excel 219 are most italic of the features added to the Office 365 subscription license version of Excel 216 after its initial release. I say most because the feature set for Excel 219 perpetual license version will be frozen at some point in time but features continue to be added to Excel 216 subscription version after then. New features are added to the subscription (Office 365) version of Excel almost every month. The pace of change is much faster than I have seen from Microsoft previously. I expect the perpetual license version of Excel 219 to include these new features (already in subscription Excel 216 but not in perpetual license Excel 216) Coauthoring (simultaneous editing by two or more people) for files saved on OneDrive New functions CONCAT TEXTJOIN MINIFS MAXIFS IFS & SWITCH Better integration with PowerBI for analyzing big data Better ability to import and condition data using menu items on DataGet and Transform New chart s like Funnel & Map charts Ink markups to a worksheet including ability to view them in step by step fashion Accessibility improvements for users with disabilities. These include integration with screenreaders narrators alternative Icons for subscript & superscript so you can put them on the QAT Personalized PivotTable layouts AutoSave for files stored on OneDrive. This feature saves a copy of the file every few seconds and lets you restore any italic of the previous versions. Reduces the chance of losing your work to near zero. Office Training Center with videos and webpages to better train users on troublesome features like VLOOKUP. Features are selected based on how many searches are made for help on them. Scaleable Vector Graphics for Icons that you can insert in a worksheet or any Office file If you mistakenly include an object when making a selection you may now Deselect it Robustness. Excel had gradually be more prone to slowdowns or crashes over recent versions. Many of the causes for these problems have been fixed. Translate words or even entire documents in a task pane The subscription version of Excel 216 will be Excel 219 this Fall. Think of it as Excel . Some of the features it will include already appear in Office Insider releases of the subscription version of Excel 216. Other features were demoed under a Non-Disclosure Agreementso I won mention them. Im sure that there will be still more features added in future months that I will bepletely surprised by. Remember each Office app gets new features almost every month if you have a subscription version. New Data Types. Live stock prices with time delay (and 3 other properties) for 75 tickers from exchanges around the world. Data (1 to 5 properties) on cities regions provinces and countries. Chat window within Excel when you are coauthoring Accessibility checker so you can identify features that need to be addressed so a workbook is fully accessible to a user with color blindness blindness or limited vision Smart lookup. Select a word or phrase then have Excel look it up for you on the web. Results displayed in a task pane.