Microsoft released a new version of Office – 2021, this is a one-time payment version (different from Office 365 where you pay a subscription each month). I go through the new features across all the apps that may help you decide whether to upgrade. Some game-changing features include XLOOKUP (replacing Excel’s VLOOKUP) and dynamic arrays where formulas can now return multiple cells as outputs and stock photos built into PowerPoint. Word & Outlook have cool new features too, so check them out. Note these features also exist in Office 365 and have done for a while.

I also explain briefly what you don’t get (i.e. what Office 365 has but not 2021) and new features you may have missed from Office 2019.

New features listed: https://support.microsoft.com/en-us/office/what-s-new-in-excel-2021-for-windows-f953fe71-8f85-4423-bef9-8a195c7a1100

Buy Office 2021 or Office 365: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2021

00:00 – Introduction
01:51 – Coauthor
02:08 – Modern comments
03:04 – Excel: Workbook stats
03:24 – Sheet view
03:52 – Excel: Dynamic arrays
07:26 – XLOOKUP
08:56 – LET
09:46 – Stock images
11:32 – Image transparency
11:50 – Accessibility checker
12:08 – Screen reading order
12:30 – Get link to slide
12:55 – Hex code
13:14 – Sketched outline
13:47 – Word dark mode
14:18 – Line focus
14:59 – Translate emails
15:41 – Save all attachements
17:10 –

Please take the opportunity to connect and share this video with your friends and family if you find it useful.