today we are going to look at the brand new office 2021 and all of the new features this is the latest one-time purchase option for desktop apps like word excel and powerpoint since office 2019. if you want to know what are all the different plans and how does this compare to microsoft 365 check out the video right up above in this video we’re purely looking at what’s new in office 2021 before we get started to watch more videos like this one please consider subscribing all right let’s check this out you now have something called real time co-authoring and that’s available in word excel and powerpoint this allows you to work with others on the same document the one caveat is your document has to be stored in onedrive but you can access at least five gigabytes for free you also get access to modern comments you can see who’s in your document at the same time there’s also been a visual refresh and it matches the look of windows 11. you’ll see rounded windows a more neutral color palette and just overall a softer look you also get access to stock images and icons you can use microsoft search in the apps to look for functionality or help your documents will now auto save this way you don’t have to worry about constantly pressing ctrl s you can now save documents in the open document format or odf there is an updated draw tab you could use this sketched style outline you could enter hex colors in the color picker there have also been performance updates across the board in excel there are now many new functions there’s a new one called x lookup which is quite a bit better than vlookup it allows you to look things up in your spreadsheet if you want to learn more about x lookup check out the video right up above you can now also use dynamic arrays like filter sort sort by and there are many others you can use the let function and with the let function you can assign names to calculation results you can also use x match and with this function you can search for a specified item in an array and you can get the relative position back you can also set up various sheet views to help you get back to the view that you care about in powerpoint you can now record your presentation using video and audio you can also record your inking on a slide in outlook you can now instantly search for messages and lastly you can also ink to annotate your message in outlook in word there’s something new called line focus which helps you read a document by just focusing on one line at a time lastly microsoft teams now comes bundled together with office previously you could download microsoft teams but now it just comes with office so you no longer have to go out to get it all right that wraps up what’s new in office 2021 compared to office 2019. if you want to see a list of everything that’s new i’ve included a link in the description down below to watch more videos like this one please consider subscribing i’ll see you next time [Music] you