Should You Upgrade to Office 2021? Excel Users MUST Watch...

Share
Leila Gharani
Published at : 14 Oct 2021
24143 views
1412
7

Microsoft just released Office 2021 which is available for both macOS and Windows. It’s made for those who do not want to enroll in the subscription model of Microsoft 365. For Excel users this is a huge jump from Excel 2016 or Excel 2019. At least 9 new functions were introduced which will change the way you use Excel. This includes XLOOKUP, FILTER, UNIQUE, and SEQUENCE.
In this video I’ll quickly explain these new functions and also which additional features you can look forward to in PowerPoint, Word and Outlook.
(Note: What’s NOT included in Excel for Office 2021 are the new Lambda and Lambda helper functions).

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

00:00 What’s New in Office 2021
01:20 The UNIQUE Function
02:15 The FILTER Function
03:37 The SORT Function
04:58 The SORTBY Function
05:36 The XLOOKUP Function
07:33 The XMATCH Function
08:50 The SEQUENCE Function
10:09 The RANDARRAY Function
11:07 The LET Function
12:05 New Features in Excel 2021
13:38 What’s New in PowerPoint 2021
14:17 What’s New in Word 2021
14:31 What’s New in Outlook 2021
14:44 Wrap Up
14:58 My Recommendation

Link to Blog post: https://www.xelplus.com/office-2021-new-features/

🎬 LINKS to related videos:
Office 2021 official info: https://support.microsoft.com/en-us/office/what-s-new-in-office-2021-43848c29-665d-4b1b-bc12-acd2bfb3910a
Excel Functions in 2021: https://youtu.be/_EWcAR_Hkvg
How to Use XLOOKUP: https://youtu.be/4c0CLUER6nw
The New FILTER function: https://youtu.be/Eehk6PC0oGs
The LET function: https://youtu.be/D5HgyE06pXs
Dynamic Calendar with SEQUENCE: https://youtu.be/xmw1ydfpo_Q
Outlook Search: https://youtu.be/z_-Zn5e7asQ
How to make a video in PowerPoint: https://youtu.be/hisnhKK94nI

🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

🎥 GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #microsoftoffice

XelplusVisLeila GharaniAdvanced Excel tricks

Pistol, Bear Spray or Both? | Clay Newcomb Learns Bear Defense | Presented by Taurus

Pistol, Bear Spray or Both? | Clay Newcomb Learns Bear Defense | Presented by Taurus

Samoa look ahead to clash against star-studded Barbarians | RugbyPass

Samoa look ahead to clash against star-studded Barbarians | RugbyPass

George Michael - An Easier Affair | Lyrics

George Michael - An Easier Affair | Lyrics

Russia-India Dispute | Important Development in Region | Imran Khan Exclusive Analysis

Russia-India Dispute | Important Development in Region | Imran Khan Exclusive Analysis

How Wheelbarrows Are Made | Amazing Technique of Making Wheelbarrows From Old Oil Drum Sheet.

How Wheelbarrows Are Made | Amazing Technique of Making Wheelbarrows From Old Oil Drum Sheet.

Shamirah Nalumansi yewunyisizza maama we omuto eyamubelelawo mulungeendolwe olwokuyingilla  America

Shamirah Nalumansi yewunyisizza maama we omuto eyamubelelawo mulungeendolwe olwokuyingilla America

Tales of Arise - Let's Play Part 58: Unsightly Tower

Tales of Arise - Let's Play Part 58: Unsightly Tower

MAGNETO Was Right (And Should Have Led the X-Men) + How He Would Have Prevented "Logan"

MAGNETO Was Right (And Should Have Led the X-Men) + How He Would Have Prevented "Logan"

Complication exclusivite et nouveaute film nigerian en francais complet 2021 nollywood

Complication exclusivite et nouveaute film nigerian en francais complet 2021 nollywood

Bead Box Bargains DIY Jewelry Making Finds November 2021

Bead Box Bargains DIY Jewelry Making Finds November 2021

Renovating old wooden houses in rural China | workers HD

Renovating old wooden houses in rural China | workers HD

Damon Being Protective

Damon Being Protective

FUN-TO-FIGHT Guilty Gear Strive Tier List

FUN-TO-FIGHT Guilty Gear Strive Tier List

Evening Dresses - Evening Gowns For Women - FORMAL EVENING DRESSES

Evening Dresses - Evening Gowns For Women - FORMAL EVENING DRESSES

😍Smart Appliances, Gadgets For Every Home/ Versatile Utensils(Inventions & Ideas)/ MakeupKitchen

😍Smart Appliances, Gadgets For Every Home/ Versatile Utensils(Inventions & Ideas)/ MakeupKitchen

Legendary HBO S1 E3 Circus - Best Moments & Judging Drama Gucci vs Dominique

Legendary HBO S1 E3 Circus - Best Moments & Judging Drama Gucci vs Dominique

PKA 572 W/Harley: Kyle vs Diego Sanchez, How To Shower, Harley is boxing

PKA 572 W/Harley: Kyle vs Diego Sanchez, How To Shower, Harley is boxing

STEP IN ATTAINING YOUR DREAM

STEP IN ATTAINING YOUR DREAM

You are Just An Option, Not A Priority, If You Experience Any Of These 6 Signs

You are Just An Option, Not A Priority, If You Experience Any Of These 6 Signs

#Vanithabhimani - Empowering and Encouraging Women in Sabaragamuwa

#Vanithabhimani - Empowering and Encouraging Women in Sabaragamuwa

Double Your House For Half The Money | Buckinghamshire and Sydenham | S01 E05 | All Homes

Double Your House For Half The Money | Buckinghamshire and Sydenham | S01 E05 | All Homes

Snowstorm Forces Shoppers To Spend The Night in Danish IKEA

Snowstorm Forces Shoppers To Spend The Night in Danish IKEA

Simple Takeaway Drill That Could be a GAME CHANGER

Simple Takeaway Drill That Could be a GAME CHANGER

High IQ dog buying groceries alone🤗Two funny dogs stealing oranges😅

High IQ dog buying groceries alone🤗Two funny dogs stealing oranges😅

Place Of Worship

Place Of Worship

Dr Joe Dispenza - Connect To Quantum Fiel With Meditation

Dr Joe Dispenza - Connect To Quantum Fiel With Meditation

Principally Speaking 11-12-21

Principally Speaking 11-12-21

9 Life Saving PERIOD HACKS You MUST Try | #Sketch #Comedy #Anaysa

9 Life Saving PERIOD HACKS You MUST Try | #Sketch #Comedy #Anaysa

Minecraft, But There Are Infinity Items..

Minecraft, But There Are Infinity Items..

People Living the Life I want

People Living the Life I want

How to use FOR and SINCE to denote time

How to use FOR and SINCE to denote time

27. Commonly used idioms with the word keep.  part 2

27. Commonly used idioms with the word keep. part 2

Στην ΚΟΨΗ του Gaming: Τα Περιφερειακά για το PC των 7.000€

Στην ΚΟΨΗ του Gaming: Τα Περιφερειακά για το PC των 7.000€

Nasa's Mars Perseverance Curiosity captured Two doors that may be the dwelling of huge monsters!

Nasa's Mars Perseverance Curiosity captured Two doors that may be the dwelling of huge monsters!

Six membered heterocyclic Compound,Pyridine

Six membered heterocyclic Compound,Pyridine

SINIRSIZ XP ve İNCİ! | ADŞ İLE MINECRAFT SURVIVAL #21

SINIRSIZ XP ve İNCİ! | ADŞ İLE MINECRAFT SURVIVAL #21

Creative Art ideas | Best art and decorative idea.

Creative Art ideas | Best art and decorative idea.

*HUGE NEWS ABOUT NEW EXPERTISE LEVELING SYSTEM* The Division 2 - Intelligence Annex: Expertise

*HUGE NEWS ABOUT NEW EXPERTISE LEVELING SYSTEM* The Division 2 - Intelligence Annex: Expertise

Play Nicely

Play Nicely

1. Getting familiar with SEARCHnPLAY's basic use

1. Getting familiar with SEARCHnPLAY's basic use

Dream of every girl😂 #shorts by Tsuriki Show

Dream of every girl😂 #shorts by Tsuriki Show

You Shrunk My Clothes?

You Shrunk My Clothes?

Sanchit और Vartika का यह Performance आपको भी करदेगा झूमने पर मज़बूर! | Super Dancer 4 | सुपर डांसर 4

Sanchit और Vartika का यह Performance आपको भी करदेगा झूमने पर मज़बूर! | Super Dancer 4 | सुपर डांसर 4

Too Many To Choose From

Too Many To Choose From

Marvin Sease - I Gotta Clean Up

Marvin Sease - I Gotta Clean Up

New PNP chief Carlos to focus on fight against terrorism, rebels

New PNP chief Carlos to focus on fight against terrorism, rebels

Finance & Corporate Committee - Zoom Meeting

Finance & Corporate Committee - Zoom Meeting

sleek bun tutorial (model inspired)

sleek bun tutorial (model inspired)

Squid Game Makeup Removal of Special Effects (SFX) Makeup vs No Makeup  | Goodzik

Squid Game Makeup Removal of Special Effects (SFX) Makeup vs No Makeup | Goodzik