Office Scripts Buttons: Microsoft Announcement.

Keyboard Shortcuts for Web: Microsoft Announcement.

Text to Columns: Microsoft Announcement.

Power Query Pane: Microsoft Announcement.

Searchable Dropdown Lists: Excel Campus List Search Add-in | Microsoft Announcement.

Smooth Scrolling: Excel Campus YouTube video on Smooth Scrolling| Microsoft Announcement.

Horizontal Scroll Shortcut: Excel Campus YouTube video on 7 Excel Tips.

Excel Data Type APIs: Bill Jelen's YouTube video on Data Type APIs | Microsoft Announcement.

Accessibility Ribbon: Microsoft Announcement.

Visual Update & QAT Button Names: Microsoft Announcement.

Wolfram Data Types: Microsoft Announcement.

LAMBDA Helper Functions: Microsoft Announcement.

Show Changes: Excel Campus YouTube video & post on Show Changes | Microsoft Announcement.

Resize Conditional Formatting Box: Microsoft Announcement.

Navigation Pane: Microsoft Announcement.

Unhide Multiple Sheets: Microsoft Announcement.

These are the features that stood out the most to me, but feel free to leave a comment below if there are any of your favorites that I missed.

There were so many updates last year, that I had a difficult time narrowing down the list to just 21 features. I absolutely love all the new additions to Excel. This includes everything from new keyboard shortcuts to advanced (Lambda) functions for complex array formulas.

The Windows, Mac, web, and mobile versions of Excel all received cool new updates that will help us get our jobs done faster. Over the past few years, Microsoft has released a ton of updates to Excel.

Watch on YouTube & Subscribe to our Channel I Love Excel Updates!

Excel 2021 for mac