Microsoft Office 2021

We are currently transitioning from Office 2019 to the updated version of Office 2021.  In this new version, there are some notable features for multiple Office applications.

Attached here is the link to the deployment schedule for the Office 2021 roll out: https://it.troy.edu/projects/mo2021-upgrade.html

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

 

Details

Article ID: 157132
Created
Wed 2/14/24 11:30 AM
Modified
Mon 2/19/24 1:29 PM