Body
New features included In this version.
Excel:
- New XLOOKUP function: Targeted search for multiple variables and keywords or for an arrangement of selected elements in Excel tables
- New XMATCH function: Targeted position search of keywords and variables in a selected row range
- New LET function: Assigns names to specific results of a calculation
- New functions with support for dynamic arrays
- Write one formula and return an array of values. Expedite calculations and insights with six new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
- Support for OpenDocument 1.3
- Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
Word:
- Support for OpenDocument 1.3
- Reduce eye strain with Dark Mode
- Improve cohesion with Line Focus
- Updated Draw tab
- Quickly access and change the color of all your inking tools in one place
PowerPoint:
- Recording of speaker videos as well as laser pointer and freehand recordings
- Optimization of presentations for screen readers
- Sketching feature enables freehand drawings in presentations
- Record and playback capabilities for illustrations that were created with PowerPoint
- Export presentations in video format for reuse online
Outlook:
- Instant search with improved filtering options
- Translate feature (over 70 languages)
- Freehand drawing with ink feature
To access the training for Office 2021, please complete the following steps:
- Go to https://troy.knowledgecity.com/
- Click the Log In button at the top right corner of the screen
- Select Use My Company Credentials
- After you have successfully logged in, click the search icon at the top of the screen (Magnifying Glass icon next to the Home tab)
- Type in Office 2021 and select the appropriate training module