- Precision cell selection
- Key PivotTable Improvements: Personalization, Automatic Relationship Detection, Time Grouping, Increase and Decrease Buttons, Field List Search, Smart Rename, Multi-Screen Slicer, Faster OLAP Pivot Tables, Create, Filter by Timelines
- New Data Analysis Capabilities
- New types of charts, 2D maps
- New formulas, Excel functions
- CSV (UTF-8) support
- Improved access to the latest files and folders and book Version history
- Data Protection (DLP) in Excel
- Publish to Power BI
- PowerPivot Enhancements
- Get & Transform (PowerQuery) improvements
- Insert SVG, icons and convert them to shapes, insert 3D models
- Improved handwriting support
PowerPoint
- Large Powerpoint Icon
- Morph transition
- Zoom effect to jump to specific slides, sections and parts of your presentations
- Scalable ink enhancement: Record digital colorful gestures, pens, markers and pencils, effects, layer eraser, ruler to draw straight lines at any angle, slide show control with gestures.
- Insert and manage icons, SVG and 3D models, convert SVG icons to shapes
- Improved drawing and free-form markings
- Export 4K video
Outlook
- Large Outlook icon
- Automatic download of OneDrive attachments
- Ability to see answers
- Focusing incoming
- Voice dictation and reading aloud
- Add multiple time zones to your calendar
- Mark emails as read when deleted
- Pop-up reminders
- Trip and delivery summary maps, updated contact cards.
- Improved availability check
- office 365 support (with Exchange online account)
Access
- Access icon got bigger
- 11 new charts to make it easier to understand the data stored in access forms and reports
- Bigint support
- Return the dBASE format of an import, link or export
- Sorting property sheet for forms and reports
- Shortcut Name property for controls
- Improved ODBC Reconnect Logic
- Keyboard shortcut for editing list item values (Ctrl + E)
- Accessibility improvements
Office 2021 will not has
- An editor and explorer of functions in Word.
- Tap in Word, PowerPoint and Outlook.
- PowerPoint Designer
- Ideas and data types in Excel.
- Sharing in real time in Word, Excel and PowerPoint.
- Encrypting office 365 Messages.
- Advanced Threat Protection in Word, Excel, PowerPoint, and OneDrive for Business
- Protection of corporate enterprises.
- Sensitive label support in Word, Excel, PowerPoint and Outlook.
- Shared Computer Licensing
- FastTrack parameters
- Integration with microsoft Intune