Microsoft Excel 2021 for Mac Features
Microsoft Excel 2021 is the newest addition to Microsoft's Office product family for Mac. It not only includes all of the already existing features and tools in a more visually appealing package, but comes with new additions and capabilities as well!
Control your Data
Analyze and visualize your data in new and intuitive ways with a fresh user interface plus your favorite keyboard shortcuts. Leverage features like Analysis Toolpak, Slicers, and Formula Builder to save time, so you can focus on insights.
Visualize Output
New charts and graphs are included with Excel 2016 to present your data in an exciting and compelling way. Utilize Sparklines, tables and graphs to help your work tell a story.
New Tools
Excels new tools work with you to suggest applicable charts or predict repetitive cell populating with duplicate data. Flash Fill is arguably the easiest way to reformat and rearrange your data. Excel learns and recognizes your pattern to auto-complete the remaining data, and requires no additional formulas or macros.
Simplified Sharing
Easily share your work with others to make collaboration even easier than before. When you save your workbooks, they are saved to SkyDrive or SharePoint by default. You are able to send links to the same file to as many people as you like, which includes their viewing and editing permissions; this way, you can be assured that everyone sees the latest version.
XLOOKUP
The XLOOKUP function is a game changer in Excel 2021 for Mac. Now, you can find anything much easier without spending precious minutes scrolling up and down your sheets, or using less efficient search functions!
The function can be used to find anything you need in tables or ranges with just one row. The search term will return results from any column on the same side of your table.
XMATCH function
With XMATCH in Excel 2021 for Mac, you can search for and return a specific item from an array or range of cells. You could also use this function to get the absolute position on one value within another array — which is really useful if we're trying to find cells at different intervals!
LET function
The LET function in Excel 2021 for Mac is a powerful addition that will help you as a spreadsheet user. It's especially useful for storing intermediate calculations, values or defining names inside formulas and outputting them all at once instead of one by one!
Watch your formulas
Excel 2021 for Mac enables you to “watch” cells across multiple sheets and workbooks in a single pane or window. This new Watch Window functionality makes it convenient to inspect, audit, or confirm formula calculations and results on large worksheets with ease as well!
The “Tell me” bar makes it to Mac
In-app search is an excellent way to find cells, commands and help without having to fire up your browser or ask for assistance. The new addition of the "Tell me" bar on Mac will let you enter keywords about what your next action should be so that Excel 2021’s features can be accessed more quickly than ever before!
Save as SVG
Save your pictures and graphics as SVG in Excel 2021 for Mac. The app now supports saving various elements from your documents with no loss of quality when upscaling. The new feature allows you to resize these SVG files without it affecting how they look when displayed on screen or printed out!
Sketched style outline
Try out the Sketched style outline in Excel 2021 for Mac. You can give a casual, hand-drawn look to shapes with this new feature and it's easy as pie! Try out the Curved, Freehand, or Scribble options for some unique looks to add interesting visual touches to your Excel spreadsheets.